//------------------------------------------------------------------------------
// <auto-generated>
//    This code was generated from a template.
//
//    Manual changes to this file may cause unexpected behavior in your application.
//    Manual changes to this file will be overwritten if the code is regenerated.
// </auto-generated>
//------------------------------------------------------------------------------

namespace AIAHTML5.ADMIN.API.Entity
{
    using System;
    using System.Data.Entity;
    using System.Data.Entity.Infrastructure;
    using System.Data.Objects;
    using System.Data.Objects.DataClasses;
    using System.Linq;
    
    public partial class AIADatabaseV5Entities : DbContext
    {
        public AIADatabaseV5Entities()
            : base("name=AIADatabaseV5Entities")
        {
        }
    
        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            throw new UnintentionalCodeFirstException();
        }
    
        public DbSet<AccountType> AccountTypes { get; set; }
        public DbSet<AIAUser> AIAUsers { get; set; }
        public DbSet<Edition> Editions { get; set; }
        public DbSet<UserType> UserTypes { get; set; }
    
        [EdmFunction("AIADatabaseV5Entities", "fnSplit")]
        public virtual IQueryable<fnSplit_Result> fnSplit(string sInputList, string sDelimiter)
        {
            var sInputListParameter = sInputList != null ?
                new ObjectParameter("sInputList", sInputList) :
                new ObjectParameter("sInputList", typeof(string));
    
            var sDelimiterParameter = sDelimiter != null ?
                new ObjectParameter("sDelimiter", sDelimiter) :
                new ObjectParameter("sDelimiter", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.CreateQuery<fnSplit_Result>("[AIADatabaseV5Entities].[fnSplit](@sInputList, @sDelimiter)", sInputListParameter, sDelimiterParameter);
        }
    
        [EdmFunction("AIADatabaseV5Entities", "udf_SplitString")]
        public virtual IQueryable<udf_SplitString_Result> udf_SplitString(string list)
        {
            var listParameter = list != null ?
                new ObjectParameter("List", list) :
                new ObjectParameter("List", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.CreateQuery<udf_SplitString_Result>("[AIADatabaseV5Entities].[udf_SplitString](@List)", listParameter);
        }
    
        public virtual int abc(Nullable<int> userId, string labExerciseIdentifier, Nullable<int> lastQuestion, Nullable<int> totalQuestions)
        {
            var userIdParameter = userId.HasValue ?
                new ObjectParameter("UserId", userId) :
                new ObjectParameter("UserId", typeof(int));
    
            var labExerciseIdentifierParameter = labExerciseIdentifier != null ?
                new ObjectParameter("LabExerciseIdentifier", labExerciseIdentifier) :
                new ObjectParameter("LabExerciseIdentifier", typeof(string));
    
            var lastQuestionParameter = lastQuestion.HasValue ?
                new ObjectParameter("LastQuestion", lastQuestion) :
                new ObjectParameter("LastQuestion", typeof(int));
    
            var totalQuestionsParameter = totalQuestions.HasValue ?
                new ObjectParameter("TotalQuestions", totalQuestions) :
                new ObjectParameter("TotalQuestions", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("abc", userIdParameter, labExerciseIdentifierParameter, lastQuestionParameter, totalQuestionsParameter);
        }
    
        public virtual int ClearSessionManager(string sSessionId)
        {
            var sSessionIdParameter = sSessionId != null ?
                new ObjectParameter("sSessionId", sSessionId) :
                new ObjectParameter("sSessionId", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("ClearSessionManager", sSessionIdParameter);
        }
    
        public virtual ObjectResult<string> DA_GetBackGroundArtList(Nullable<int> body_view_id, string sex)
        {
            var body_view_idParameter = body_view_id.HasValue ?
                new ObjectParameter("body_view_id", body_view_id) :
                new ObjectParameter("body_view_id", typeof(int));
    
            var sexParameter = sex != null ?
                new ObjectParameter("sex", sex) :
                new ObjectParameter("sex", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("DA_GetBackGroundArtList", body_view_idParameter, sexParameter);
        }
    
        public virtual ObjectResult<DA_GetBaseLayer_Result> DA_GetBaseLayer(Nullable<int> layer_id)
        {
            var layer_idParameter = layer_id.HasValue ?
                new ObjectParameter("layer_id", layer_id) :
                new ObjectParameter("layer_id", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<DA_GetBaseLayer_Result>("DA_GetBaseLayer", layer_idParameter);
        }
    
        public virtual ObjectResult<DA_GetBitmask_Result> DA_GetBitmask(Nullable<int> image_id, Nullable<int> zoom)
        {
            var image_idParameter = image_id.HasValue ?
                new ObjectParameter("image_id", image_id) :
                new ObjectParameter("image_id", typeof(int));
    
            var zoomParameter = zoom.HasValue ?
                new ObjectParameter("zoom", zoom) :
                new ObjectParameter("zoom", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<DA_GetBitmask_Result>("DA_GetBitmask", image_idParameter, zoomParameter);
        }
    
        public virtual ObjectResult<DA_GetBodyRegion_Result> DA_GetBodyRegion()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<DA_GetBodyRegion_Result>("DA_GetBodyRegion");
        }
    
        public virtual ObjectResult<string> DA_GetBodyRegionList()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("DA_GetBodyRegionList");
        }
    
        public virtual ObjectResult<DA_GetBodyRegionView_Result> DA_GetBodyRegionView()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<DA_GetBodyRegionView_Result>("DA_GetBodyRegionView");
        }
    
        public virtual ObjectResult<string> DA_GetBodyRegionViewList()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("DA_GetBodyRegionViewList");
        }
    
        public virtual ObjectResult<DA_GetDissectibleContent_Result> DA_GetDissectibleContent()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<DA_GetDissectibleContent_Result>("DA_GetDissectibleContent");
        }
    
        public virtual ObjectResult<string> DA_GetGenderList()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("DA_GetGenderList");
        }
    
        public virtual ObjectResult<string> DA_GetLayerdata(Nullable<int> body_view_id, string sex)
        {
            var body_view_idParameter = body_view_id.HasValue ?
                new ObjectParameter("body_view_id", body_view_id) :
                new ObjectParameter("body_view_id", typeof(int));
    
            var sexParameter = sex != null ?
                new ObjectParameter("sex", sex) :
                new ObjectParameter("sex", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("DA_GetLayerdata", body_view_idParameter, sexParameter);
        }
    
        public virtual ObjectResult<DA_GetLayerModel_Result> DA_GetLayerModel(Nullable<int> body_view_id, string sex)
        {
            var body_view_idParameter = body_view_id.HasValue ?
                new ObjectParameter("body_view_id", body_view_id) :
                new ObjectParameter("body_view_id", typeof(int));
    
            var sexParameter = sex != null ?
                new ObjectParameter("sex", sex) :
                new ObjectParameter("sex", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<DA_GetLayerModel_Result>("DA_GetLayerModel", body_view_idParameter, sexParameter);
        }
    
        public virtual ObjectResult<string> DA_GetLexiconTermList(string lexicon_id)
        {
            var lexicon_idParameter = lexicon_id != null ?
                new ObjectParameter("lexicon_id", lexicon_id) :
                new ObjectParameter("lexicon_id", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("DA_GetLexiconTermList", lexicon_idParameter);
        }
    
        public virtual ObjectResult<DA_GetNavigatorModel_Result> DA_GetNavigatorModel(Nullable<int> content_descriptor_id)
        {
            var content_descriptor_idParameter = content_descriptor_id.HasValue ?
                new ObjectParameter("content_descriptor_id", content_descriptor_id) :
                new ObjectParameter("content_descriptor_id", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<DA_GetNavigatorModel_Result>("DA_GetNavigatorModel", content_descriptor_idParameter);
        }
    
        public virtual ObjectResult<DA_GetOverLayLayerList_Result> DA_GetOverLayLayerList(Nullable<int> body_view_id, string sex)
        {
            var body_view_idParameter = body_view_id.HasValue ?
                new ObjectParameter("body_view_id", body_view_id) :
                new ObjectParameter("body_view_id", typeof(int));
    
            var sexParameter = sex != null ?
                new ObjectParameter("sex", sex) :
                new ObjectParameter("sex", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<DA_GetOverLayLayerList_Result>("DA_GetOverLayLayerList", body_view_idParameter, sexParameter);
        }
    
        public virtual ObjectResult<DA_GetPLRModel_Result> DA_GetPLRModel(Nullable<int> structure_group_id)
        {
            var structure_group_idParameter = structure_group_id.HasValue ?
                new ObjectParameter("structure_group_id", structure_group_id) :
                new ObjectParameter("structure_group_id", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<DA_GetPLRModel_Result>("DA_GetPLRModel", structure_group_idParameter);
        }
    
        public virtual ObjectResult<DA_GetPolygonForId_Result> DA_GetPolygonForId(Nullable<int> polygon_id, Nullable<int> zoom)
        {
            var polygon_idParameter = polygon_id.HasValue ?
                new ObjectParameter("polygon_id", polygon_id) :
                new ObjectParameter("polygon_id", typeof(int));
    
            var zoomParameter = zoom.HasValue ?
                new ObjectParameter("zoom", zoom) :
                new ObjectParameter("zoom", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<DA_GetPolygonForId_Result>("DA_GetPolygonForId", polygon_idParameter, zoomParameter);
        }
    
        public virtual ObjectResult<DA_GetStructureGroupId_Result> DA_GetStructureGroupId(Nullable<int> structure_group_id)
        {
            var structure_group_idParameter = structure_group_id.HasValue ?
                new ObjectParameter("structure_group_id", structure_group_id) :
                new ObjectParameter("structure_group_id", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<DA_GetStructureGroupId_Result>("DA_GetStructureGroupId", structure_group_idParameter);
        }
    
        public virtual ObjectResult<string> DA_GetStructureGroupList()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("DA_GetStructureGroupList");
        }
    
        public virtual ObjectResult<string> DA_GetStructureList(Nullable<int> dissectible_struct_group_id, Nullable<int> vocab_lexicon_id)
        {
            var dissectible_struct_group_idParameter = dissectible_struct_group_id.HasValue ?
                new ObjectParameter("dissectible_struct_group_id", dissectible_struct_group_id) :
                new ObjectParameter("dissectible_struct_group_id", typeof(int));
    
            var vocab_lexicon_idParameter = vocab_lexicon_id.HasValue ?
                new ObjectParameter("vocab_lexicon_id", vocab_lexicon_id) :
                new ObjectParameter("vocab_lexicon_id", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("DA_GetStructureList", dissectible_struct_group_idParameter, vocab_lexicon_idParameter);
        }
    
        public virtual ObjectResult<DA_GetTermList_Result> DA_GetTermList(string lexicon_id, Nullable<int> structure_group_id, Nullable<int> layer_number_internal)
        {
            var lexicon_idParameter = lexicon_id != null ?
                new ObjectParameter("lexicon_id", lexicon_id) :
                new ObjectParameter("lexicon_id", typeof(string));
    
            var structure_group_idParameter = structure_group_id.HasValue ?
                new ObjectParameter("structure_group_id", structure_group_id) :
                new ObjectParameter("structure_group_id", typeof(int));
    
            var layer_number_internalParameter = layer_number_internal.HasValue ?
                new ObjectParameter("layer_number_internal", layer_number_internal) :
                new ObjectParameter("layer_number_internal", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<DA_GetTermList_Result>("DA_GetTermList", lexicon_idParameter, structure_group_idParameter, layer_number_internalParameter);
        }
    
        public virtual ObjectResult<Nullable<int>> DA_GetTermNumberForContentId(Nullable<int> dissectible_content_id)
        {
            var dissectible_content_idParameter = dissectible_content_id.HasValue ?
                new ObjectParameter("dissectible_content_id", dissectible_content_id) :
                new ObjectParameter("dissectible_content_id", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<int>>("DA_GetTermNumberForContentId", dissectible_content_idParameter);
        }
    
        public virtual ObjectResult<DA_GetViewOrientation_Result> DA_GetViewOrientation()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<DA_GetViewOrientation_Result>("DA_GetViewOrientation");
        }
    
        public virtual ObjectResult<string> DA_GetViewOrientationList()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("DA_GetViewOrientationList");
        }
    
        public virtual ObjectResult<DA_GetVocabTermModal_Result> DA_GetVocabTermModal(Nullable<int> lexiconID)
        {
            var lexiconIDParameter = lexiconID.HasValue ?
                new ObjectParameter("lexiconID", lexiconID) :
                new ObjectParameter("lexiconID", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<DA_GetVocabTermModal_Result>("DA_GetVocabTermModal", lexiconIDParameter);
        }
    
        public virtual ObjectResult<Nullable<int>> DA_LayerNumberInternal(Nullable<int> structure_group_id, Nullable<int> layer_number_internal)
        {
            var structure_group_idParameter = structure_group_id.HasValue ?
                new ObjectParameter("structure_group_id", structure_group_id) :
                new ObjectParameter("structure_group_id", typeof(int));
    
            var layer_number_internalParameter = layer_number_internal.HasValue ?
                new ObjectParameter("layer_number_internal", layer_number_internal) :
                new ObjectParameter("layer_number_internal", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<int>>("DA_LayerNumberInternal", structure_group_idParameter, layer_number_internalParameter);
        }
    
        public virtual int DeleteIncorrectLoginAttempts(Nullable<int> iUserId)
        {
            var iUserIdParameter = iUserId.HasValue ?
                new ObjectParameter("iUserId", iUserId) :
                new ObjectParameter("iUserId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("DeleteIncorrectLoginAttempts", iUserIdParameter);
        }
    
        public virtual ObjectResult<string> DeleteLicense(Nullable<int> iLicenseId)
        {
            var iLicenseIdParameter = iLicenseId.HasValue ?
                new ObjectParameter("iLicenseId", iLicenseId) :
                new ObjectParameter("iLicenseId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("DeleteLicense", iLicenseIdParameter);
        }
    
        public virtual int DeleteUserSession(string sSessionId)
        {
            var sSessionIdParameter = sSessionId != null ?
                new ObjectParameter("sSessionId", sSessionId) :
                new ObjectParameter("sSessionId", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("DeleteUserSession", sSessionIdParameter);
        }
    
        public virtual int EC_CreateUser(string sAccountNumber, string sLicenseeFirstName, string sLicenseeLastName, string sInstitutionName, string sAddress1, string sAddress2, Nullable<int> iCountryId, Nullable<int> iStateId, string sCity, string sZip, string sPhone, string sEmailId, Nullable<byte> tiAccountTypeId, Nullable<bool> bIsActive, Nullable<System.DateTime> dtCreationDate, ObjectParameter ioutId, Nullable<short> siSubscriptionPlanId, Nullable<System.DateTime> dtSubscriptionValidFrom, Nullable<System.DateTime> dtSubscriptionValidThrough, string sPaymentMode, Nullable<decimal> mTotalAmount, Nullable<decimal> mAmountPaid, Nullable<decimal> mAmountPending, Nullable<short> siClassSize, Nullable<int> iInstitutionType, string sDepartment, Nullable<int> iAIARequired, string sCourses, Nullable<int> iCoursesConduct, Nullable<int> iReferedBy, Nullable<int> iInternetProduct, Nullable<int> iMultimediaProduct, string sOtherAdamProduct, Nullable<bool> bIsOtherAdamProduct, string sLoginId, string sPassword, string sFirstName, string sLastName, Nullable<byte> tiSecurityQuestionId, string sSecurityAnswer, Nullable<System.DateTime> dtDeactivationDate, ObjectParameter ioutUserId, Nullable<byte> tiEditionId, string sStudentID, ObjectParameter ioutLicenseEditionId, string sVersion, Nullable<int> iCardNumber, Nullable<int> iDiscountCodeId, Nullable<decimal> desDiscountPercentage, Nullable<bool> iAod, Nullable<bool> iLite)
        {
            var sAccountNumberParameter = sAccountNumber != null ?
                new ObjectParameter("sAccountNumber", sAccountNumber) :
                new ObjectParameter("sAccountNumber", typeof(string));
    
            var sLicenseeFirstNameParameter = sLicenseeFirstName != null ?
                new ObjectParameter("sLicenseeFirstName", sLicenseeFirstName) :
                new ObjectParameter("sLicenseeFirstName", typeof(string));
    
            var sLicenseeLastNameParameter = sLicenseeLastName != null ?
                new ObjectParameter("sLicenseeLastName", sLicenseeLastName) :
                new ObjectParameter("sLicenseeLastName", typeof(string));
    
            var sInstitutionNameParameter = sInstitutionName != null ?
                new ObjectParameter("sInstitutionName", sInstitutionName) :
                new ObjectParameter("sInstitutionName", typeof(string));
    
            var sAddress1Parameter = sAddress1 != null ?
                new ObjectParameter("sAddress1", sAddress1) :
                new ObjectParameter("sAddress1", typeof(string));
    
            var sAddress2Parameter = sAddress2 != null ?
                new ObjectParameter("sAddress2", sAddress2) :
                new ObjectParameter("sAddress2", typeof(string));
    
            var iCountryIdParameter = iCountryId.HasValue ?
                new ObjectParameter("iCountryId", iCountryId) :
                new ObjectParameter("iCountryId", typeof(int));
    
            var iStateIdParameter = iStateId.HasValue ?
                new ObjectParameter("iStateId", iStateId) :
                new ObjectParameter("iStateId", typeof(int));
    
            var sCityParameter = sCity != null ?
                new ObjectParameter("sCity", sCity) :
                new ObjectParameter("sCity", typeof(string));
    
            var sZipParameter = sZip != null ?
                new ObjectParameter("sZip", sZip) :
                new ObjectParameter("sZip", typeof(string));
    
            var sPhoneParameter = sPhone != null ?
                new ObjectParameter("sPhone", sPhone) :
                new ObjectParameter("sPhone", typeof(string));
    
            var sEmailIdParameter = sEmailId != null ?
                new ObjectParameter("sEmailId", sEmailId) :
                new ObjectParameter("sEmailId", typeof(string));
    
            var tiAccountTypeIdParameter = tiAccountTypeId.HasValue ?
                new ObjectParameter("tiAccountTypeId", tiAccountTypeId) :
                new ObjectParameter("tiAccountTypeId", typeof(byte));
    
            var bIsActiveParameter = bIsActive.HasValue ?
                new ObjectParameter("bIsActive", bIsActive) :
                new ObjectParameter("bIsActive", typeof(bool));
    
            var dtCreationDateParameter = dtCreationDate.HasValue ?
                new ObjectParameter("dtCreationDate", dtCreationDate) :
                new ObjectParameter("dtCreationDate", typeof(System.DateTime));
    
            var siSubscriptionPlanIdParameter = siSubscriptionPlanId.HasValue ?
                new ObjectParameter("siSubscriptionPlanId", siSubscriptionPlanId) :
                new ObjectParameter("siSubscriptionPlanId", typeof(short));
    
            var dtSubscriptionValidFromParameter = dtSubscriptionValidFrom.HasValue ?
                new ObjectParameter("dtSubscriptionValidFrom", dtSubscriptionValidFrom) :
                new ObjectParameter("dtSubscriptionValidFrom", typeof(System.DateTime));
    
            var dtSubscriptionValidThroughParameter = dtSubscriptionValidThrough.HasValue ?
                new ObjectParameter("dtSubscriptionValidThrough", dtSubscriptionValidThrough) :
                new ObjectParameter("dtSubscriptionValidThrough", typeof(System.DateTime));
    
            var sPaymentModeParameter = sPaymentMode != null ?
                new ObjectParameter("sPaymentMode", sPaymentMode) :
                new ObjectParameter("sPaymentMode", typeof(string));
    
            var mTotalAmountParameter = mTotalAmount.HasValue ?
                new ObjectParameter("mTotalAmount", mTotalAmount) :
                new ObjectParameter("mTotalAmount", typeof(decimal));
    
            var mAmountPaidParameter = mAmountPaid.HasValue ?
                new ObjectParameter("mAmountPaid", mAmountPaid) :
                new ObjectParameter("mAmountPaid", typeof(decimal));
    
            var mAmountPendingParameter = mAmountPending.HasValue ?
                new ObjectParameter("mAmountPending", mAmountPending) :
                new ObjectParameter("mAmountPending", typeof(decimal));
    
            var siClassSizeParameter = siClassSize.HasValue ?
                new ObjectParameter("siClassSize", siClassSize) :
                new ObjectParameter("siClassSize", typeof(short));
    
            var iInstitutionTypeParameter = iInstitutionType.HasValue ?
                new ObjectParameter("iInstitutionType", iInstitutionType) :
                new ObjectParameter("iInstitutionType", typeof(int));
    
            var sDepartmentParameter = sDepartment != null ?
                new ObjectParameter("sDepartment", sDepartment) :
                new ObjectParameter("sDepartment", typeof(string));
    
            var iAIARequiredParameter = iAIARequired.HasValue ?
                new ObjectParameter("iAIARequired", iAIARequired) :
                new ObjectParameter("iAIARequired", typeof(int));
    
            var sCoursesParameter = sCourses != null ?
                new ObjectParameter("sCourses", sCourses) :
                new ObjectParameter("sCourses", typeof(string));
    
            var iCoursesConductParameter = iCoursesConduct.HasValue ?
                new ObjectParameter("iCoursesConduct", iCoursesConduct) :
                new ObjectParameter("iCoursesConduct", typeof(int));
    
            var iReferedByParameter = iReferedBy.HasValue ?
                new ObjectParameter("iReferedBy", iReferedBy) :
                new ObjectParameter("iReferedBy", typeof(int));
    
            var iInternetProductParameter = iInternetProduct.HasValue ?
                new ObjectParameter("iInternetProduct", iInternetProduct) :
                new ObjectParameter("iInternetProduct", typeof(int));
    
            var iMultimediaProductParameter = iMultimediaProduct.HasValue ?
                new ObjectParameter("iMultimediaProduct", iMultimediaProduct) :
                new ObjectParameter("iMultimediaProduct", typeof(int));
    
            var sOtherAdamProductParameter = sOtherAdamProduct != null ?
                new ObjectParameter("sOtherAdamProduct", sOtherAdamProduct) :
                new ObjectParameter("sOtherAdamProduct", typeof(string));
    
            var bIsOtherAdamProductParameter = bIsOtherAdamProduct.HasValue ?
                new ObjectParameter("bIsOtherAdamProduct", bIsOtherAdamProduct) :
                new ObjectParameter("bIsOtherAdamProduct", typeof(bool));
    
            var sLoginIdParameter = sLoginId != null ?
                new ObjectParameter("sLoginId", sLoginId) :
                new ObjectParameter("sLoginId", typeof(string));
    
            var sPasswordParameter = sPassword != null ?
                new ObjectParameter("sPassword", sPassword) :
                new ObjectParameter("sPassword", typeof(string));
    
            var sFirstNameParameter = sFirstName != null ?
                new ObjectParameter("sFirstName", sFirstName) :
                new ObjectParameter("sFirstName", typeof(string));
    
            var sLastNameParameter = sLastName != null ?
                new ObjectParameter("sLastName", sLastName) :
                new ObjectParameter("sLastName", typeof(string));
    
            var tiSecurityQuestionIdParameter = tiSecurityQuestionId.HasValue ?
                new ObjectParameter("tiSecurityQuestionId", tiSecurityQuestionId) :
                new ObjectParameter("tiSecurityQuestionId", typeof(byte));
    
            var sSecurityAnswerParameter = sSecurityAnswer != null ?
                new ObjectParameter("sSecurityAnswer", sSecurityAnswer) :
                new ObjectParameter("sSecurityAnswer", typeof(string));
    
            var dtDeactivationDateParameter = dtDeactivationDate.HasValue ?
                new ObjectParameter("dtDeactivationDate", dtDeactivationDate) :
                new ObjectParameter("dtDeactivationDate", typeof(System.DateTime));
    
            var tiEditionIdParameter = tiEditionId.HasValue ?
                new ObjectParameter("tiEditionId", tiEditionId) :
                new ObjectParameter("tiEditionId", typeof(byte));
    
            var sStudentIDParameter = sStudentID != null ?
                new ObjectParameter("sStudentID", sStudentID) :
                new ObjectParameter("sStudentID", typeof(string));
    
            var sVersionParameter = sVersion != null ?
                new ObjectParameter("sVersion", sVersion) :
                new ObjectParameter("sVersion", typeof(string));
    
            var iCardNumberParameter = iCardNumber.HasValue ?
                new ObjectParameter("iCardNumber", iCardNumber) :
                new ObjectParameter("iCardNumber", typeof(int));
    
            var iDiscountCodeIdParameter = iDiscountCodeId.HasValue ?
                new ObjectParameter("iDiscountCodeId", iDiscountCodeId) :
                new ObjectParameter("iDiscountCodeId", typeof(int));
    
            var desDiscountPercentageParameter = desDiscountPercentage.HasValue ?
                new ObjectParameter("desDiscountPercentage", desDiscountPercentage) :
                new ObjectParameter("desDiscountPercentage", typeof(decimal));
    
            var iAodParameter = iAod.HasValue ?
                new ObjectParameter("iAod", iAod) :
                new ObjectParameter("iAod", typeof(bool));
    
            var iLiteParameter = iLite.HasValue ?
                new ObjectParameter("iLite", iLite) :
                new ObjectParameter("iLite", typeof(bool));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("EC_CreateUser", sAccountNumberParameter, sLicenseeFirstNameParameter, sLicenseeLastNameParameter, sInstitutionNameParameter, sAddress1Parameter, sAddress2Parameter, iCountryIdParameter, iStateIdParameter, sCityParameter, sZipParameter, sPhoneParameter, sEmailIdParameter, tiAccountTypeIdParameter, bIsActiveParameter, dtCreationDateParameter, ioutId, siSubscriptionPlanIdParameter, dtSubscriptionValidFromParameter, dtSubscriptionValidThroughParameter, sPaymentModeParameter, mTotalAmountParameter, mAmountPaidParameter, mAmountPendingParameter, siClassSizeParameter, iInstitutionTypeParameter, sDepartmentParameter, iAIARequiredParameter, sCoursesParameter, iCoursesConductParameter, iReferedByParameter, iInternetProductParameter, iMultimediaProductParameter, sOtherAdamProductParameter, bIsOtherAdamProductParameter, sLoginIdParameter, sPasswordParameter, sFirstNameParameter, sLastNameParameter, tiSecurityQuestionIdParameter, sSecurityAnswerParameter, dtDeactivationDateParameter, ioutUserId, tiEditionIdParameter, sStudentIDParameter, ioutLicenseEditionId, sVersionParameter, iCardNumberParameter, iDiscountCodeIdParameter, desDiscountPercentageParameter, iAodParameter, iLiteParameter);
        }
    
        public virtual ObjectResult<EC_GetAccountTypeList_Result> EC_GetAccountTypeList()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<EC_GetAccountTypeList_Result>("EC_GetAccountTypeList");
        }
    
        public virtual ObjectResult<EC_GetCountryList_Result> EC_GetCountryList()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<EC_GetCountryList_Result>("EC_GetCountryList");
        }
    
        public virtual ObjectResult<EC_GetCourseConductedList_Result> EC_GetCourseConductedList()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<EC_GetCourseConductedList_Result>("EC_GetCourseConductedList");
        }
    
        public virtual ObjectResult<EC_GetInstitutionList_Result> EC_GetInstitutionList()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<EC_GetInstitutionList_Result>("EC_GetInstitutionList");
        }
    
        public virtual ObjectResult<EC_GetInternetProductList_Result> EC_GetInternetProductList()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<EC_GetInternetProductList_Result>("EC_GetInternetProductList");
        }
    
        public virtual ObjectResult<EC_GetMultimediaProductList_Result> EC_GetMultimediaProductList()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<EC_GetMultimediaProductList_Result>("EC_GetMultimediaProductList");
        }
    
        public virtual ObjectResult<EC_GetProductRequiredList_Result> EC_GetProductRequiredList()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<EC_GetProductRequiredList_Result>("EC_GetProductRequiredList");
        }
    
        public virtual ObjectResult<EC_GetReferList_Result> EC_GetReferList()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<EC_GetReferList_Result>("EC_GetReferList");
        }
    
        public virtual ObjectResult<EC_GetSecurityQuestionList_Result> EC_GetSecurityQuestionList()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<EC_GetSecurityQuestionList_Result>("EC_GetSecurityQuestionList");
        }
    
        public virtual ObjectResult<EC_GetStateList_Result> EC_GetStateList()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<EC_GetStateList_Result>("EC_GetStateList");
        }
    
        public virtual ObjectResult<Nullable<byte>> EC_GetSubscriptionDuration(Nullable<short> siSubscriptionId)
        {
            var siSubscriptionIdParameter = siSubscriptionId.HasValue ?
                new ObjectParameter("siSubscriptionId", siSubscriptionId) :
                new ObjectParameter("siSubscriptionId", typeof(short));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<byte>>("EC_GetSubscriptionDuration", siSubscriptionIdParameter);
        }
    
        public virtual ObjectResult<Nullable<System.DateTime>> EC_GetSubscriptionEndDate(Nullable<byte> tiDuration)
        {
            var tiDurationParameter = tiDuration.HasValue ?
                new ObjectParameter("tiDuration", tiDuration) :
                new ObjectParameter("tiDuration", typeof(byte));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<System.DateTime>>("EC_GetSubscriptionEndDate", tiDurationParameter);
        }
    
        public virtual ObjectResult<EC_GetSubscriptionPlan_Result> EC_GetSubscriptionPlan(Nullable<byte> iEditioId, Nullable<byte> iDuration)
        {
            var iEditioIdParameter = iEditioId.HasValue ?
                new ObjectParameter("iEditioId", iEditioId) :
                new ObjectParameter("iEditioId", typeof(byte));
    
            var iDurationParameter = iDuration.HasValue ?
                new ObjectParameter("iDuration", iDuration) :
                new ObjectParameter("iDuration", typeof(byte));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<EC_GetSubscriptionPlan_Result>("EC_GetSubscriptionPlan", iEditioIdParameter, iDurationParameter);
        }
    
        public virtual ObjectResult<EC_GetSubscriptionPlanInfo_Result> EC_GetSubscriptionPlanInfo(Nullable<byte> iEditioId, Nullable<byte> iDuration, Nullable<byte> rowId)
        {
            var iEditioIdParameter = iEditioId.HasValue ?
                new ObjectParameter("iEditioId", iEditioId) :
                new ObjectParameter("iEditioId", typeof(byte));
    
            var iDurationParameter = iDuration.HasValue ?
                new ObjectParameter("iDuration", iDuration) :
                new ObjectParameter("iDuration", typeof(byte));
    
            var rowIdParameter = rowId.HasValue ?
                new ObjectParameter("rowId", rowId) :
                new ObjectParameter("rowId", typeof(byte));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<EC_GetSubscriptionPlanInfo_Result>("EC_GetSubscriptionPlanInfo", iEditioIdParameter, iDurationParameter, rowIdParameter);
        }
    
        public virtual ObjectResult<Nullable<decimal>> EC_GetSubscriptionPrice(Nullable<short> siSubscriptionId)
        {
            var siSubscriptionIdParameter = siSubscriptionId.HasValue ?
                new ObjectParameter("siSubscriptionId", siSubscriptionId) :
                new ObjectParameter("siSubscriptionId", typeof(short));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<decimal>>("EC_GetSubscriptionPrice", siSubscriptionIdParameter);
        }
    
        public virtual int EC_GetUsername(string sUserName)
        {
            var sUserNameParameter = sUserName != null ?
                new ObjectParameter("sUserName", sUserName) :
                new ObjectParameter("sUserName", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("EC_GetUsername", sUserNameParameter);
        }
    
        public virtual int EC_InsertPaymentTransaction(string iTransactionId, string iEditionId, string iSubscriptionPlanId, string iUserId, string sFirstName, string sLastName, string sStreet, string sCity, string sState, string sZip, string sCountry, string sEmail, Nullable<decimal> sAmount, string sPaymentStatus)
        {
            var iTransactionIdParameter = iTransactionId != null ?
                new ObjectParameter("iTransactionId", iTransactionId) :
                new ObjectParameter("iTransactionId", typeof(string));
    
            var iEditionIdParameter = iEditionId != null ?
                new ObjectParameter("iEditionId", iEditionId) :
                new ObjectParameter("iEditionId", typeof(string));
    
            var iSubscriptionPlanIdParameter = iSubscriptionPlanId != null ?
                new ObjectParameter("iSubscriptionPlanId", iSubscriptionPlanId) :
                new ObjectParameter("iSubscriptionPlanId", typeof(string));
    
            var iUserIdParameter = iUserId != null ?
                new ObjectParameter("iUserId", iUserId) :
                new ObjectParameter("iUserId", typeof(string));
    
            var sFirstNameParameter = sFirstName != null ?
                new ObjectParameter("sFirstName", sFirstName) :
                new ObjectParameter("sFirstName", typeof(string));
    
            var sLastNameParameter = sLastName != null ?
                new ObjectParameter("sLastName", sLastName) :
                new ObjectParameter("sLastName", typeof(string));
    
            var sStreetParameter = sStreet != null ?
                new ObjectParameter("sStreet", sStreet) :
                new ObjectParameter("sStreet", typeof(string));
    
            var sCityParameter = sCity != null ?
                new ObjectParameter("sCity", sCity) :
                new ObjectParameter("sCity", typeof(string));
    
            var sStateParameter = sState != null ?
                new ObjectParameter("sState", sState) :
                new ObjectParameter("sState", typeof(string));
    
            var sZipParameter = sZip != null ?
                new ObjectParameter("sZip", sZip) :
                new ObjectParameter("sZip", typeof(string));
    
            var sCountryParameter = sCountry != null ?
                new ObjectParameter("sCountry", sCountry) :
                new ObjectParameter("sCountry", typeof(string));
    
            var sEmailParameter = sEmail != null ?
                new ObjectParameter("sEmail", sEmail) :
                new ObjectParameter("sEmail", typeof(string));
    
            var sAmountParameter = sAmount.HasValue ?
                new ObjectParameter("sAmount", sAmount) :
                new ObjectParameter("sAmount", typeof(decimal));
    
            var sPaymentStatusParameter = sPaymentStatus != null ?
                new ObjectParameter("sPaymentStatus", sPaymentStatus) :
                new ObjectParameter("sPaymentStatus", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("EC_InsertPaymentTransaction", iTransactionIdParameter, iEditionIdParameter, iSubscriptionPlanIdParameter, iUserIdParameter, sFirstNameParameter, sLastNameParameter, sStreetParameter, sCityParameter, sStateParameter, sZipParameter, sCountryParameter, sEmailParameter, sAmountParameter, sPaymentStatusParameter);
        }
    
        public virtual int EC_UpdateUser(string sLoginID, Nullable<decimal> sAmountPaid, Nullable<decimal> sAmountPending)
        {
            var sLoginIDParameter = sLoginID != null ?
                new ObjectParameter("sLoginID", sLoginID) :
                new ObjectParameter("sLoginID", typeof(string));
    
            var sAmountPaidParameter = sAmountPaid.HasValue ?
                new ObjectParameter("sAmountPaid", sAmountPaid) :
                new ObjectParameter("sAmountPaid", typeof(decimal));
    
            var sAmountPendingParameter = sAmountPending.HasValue ?
                new ObjectParameter("sAmountPending", sAmountPending) :
                new ObjectParameter("sAmountPending", typeof(decimal));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("EC_UpdateUser", sLoginIDParameter, sAmountPaidParameter, sAmountPendingParameter);
        }
    
        public virtual ObjectResult<GetAccountModule_Result> GetAccountModule(Nullable<int> licenseId)
        {
            var licenseIdParameter = licenseId.HasValue ?
                new ObjectParameter("LicenseId", licenseId) :
                new ObjectParameter("LicenseId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetAccountModule_Result>("GetAccountModule", licenseIdParameter);
        }
    
        public virtual ObjectResult<GetAIALicenseDetails_Result> GetAIALicenseDetails(string sStartDate, string sEndDate, string sAccoutNumber, string sLicenseeFirstName, string sLicenseeLastName, Nullable<byte> iLicenseTypeId, string sInstituteName, string sEmail, Nullable<int> iStateId, Nullable<int> iCountryId, Nullable<bool> bisActive)
        {
            var sStartDateParameter = sStartDate != null ?
                new ObjectParameter("sStartDate", sStartDate) :
                new ObjectParameter("sStartDate", typeof(string));
    
            var sEndDateParameter = sEndDate != null ?
                new ObjectParameter("sEndDate", sEndDate) :
                new ObjectParameter("sEndDate", typeof(string));
    
            var sAccoutNumberParameter = sAccoutNumber != null ?
                new ObjectParameter("sAccoutNumber", sAccoutNumber) :
                new ObjectParameter("sAccoutNumber", typeof(string));
    
            var sLicenseeFirstNameParameter = sLicenseeFirstName != null ?
                new ObjectParameter("sLicenseeFirstName", sLicenseeFirstName) :
                new ObjectParameter("sLicenseeFirstName", typeof(string));
    
            var sLicenseeLastNameParameter = sLicenseeLastName != null ?
                new ObjectParameter("sLicenseeLastName", sLicenseeLastName) :
                new ObjectParameter("sLicenseeLastName", typeof(string));
    
            var iLicenseTypeIdParameter = iLicenseTypeId.HasValue ?
                new ObjectParameter("iLicenseTypeId", iLicenseTypeId) :
                new ObjectParameter("iLicenseTypeId", typeof(byte));
    
            var sInstituteNameParameter = sInstituteName != null ?
                new ObjectParameter("sInstituteName", sInstituteName) :
                new ObjectParameter("sInstituteName", typeof(string));
    
            var sEmailParameter = sEmail != null ?
                new ObjectParameter("sEmail", sEmail) :
                new ObjectParameter("sEmail", typeof(string));
    
            var iStateIdParameter = iStateId.HasValue ?
                new ObjectParameter("iStateId", iStateId) :
                new ObjectParameter("iStateId", typeof(int));
    
            var iCountryIdParameter = iCountryId.HasValue ?
                new ObjectParameter("iCountryId", iCountryId) :
                new ObjectParameter("iCountryId", typeof(int));
    
            var bisActiveParameter = bisActive.HasValue ?
                new ObjectParameter("bisActive", bisActive) :
                new ObjectParameter("bisActive", typeof(bool));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetAIALicenseDetails_Result>("GetAIALicenseDetails", sStartDateParameter, sEndDateParameter, sAccoutNumberParameter, sLicenseeFirstNameParameter, sLicenseeLastNameParameter, iLicenseTypeIdParameter, sInstituteNameParameter, sEmailParameter, iStateIdParameter, iCountryIdParameter, bisActiveParameter);
        }
    
        public virtual ObjectResult<GetAllEditionForLicense_Result> GetAllEditionForLicense(Nullable<int> iLicenseId)
        {
            var iLicenseIdParameter = iLicenseId.HasValue ?
                new ObjectParameter("iLicenseId", iLicenseId) :
                new ObjectParameter("iLicenseId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetAllEditionForLicense_Result>("GetAllEditionForLicense", iLicenseIdParameter);
        }
    
        public virtual ObjectResult<GetAllLoginFailureCauses_Result> GetAllLoginFailureCauses()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetAllLoginFailureCauses_Result>("GetAllLoginFailureCauses");
        }
    
        public virtual ObjectResult<GetAllModuleStatus_Result> GetAllModuleStatus()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetAllModuleStatus_Result>("GetAllModuleStatus");
        }
    
        public virtual ObjectResult<GetAllModuleStatusWithSlug_Result> GetAllModuleStatusWithSlug()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetAllModuleStatusWithSlug_Result>("GetAllModuleStatusWithSlug");
        }
    
        public virtual ObjectResult<GetAllUserWithGroup_Result> GetAllUserWithGroup(Nullable<int> iLicenseId, Nullable<int> iGroupId)
        {
            var iLicenseIdParameter = iLicenseId.HasValue ?
                new ObjectParameter("iLicenseId", iLicenseId) :
                new ObjectParameter("iLicenseId", typeof(int));
    
            var iGroupIdParameter = iGroupId.HasValue ?
                new ObjectParameter("iGroupId", iGroupId) :
                new ObjectParameter("iGroupId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetAllUserWithGroup_Result>("GetAllUserWithGroup", iLicenseIdParameter, iGroupIdParameter);
        }
    
        public virtual ObjectResult<GetAttributeTypeList_Result> GetAttributeTypeList(Nullable<int> iContentTypeId)
        {
            var iContentTypeIdParameter = iContentTypeId.HasValue ?
                new ObjectParameter("iContentTypeId", iContentTypeId) :
                new ObjectParameter("iContentTypeId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetAttributeTypeList_Result>("GetAttributeTypeList", iContentTypeIdParameter);
        }
    
        public virtual ObjectResult<string> GetAttributeValueList(Nullable<int> iContentTypeId, Nullable<int> iAttributeTypeId)
        {
            var iContentTypeIdParameter = iContentTypeId.HasValue ?
                new ObjectParameter("iContentTypeId", iContentTypeId) :
                new ObjectParameter("iContentTypeId", typeof(int));
    
            var iAttributeTypeIdParameter = iAttributeTypeId.HasValue ?
                new ObjectParameter("iAttributeTypeId", iAttributeTypeId) :
                new ObjectParameter("iAttributeTypeId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("GetAttributeValueList", iContentTypeIdParameter, iAttributeTypeIdParameter);
        }
    
        public virtual ObjectResult<GetBlockedUserByAccNoAndType_Result> GetBlockedUserByAccNoAndType(Nullable<byte> iUserTypeId, Nullable<int> iLicenseId)
        {
            var iUserTypeIdParameter = iUserTypeId.HasValue ?
                new ObjectParameter("iUserTypeId", iUserTypeId) :
                new ObjectParameter("iUserTypeId", typeof(byte));
    
            var iLicenseIdParameter = iLicenseId.HasValue ?
                new ObjectParameter("iLicenseId", iLicenseId) :
                new ObjectParameter("iLicenseId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetBlockedUserByAccNoAndType_Result>("GetBlockedUserByAccNoAndType", iUserTypeIdParameter, iLicenseIdParameter);
        }
    
        public virtual ObjectResult<GetBlockedUserByUserId_Result> GetBlockedUserByUserId(Nullable<int> userId)
        {
            var userIdParameter = userId.HasValue ?
                new ObjectParameter("userId", userId) :
                new ObjectParameter("userId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetBlockedUserByUserId_Result>("GetBlockedUserByUserId", userIdParameter);
        }
    
        public virtual ObjectResult<GetBlockedUserByUserType_Result> GetBlockedUserByUserType(Nullable<byte> iUserTypeId)
        {
            var iUserTypeIdParameter = iUserTypeId.HasValue ?
                new ObjectParameter("iUserTypeId", iUserTypeId) :
                new ObjectParameter("iUserTypeId", typeof(byte));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetBlockedUserByUserType_Result>("GetBlockedUserByUserType", iUserTypeIdParameter);
        }
    
        public virtual int GetBlockedUserDetailsByUserIdAndUserTypeId(Nullable<int> userId, Nullable<byte> userTypeId, Nullable<int> licenseId)
        {
            var userIdParameter = userId.HasValue ?
                new ObjectParameter("userId", userId) :
                new ObjectParameter("userId", typeof(int));
    
            var userTypeIdParameter = userTypeId.HasValue ?
                new ObjectParameter("userTypeId", userTypeId) :
                new ObjectParameter("userTypeId", typeof(byte));
    
            var licenseIdParameter = licenseId.HasValue ?
                new ObjectParameter("licenseId", licenseId) :
                new ObjectParameter("licenseId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("GetBlockedUserDetailsByUserIdAndUserTypeId", userIdParameter, userTypeIdParameter, licenseIdParameter);
        }
    
        public virtual ObjectResult<GetCAMSearch_Result> GetCAMSearch(string sSearchKeyword)
        {
            var sSearchKeywordParameter = sSearchKeyword != null ?
                new ObjectParameter("sSearchKeyword", sSearchKeyword) :
                new ObjectParameter("sSearchKeyword", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetCAMSearch_Result>("GetCAMSearch", sSearchKeywordParameter);
        }
    
        public virtual ObjectResult<GetCancelledLicenses_Result> GetCancelledLicenses(string sFromDate, string sToDate, Nullable<decimal> iStartPrice, Nullable<decimal> iEndPrice, Nullable<byte> iLicenseTypeId, Nullable<byte> iAccountTypeId, string sZip, Nullable<int> iStateId, Nullable<int> iCountryId, Nullable<int> pageNo, Nullable<int> pageLength, ObjectParameter recordCount)
        {
            var sFromDateParameter = sFromDate != null ?
                new ObjectParameter("sFromDate", sFromDate) :
                new ObjectParameter("sFromDate", typeof(string));
    
            var sToDateParameter = sToDate != null ?
                new ObjectParameter("sToDate", sToDate) :
                new ObjectParameter("sToDate", typeof(string));
    
            var iStartPriceParameter = iStartPrice.HasValue ?
                new ObjectParameter("iStartPrice", iStartPrice) :
                new ObjectParameter("iStartPrice", typeof(decimal));
    
            var iEndPriceParameter = iEndPrice.HasValue ?
                new ObjectParameter("iEndPrice", iEndPrice) :
                new ObjectParameter("iEndPrice", typeof(decimal));
    
            var iLicenseTypeIdParameter = iLicenseTypeId.HasValue ?
                new ObjectParameter("iLicenseTypeId", iLicenseTypeId) :
                new ObjectParameter("iLicenseTypeId", typeof(byte));
    
            var iAccountTypeIdParameter = iAccountTypeId.HasValue ?
                new ObjectParameter("iAccountTypeId", iAccountTypeId) :
                new ObjectParameter("iAccountTypeId", typeof(byte));
    
            var sZipParameter = sZip != null ?
                new ObjectParameter("sZip", sZip) :
                new ObjectParameter("sZip", typeof(string));
    
            var iStateIdParameter = iStateId.HasValue ?
                new ObjectParameter("iStateId", iStateId) :
                new ObjectParameter("iStateId", typeof(int));
    
            var iCountryIdParameter = iCountryId.HasValue ?
                new ObjectParameter("iCountryId", iCountryId) :
                new ObjectParameter("iCountryId", typeof(int));
    
            var pageNoParameter = pageNo.HasValue ?
                new ObjectParameter("pageNo", pageNo) :
                new ObjectParameter("pageNo", typeof(int));
    
            var pageLengthParameter = pageLength.HasValue ?
                new ObjectParameter("pageLength", pageLength) :
                new ObjectParameter("pageLength", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetCancelledLicenses_Result>("GetCancelledLicenses", sFromDateParameter, sToDateParameter, iStartPriceParameter, iEndPriceParameter, iLicenseTypeIdParameter, iAccountTypeIdParameter, sZipParameter, iStateIdParameter, iCountryIdParameter, pageNoParameter, pageLengthParameter, recordCount);
        }
    
        public virtual int GetContentAttributeData(Nullable<int> iContentTypeId)
        {
            var iContentTypeIdParameter = iContentTypeId.HasValue ?
                new ObjectParameter("iContentTypeId", iContentTypeId) :
                new ObjectParameter("iContentTypeId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("GetContentAttributeData", iContentTypeIdParameter);
        }
    
        public virtual int GetContentList(Nullable<int> iContentTypeId)
        {
            var iContentTypeIdParameter = iContentTypeId.HasValue ?
                new ObjectParameter("iContentTypeId", iContentTypeId) :
                new ObjectParameter("iContentTypeId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("GetContentList", iContentTypeIdParameter);
        }
    
        public virtual ObjectResult<GetCustomerSummary_Result> GetCustomerSummary(string sAccoutNumber, string sLicenseeFullName, Nullable<decimal> iStartPrice, Nullable<decimal> iEndPrice, Nullable<byte> iLicenseType, Nullable<byte> iAccountType, string sZip, Nullable<int> iState, Nullable<int> iCountry, Nullable<int> pageNo, Nullable<int> pageLength, ObjectParameter recordCount)
        {
            var sAccoutNumberParameter = sAccoutNumber != null ?
                new ObjectParameter("sAccoutNumber", sAccoutNumber) :
                new ObjectParameter("sAccoutNumber", typeof(string));
    
            var sLicenseeFullNameParameter = sLicenseeFullName != null ?
                new ObjectParameter("sLicenseeFullName", sLicenseeFullName) :
                new ObjectParameter("sLicenseeFullName", typeof(string));
    
            var iStartPriceParameter = iStartPrice.HasValue ?
                new ObjectParameter("iStartPrice", iStartPrice) :
                new ObjectParameter("iStartPrice", typeof(decimal));
    
            var iEndPriceParameter = iEndPrice.HasValue ?
                new ObjectParameter("iEndPrice", iEndPrice) :
                new ObjectParameter("iEndPrice", typeof(decimal));
    
            var iLicenseTypeParameter = iLicenseType.HasValue ?
                new ObjectParameter("iLicenseType", iLicenseType) :
                new ObjectParameter("iLicenseType", typeof(byte));
    
            var iAccountTypeParameter = iAccountType.HasValue ?
                new ObjectParameter("iAccountType", iAccountType) :
                new ObjectParameter("iAccountType", typeof(byte));
    
            var sZipParameter = sZip != null ?
                new ObjectParameter("sZip", sZip) :
                new ObjectParameter("sZip", typeof(string));
    
            var iStateParameter = iState.HasValue ?
                new ObjectParameter("iState", iState) :
                new ObjectParameter("iState", typeof(int));
    
            var iCountryParameter = iCountry.HasValue ?
                new ObjectParameter("iCountry", iCountry) :
                new ObjectParameter("iCountry", typeof(int));
    
            var pageNoParameter = pageNo.HasValue ?
                new ObjectParameter("pageNo", pageNo) :
                new ObjectParameter("pageNo", typeof(int));
    
            var pageLengthParameter = pageLength.HasValue ?
                new ObjectParameter("pageLength", pageLength) :
                new ObjectParameter("pageLength", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetCustomerSummary_Result>("GetCustomerSummary", sAccoutNumberParameter, sLicenseeFullNameParameter, iStartPriceParameter, iEndPriceParameter, iLicenseTypeParameter, iAccountTypeParameter, sZipParameter, iStateParameter, iCountryParameter, pageNoParameter, pageLengthParameter, recordCount);
        }
    
        public virtual ObjectResult<GetDiscountCodes_Result> GetDiscountCodes(string sDiscountCode, string sStartDate, string sEndDate, Nullable<int> pageNo, Nullable<int> pageLength, ObjectParameter recordCount)
        {
            var sDiscountCodeParameter = sDiscountCode != null ?
                new ObjectParameter("sDiscountCode", sDiscountCode) :
                new ObjectParameter("sDiscountCode", typeof(string));
    
            var sStartDateParameter = sStartDate != null ?
                new ObjectParameter("sStartDate", sStartDate) :
                new ObjectParameter("sStartDate", typeof(string));
    
            var sEndDateParameter = sEndDate != null ?
                new ObjectParameter("sEndDate", sEndDate) :
                new ObjectParameter("sEndDate", typeof(string));
    
            var pageNoParameter = pageNo.HasValue ?
                new ObjectParameter("pageNo", pageNo) :
                new ObjectParameter("pageNo", typeof(int));
    
            var pageLengthParameter = pageLength.HasValue ?
                new ObjectParameter("pageLength", pageLength) :
                new ObjectParameter("pageLength", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetDiscountCodes_Result>("GetDiscountCodes", sDiscountCodeParameter, sStartDateParameter, sEndDateParameter, pageNoParameter, pageLengthParameter, recordCount);
        }
    
        public virtual ObjectResult<GetDiscountDetails_Result> GetDiscountDetails(string sDiscountCode, string sStartDate, string sEndDate)
        {
            var sDiscountCodeParameter = sDiscountCode != null ?
                new ObjectParameter("sDiscountCode", sDiscountCode) :
                new ObjectParameter("sDiscountCode", typeof(string));
    
            var sStartDateParameter = sStartDate != null ?
                new ObjectParameter("sStartDate", sStartDate) :
                new ObjectParameter("sStartDate", typeof(string));
    
            var sEndDateParameter = sEndDate != null ?
                new ObjectParameter("sEndDate", sEndDate) :
                new ObjectParameter("sEndDate", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetDiscountDetails_Result>("GetDiscountDetails", sDiscountCodeParameter, sStartDateParameter, sEndDateParameter);
        }
    
        public virtual ObjectResult<GetDiscountedPrice_Result> GetDiscountedPrice(string inDiscountCode, ObjectParameter outReturnCode, ObjectParameter outDiscountPercentage, ObjectParameter outDiscountCodeId)
        {
            var inDiscountCodeParameter = inDiscountCode != null ?
                new ObjectParameter("inDiscountCode", inDiscountCode) :
                new ObjectParameter("inDiscountCode", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetDiscountedPrice_Result>("GetDiscountedPrice", inDiscountCodeParameter, outReturnCode, outDiscountPercentage, outDiscountCodeId);
        }
    
        public virtual ObjectResult<GetDiscountReport_Result> GetDiscountReport(string sStartDate, string sEndDate, Nullable<int> intDiscountID, string sAccoutNumber, Nullable<int> pageNo, Nullable<int> pageLength, ObjectParameter recordCount)
        {
            var sStartDateParameter = sStartDate != null ?
                new ObjectParameter("sStartDate", sStartDate) :
                new ObjectParameter("sStartDate", typeof(string));
    
            var sEndDateParameter = sEndDate != null ?
                new ObjectParameter("sEndDate", sEndDate) :
                new ObjectParameter("sEndDate", typeof(string));
    
            var intDiscountIDParameter = intDiscountID.HasValue ?
                new ObjectParameter("intDiscountID", intDiscountID) :
                new ObjectParameter("intDiscountID", typeof(int));
    
            var sAccoutNumberParameter = sAccoutNumber != null ?
                new ObjectParameter("sAccoutNumber", sAccoutNumber) :
                new ObjectParameter("sAccoutNumber", typeof(string));
    
            var pageNoParameter = pageNo.HasValue ?
                new ObjectParameter("pageNo", pageNo) :
                new ObjectParameter("pageNo", typeof(int));
    
            var pageLengthParameter = pageLength.HasValue ?
                new ObjectParameter("pageLength", pageLength) :
                new ObjectParameter("pageLength", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetDiscountReport_Result>("GetDiscountReport", sStartDateParameter, sEndDateParameter, intDiscountIDParameter, sAccoutNumberParameter, pageNoParameter, pageLengthParameter, recordCount);
        }
    
        public virtual ObjectResult<getEditionData_Result> getEditionData()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<getEditionData_Result>("getEditionData");
        }
    
        public virtual ObjectResult<GetEditionsBySiteAccount_Result> GetEditionsBySiteAccount(Nullable<int> intSiteId, string strAccountNumber)
        {
            var intSiteIdParameter = intSiteId.HasValue ?
                new ObjectParameter("intSiteId", intSiteId) :
                new ObjectParameter("intSiteId", typeof(int));
    
            var strAccountNumberParameter = strAccountNumber != null ?
                new ObjectParameter("strAccountNumber", strAccountNumber) :
                new ObjectParameter("strAccountNumber", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetEditionsBySiteAccount_Result>("GetEditionsBySiteAccount", intSiteIdParameter, strAccountNumberParameter);
        }
    
        public virtual ObjectResult<GetEncyclopediaSearch_Result> GetEncyclopediaSearch(Nullable<int> iLexiconId, string sSearchKeyword)
        {
            var iLexiconIdParameter = iLexiconId.HasValue ?
                new ObjectParameter("iLexiconId", iLexiconId) :
                new ObjectParameter("iLexiconId", typeof(int));
    
            var sSearchKeywordParameter = sSearchKeyword != null ?
                new ObjectParameter("sSearchKeyword", sSearchKeyword) :
                new ObjectParameter("sSearchKeyword", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetEncyclopediaSearch_Result>("GetEncyclopediaSearch", iLexiconIdParameter, sSearchKeywordParameter);
        }
    
        public virtual ObjectResult<GetExpiringLicenses_Result> GetExpiringLicenses(string sFromDate, string sToDate, Nullable<decimal> iStartPrice, Nullable<decimal> iEndPrice, Nullable<int> iLicenseTypeId, Nullable<int> iAccountTypeId, string sZip, Nullable<int> iStateId, Nullable<int> iCountryId, Nullable<int> pageNo, Nullable<int> pageLength, ObjectParameter recordCount)
        {
            var sFromDateParameter = sFromDate != null ?
                new ObjectParameter("sFromDate", sFromDate) :
                new ObjectParameter("sFromDate", typeof(string));
    
            var sToDateParameter = sToDate != null ?
                new ObjectParameter("sToDate", sToDate) :
                new ObjectParameter("sToDate", typeof(string));
    
            var iStartPriceParameter = iStartPrice.HasValue ?
                new ObjectParameter("iStartPrice", iStartPrice) :
                new ObjectParameter("iStartPrice", typeof(decimal));
    
            var iEndPriceParameter = iEndPrice.HasValue ?
                new ObjectParameter("iEndPrice", iEndPrice) :
                new ObjectParameter("iEndPrice", typeof(decimal));
    
            var iLicenseTypeIdParameter = iLicenseTypeId.HasValue ?
                new ObjectParameter("iLicenseTypeId", iLicenseTypeId) :
                new ObjectParameter("iLicenseTypeId", typeof(int));
    
            var iAccountTypeIdParameter = iAccountTypeId.HasValue ?
                new ObjectParameter("iAccountTypeId", iAccountTypeId) :
                new ObjectParameter("iAccountTypeId", typeof(int));
    
            var sZipParameter = sZip != null ?
                new ObjectParameter("sZip", sZip) :
                new ObjectParameter("sZip", typeof(string));
    
            var iStateIdParameter = iStateId.HasValue ?
                new ObjectParameter("iStateId", iStateId) :
                new ObjectParameter("iStateId", typeof(int));
    
            var iCountryIdParameter = iCountryId.HasValue ?
                new ObjectParameter("iCountryId", iCountryId) :
                new ObjectParameter("iCountryId", typeof(int));
    
            var pageNoParameter = pageNo.HasValue ?
                new ObjectParameter("pageNo", pageNo) :
                new ObjectParameter("pageNo", typeof(int));
    
            var pageLengthParameter = pageLength.HasValue ?
                new ObjectParameter("pageLength", pageLength) :
                new ObjectParameter("pageLength", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetExpiringLicenses_Result>("GetExpiringLicenses", sFromDateParameter, sToDateParameter, iStartPriceParameter, iEndPriceParameter, iLicenseTypeIdParameter, iAccountTypeIdParameter, sZipParameter, iStateIdParameter, iCountryIdParameter, pageNoParameter, pageLengthParameter, recordCount);
        }
    
        public virtual ObjectResult<GetExportedImageDetails_Result> GetExportedImageDetails(string sStartDate, string sEndDate, string sAccoutNumber, Nullable<int> pageNo, Nullable<int> pageLength, ObjectParameter recordCount)
        {
            var sStartDateParameter = sStartDate != null ?
                new ObjectParameter("sStartDate", sStartDate) :
                new ObjectParameter("sStartDate", typeof(string));
    
            var sEndDateParameter = sEndDate != null ?
                new ObjectParameter("sEndDate", sEndDate) :
                new ObjectParameter("sEndDate", typeof(string));
    
            var sAccoutNumberParameter = sAccoutNumber != null ?
                new ObjectParameter("sAccoutNumber", sAccoutNumber) :
                new ObjectParameter("sAccoutNumber", typeof(string));
    
            var pageNoParameter = pageNo.HasValue ?
                new ObjectParameter("pageNo", pageNo) :
                new ObjectParameter("pageNo", typeof(int));
    
            var pageLengthParameter = pageLength.HasValue ?
                new ObjectParameter("pageLength", pageLength) :
                new ObjectParameter("pageLength", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetExportedImageDetails_Result>("GetExportedImageDetails", sStartDateParameter, sEndDateParameter, sAccoutNumberParameter, pageNoParameter, pageLengthParameter, recordCount);
        }
    
        public virtual int GetImagePinData()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("GetImagePinData");
        }
    
        public virtual ObjectResult<Nullable<short>> GetIncorrectLoginAttempt(Nullable<int> iUserId)
        {
            var iUserIdParameter = iUserId.HasValue ?
                new ObjectParameter("iUserId", iUserId) :
                new ObjectParameter("iUserId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<short>>("GetIncorrectLoginAttempt", iUserIdParameter);
        }
    
        public virtual ObjectResult<GetInDepthSearch_Result> GetInDepthSearch(string sSearchKeyword)
        {
            var sSearchKeywordParameter = sSearchKeyword != null ?
                new ObjectParameter("sSearchKeyword", sSearchKeyword) :
                new ObjectParameter("sSearchKeyword", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetInDepthSearch_Result>("GetInDepthSearch", sSearchKeywordParameter);
        }
    
        public virtual ObjectResult<GetLabExcerciseByUserId_Result> GetLabExcerciseByUserId(Nullable<int> userId, string identifier)
        {
            var userIdParameter = userId.HasValue ?
                new ObjectParameter("UserId", userId) :
                new ObjectParameter("UserId", typeof(int));
    
            var identifierParameter = identifier != null ?
                new ObjectParameter("Identifier", identifier) :
                new ObjectParameter("Identifier", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetLabExcerciseByUserId_Result>("GetLabExcerciseByUserId", userIdParameter, identifierParameter);
        }
    
        public virtual ObjectResult<GetLicenseByIPAndAccount_Result> GetLicenseByIPAndAccount(string sSiteIP, string sAccountNumber, Nullable<byte> iEditionId)
        {
            var sSiteIPParameter = sSiteIP != null ?
                new ObjectParameter("sSiteIP", sSiteIP) :
                new ObjectParameter("sSiteIP", typeof(string));
    
            var sAccountNumberParameter = sAccountNumber != null ?
                new ObjectParameter("sAccountNumber", sAccountNumber) :
                new ObjectParameter("sAccountNumber", typeof(string));
    
            var iEditionIdParameter = iEditionId.HasValue ?
                new ObjectParameter("iEditionId", iEditionId) :
                new ObjectParameter("iEditionId", typeof(byte));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetLicenseByIPAndAccount_Result>("GetLicenseByIPAndAccount", sSiteIPParameter, sAccountNumberParameter, iEditionIdParameter);
        }
    
        public virtual ObjectResult<GetLicenseBySiteId_Result> GetLicenseBySiteId(Nullable<int> sSiteId)
        {
            var sSiteIdParameter = sSiteId.HasValue ?
                new ObjectParameter("sSiteId", sSiteId) :
                new ObjectParameter("sSiteId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetLicenseBySiteId_Result>("GetLicenseBySiteId", sSiteIdParameter);
        }
    
        public virtual ObjectResult<GetLicenseDetailByUserId_Result> GetLicenseDetailByUserId(Nullable<int> iUserId)
        {
            var iUserIdParameter = iUserId.HasValue ?
                new ObjectParameter("iUserId", iUserId) :
                new ObjectParameter("iUserId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetLicenseDetailByUserId_Result>("GetLicenseDetailByUserId", iUserIdParameter);
        }
    
        public virtual ObjectResult<GetLicenseDetailsById_Result> GetLicenseDetailsById(Nullable<int> id)
        {
            var idParameter = id.HasValue ?
                new ObjectParameter("Id", id) :
                new ObjectParameter("Id", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetLicenseDetailsById_Result>("GetLicenseDetailsById", idParameter);
        }
    
        public virtual ObjectResult<Nullable<int>> GetLicenseEditionIdByUserId(Nullable<int> userId)
        {
            var userIdParameter = userId.HasValue ?
                new ObjectParameter("UserId", userId) :
                new ObjectParameter("UserId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<int>>("GetLicenseEditionIdByUserId", userIdParameter);
        }
    
        public virtual ObjectResult<Nullable<int>> GetLicenseEditionIdForUser(Nullable<int> userId)
        {
            var userIdParameter = userId.HasValue ?
                new ObjectParameter("UserId", userId) :
                new ObjectParameter("UserId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<int>>("GetLicenseEditionIdForUser", userIdParameter);
        }
    
        public virtual ObjectResult<GetLicenseEditionsForModesty_Result> GetLicenseEditionsForModesty(Nullable<int> iLicenseId, Nullable<int> iBuildingLevelId)
        {
            var iLicenseIdParameter = iLicenseId.HasValue ?
                new ObjectParameter("iLicenseId", iLicenseId) :
                new ObjectParameter("iLicenseId", typeof(int));
    
            var iBuildingLevelIdParameter = iBuildingLevelId.HasValue ?
                new ObjectParameter("iBuildingLevelId", iBuildingLevelId) :
                new ObjectParameter("iBuildingLevelId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetLicenseEditionsForModesty_Result>("GetLicenseEditionsForModesty", iLicenseIdParameter, iBuildingLevelIdParameter);
        }
    
        public virtual ObjectResult<GetLicenseIdBySiteUrl_Result> GetLicenseIdBySiteUrl(string sLicenseAccount, Nullable<int> iEditionId)
        {
            var sLicenseAccountParameter = sLicenseAccount != null ?
                new ObjectParameter("sLicenseAccount", sLicenseAccount) :
                new ObjectParameter("sLicenseAccount", typeof(string));
    
            var iEditionIdParameter = iEditionId.HasValue ?
                new ObjectParameter("iEditionId", iEditionId) :
                new ObjectParameter("iEditionId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetLicenseIdBySiteUrl_Result>("GetLicenseIdBySiteUrl", sLicenseAccountParameter, iEditionIdParameter);
        }
    
        public virtual ObjectResult<GetLicenseIdEditionIdByUserId_Result> GetLicenseIdEditionIdByUserId(Nullable<int> iUserId)
        {
            var iUserIdParameter = iUserId.HasValue ?
                new ObjectParameter("iUserId", iUserId) :
                new ObjectParameter("iUserId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetLicenseIdEditionIdByUserId_Result>("GetLicenseIdEditionIdByUserId", iUserIdParameter);
        }
    
        public virtual ObjectResult<GetLoginFailureErrorReport_Result> GetLoginFailureErrorReport(string sFromDate, string sToDate, string sAccoutNumber, Nullable<byte> sFailureCause)
        {
            var sFromDateParameter = sFromDate != null ?
                new ObjectParameter("sFromDate", sFromDate) :
                new ObjectParameter("sFromDate", typeof(string));
    
            var sToDateParameter = sToDate != null ?
                new ObjectParameter("sToDate", sToDate) :
                new ObjectParameter("sToDate", typeof(string));
    
            var sAccoutNumberParameter = sAccoutNumber != null ?
                new ObjectParameter("sAccoutNumber", sAccoutNumber) :
                new ObjectParameter("sAccoutNumber", typeof(string));
    
            var sFailureCauseParameter = sFailureCause.HasValue ?
                new ObjectParameter("sFailureCause", sFailureCause) :
                new ObjectParameter("sFailureCause", typeof(byte));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetLoginFailureErrorReport_Result>("GetLoginFailureErrorReport", sFromDateParameter, sToDateParameter, sAccoutNumberParameter, sFailureCauseParameter);
        }
    
        public virtual ObjectResult<GetModulesByUserId_Result> GetModulesByUserId(Nullable<int> iUserId)
        {
            var iUserIdParameter = iUserId.HasValue ?
                new ObjectParameter("iUserId", iUserId) :
                new ObjectParameter("iUserId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetModulesByUserId_Result>("GetModulesByUserId", iUserIdParameter);
        }
    
        public virtual ObjectResult<GetModuleStatusByLicenseId_Result> GetModuleStatusByLicenseId(Nullable<int> iLicenseId)
        {
            var iLicenseIdParameter = iLicenseId.HasValue ?
                new ObjectParameter("iLicenseId", iLicenseId) :
                new ObjectParameter("iLicenseId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetModuleStatusByLicenseId_Result>("GetModuleStatusByLicenseId", iLicenseIdParameter);
        }
    
        public virtual ObjectResult<GetNetAdDetailReport_Result> GetNetAdDetailReport(string sFromDate, string sToDate, string sLicenseType, string sAccountType, Nullable<decimal> iStartPrice, Nullable<decimal> iEndPrice)
        {
            var sFromDateParameter = sFromDate != null ?
                new ObjectParameter("sFromDate", sFromDate) :
                new ObjectParameter("sFromDate", typeof(string));
    
            var sToDateParameter = sToDate != null ?
                new ObjectParameter("sToDate", sToDate) :
                new ObjectParameter("sToDate", typeof(string));
    
            var sLicenseTypeParameter = sLicenseType != null ?
                new ObjectParameter("sLicenseType", sLicenseType) :
                new ObjectParameter("sLicenseType", typeof(string));
    
            var sAccountTypeParameter = sAccountType != null ?
                new ObjectParameter("sAccountType", sAccountType) :
                new ObjectParameter("sAccountType", typeof(string));
    
            var iStartPriceParameter = iStartPrice.HasValue ?
                new ObjectParameter("iStartPrice", iStartPrice) :
                new ObjectParameter("iStartPrice", typeof(decimal));
    
            var iEndPriceParameter = iEndPrice.HasValue ?
                new ObjectParameter("iEndPrice", iEndPrice) :
                new ObjectParameter("iEndPrice", typeof(decimal));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetNetAdDetailReport_Result>("GetNetAdDetailReport", sFromDateParameter, sToDateParameter, sLicenseTypeParameter, sAccountTypeParameter, iStartPriceParameter, iEndPriceParameter);
        }
    
        public virtual ObjectResult<GetNetAdSummaryReport_Result> GetNetAdSummaryReport(string sFromDate, string sToDate, Nullable<decimal> iStartPrice, Nullable<decimal> iEndPrice, Nullable<byte> iLicenseTypeId, Nullable<int> pageNo, Nullable<int> pageLength, ObjectParameter recordCount)
        {
            var sFromDateParameter = sFromDate != null ?
                new ObjectParameter("sFromDate", sFromDate) :
                new ObjectParameter("sFromDate", typeof(string));
    
            var sToDateParameter = sToDate != null ?
                new ObjectParameter("sToDate", sToDate) :
                new ObjectParameter("sToDate", typeof(string));
    
            var iStartPriceParameter = iStartPrice.HasValue ?
                new ObjectParameter("iStartPrice", iStartPrice) :
                new ObjectParameter("iStartPrice", typeof(decimal));
    
            var iEndPriceParameter = iEndPrice.HasValue ?
                new ObjectParameter("iEndPrice", iEndPrice) :
                new ObjectParameter("iEndPrice", typeof(decimal));
    
            var iLicenseTypeIdParameter = iLicenseTypeId.HasValue ?
                new ObjectParameter("iLicenseTypeId", iLicenseTypeId) :
                new ObjectParameter("iLicenseTypeId", typeof(byte));
    
            var pageNoParameter = pageNo.HasValue ?
                new ObjectParameter("pageNo", pageNo) :
                new ObjectParameter("pageNo", typeof(int));
    
            var pageLengthParameter = pageLength.HasValue ?
                new ObjectParameter("pageLength", pageLength) :
                new ObjectParameter("pageLength", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetNetAdSummaryReport_Result>("GetNetAdSummaryReport", sFromDateParameter, sToDateParameter, iStartPriceParameter, iEndPriceParameter, iLicenseTypeIdParameter, pageNoParameter, pageLengthParameter, recordCount);
        }
    
        public virtual ObjectResult<GetProductFeatures_Result> GetProductFeatures(Nullable<int> editionId)
        {
            var editionIdParameter = editionId.HasValue ?
                new ObjectParameter("EditionId", editionId) :
                new ObjectParameter("EditionId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetProductFeatures_Result>("GetProductFeatures", editionIdParameter);
        }
    
        public virtual int GetSchedulerAlertEmail(ObjectParameter sSchedulerEmail, ObjectParameter sDeploymentEnvironment)
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("GetSchedulerAlertEmail", sSchedulerEmail, sDeploymentEnvironment);
        }
    
        public virtual ObjectResult<GetSearchDetails_Result> GetSearchDetails()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetSearchDetails_Result>("GetSearchDetails");
        }
    
        public virtual ObjectResult<GetSearchTerms_Result> GetSearchTerms()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetSearchTerms_Result>("GetSearchTerms");
        }
    
        public virtual int GetSearchUserList(string sFirstName, string sLastName, string sEmailId, string sAccoutNumber, Nullable<int> iUserTypeId, Nullable<int> iAccountTypeId, Nullable<int> iLoginUserType, Nullable<int> pageNo, Nullable<int> pageLength, ObjectParameter recordCount)
        {
            var sFirstNameParameter = sFirstName != null ?
                new ObjectParameter("sFirstName", sFirstName) :
                new ObjectParameter("sFirstName", typeof(string));
    
            var sLastNameParameter = sLastName != null ?
                new ObjectParameter("sLastName", sLastName) :
                new ObjectParameter("sLastName", typeof(string));
    
            var sEmailIdParameter = sEmailId != null ?
                new ObjectParameter("sEmailId", sEmailId) :
                new ObjectParameter("sEmailId", typeof(string));
    
            var sAccoutNumberParameter = sAccoutNumber != null ?
                new ObjectParameter("sAccoutNumber", sAccoutNumber) :
                new ObjectParameter("sAccoutNumber", typeof(string));
    
            var iUserTypeIdParameter = iUserTypeId.HasValue ?
                new ObjectParameter("iUserTypeId", iUserTypeId) :
                new ObjectParameter("iUserTypeId", typeof(int));
    
            var iAccountTypeIdParameter = iAccountTypeId.HasValue ?
                new ObjectParameter("iAccountTypeId", iAccountTypeId) :
                new ObjectParameter("iAccountTypeId", typeof(int));
    
            var iLoginUserTypeParameter = iLoginUserType.HasValue ?
                new ObjectParameter("iLoginUserType", iLoginUserType) :
                new ObjectParameter("iLoginUserType", typeof(int));
    
            var pageNoParameter = pageNo.HasValue ?
                new ObjectParameter("pageNo", pageNo) :
                new ObjectParameter("pageNo", typeof(int));
    
            var pageLengthParameter = pageLength.HasValue ?
                new ObjectParameter("pageLength", pageLength) :
                new ObjectParameter("pageLength", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("GetSearchUserList", sFirstNameParameter, sLastNameParameter, sEmailIdParameter, sAccoutNumberParameter, iUserTypeIdParameter, iAccountTypeIdParameter, iLoginUserTypeParameter, pageNoParameter, pageLengthParameter, recordCount);
        }
    
        public virtual ObjectResult<GetSearchUsers_Result> GetSearchUsers(string sFirstName, string sLastName, string sEmailId, string sAccoutNumber, Nullable<int> iUserTypeId, Nullable<int> iAccountTypeId, Nullable<int> iLoginUserType, Nullable<int> pageNo, Nullable<int> pageLength, ObjectParameter recordCount)
        {
            var sFirstNameParameter = sFirstName != null ?
                new ObjectParameter("sFirstName", sFirstName) :
                new ObjectParameter("sFirstName", typeof(string));
    
            var sLastNameParameter = sLastName != null ?
                new ObjectParameter("sLastName", sLastName) :
                new ObjectParameter("sLastName", typeof(string));
    
            var sEmailIdParameter = sEmailId != null ?
                new ObjectParameter("sEmailId", sEmailId) :
                new ObjectParameter("sEmailId", typeof(string));
    
            var sAccoutNumberParameter = sAccoutNumber != null ?
                new ObjectParameter("sAccoutNumber", sAccoutNumber) :
                new ObjectParameter("sAccoutNumber", typeof(string));
    
            var iUserTypeIdParameter = iUserTypeId.HasValue ?
                new ObjectParameter("iUserTypeId", iUserTypeId) :
                new ObjectParameter("iUserTypeId", typeof(int));
    
            var iAccountTypeIdParameter = iAccountTypeId.HasValue ?
                new ObjectParameter("iAccountTypeId", iAccountTypeId) :
                new ObjectParameter("iAccountTypeId", typeof(int));
    
            var iLoginUserTypeParameter = iLoginUserType.HasValue ?
                new ObjectParameter("iLoginUserType", iLoginUserType) :
                new ObjectParameter("iLoginUserType", typeof(int));
    
            var pageNoParameter = pageNo.HasValue ?
                new ObjectParameter("pageNo", pageNo) :
                new ObjectParameter("pageNo", typeof(int));
    
            var pageLengthParameter = pageLength.HasValue ?
                new ObjectParameter("pageLength", pageLength) :
                new ObjectParameter("pageLength", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetSearchUsers_Result>("GetSearchUsers", sFirstNameParameter, sLastNameParameter, sEmailIdParameter, sAccoutNumberParameter, iUserTypeIdParameter, iAccountTypeIdParameter, iLoginUserTypeParameter, pageNoParameter, pageLengthParameter, recordCount);
        }
    
        public virtual ObjectResult<GetSiteAccoutDetail_Result> GetSiteAccoutDetail(string strAccountNumber, Nullable<int> pageNo, Nullable<int> pageLength, ObjectParameter recordCount)
        {
            var strAccountNumberParameter = strAccountNumber != null ?
                new ObjectParameter("strAccountNumber", strAccountNumber) :
                new ObjectParameter("strAccountNumber", typeof(string));
    
            var pageNoParameter = pageNo.HasValue ?
                new ObjectParameter("pageNo", pageNo) :
                new ObjectParameter("pageNo", typeof(int));
    
            var pageLengthParameter = pageLength.HasValue ?
                new ObjectParameter("pageLength", pageLength) :
                new ObjectParameter("pageLength", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetSiteAccoutDetail_Result>("GetSiteAccoutDetail", strAccountNumberParameter, pageNoParameter, pageLengthParameter, recordCount);
        }
    
        public virtual ObjectResult<GetSiteIpByAccountNumber_Result> GetSiteIpByAccountNumber(string accountNumner)
        {
            var accountNumnerParameter = accountNumner != null ?
                new ObjectParameter("AccountNumner", accountNumner) :
                new ObjectParameter("AccountNumner", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetSiteIpByAccountNumber_Result>("GetSiteIpByAccountNumber", accountNumnerParameter);
        }
    
        public virtual ObjectResult<GetSiteLicenseUsageReport_Result> GetSiteLicenseUsageReport(string sFromDate, string sToDate, string sAccoutNumber, Nullable<byte> iEditionId, Nullable<int> pageNo, Nullable<int> pageLength, ObjectParameter recordCount)
        {
            var sFromDateParameter = sFromDate != null ?
                new ObjectParameter("sFromDate", sFromDate) :
                new ObjectParameter("sFromDate", typeof(string));
    
            var sToDateParameter = sToDate != null ?
                new ObjectParameter("sToDate", sToDate) :
                new ObjectParameter("sToDate", typeof(string));
    
            var sAccoutNumberParameter = sAccoutNumber != null ?
                new ObjectParameter("sAccoutNumber", sAccoutNumber) :
                new ObjectParameter("sAccoutNumber", typeof(string));
    
            var iEditionIdParameter = iEditionId.HasValue ?
                new ObjectParameter("iEditionId", iEditionId) :
                new ObjectParameter("iEditionId", typeof(byte));
    
            var pageNoParameter = pageNo.HasValue ?
                new ObjectParameter("pageNo", pageNo) :
                new ObjectParameter("pageNo", typeof(int));
    
            var pageLengthParameter = pageLength.HasValue ?
                new ObjectParameter("pageLength", pageLength) :
                new ObjectParameter("pageLength", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetSiteLicenseUsageReport_Result>("GetSiteLicenseUsageReport", sFromDateParameter, sToDateParameter, sAccoutNumberParameter, iEditionIdParameter, pageNoParameter, pageLengthParameter, recordCount);
        }
    
        public virtual ObjectResult<GetSubscribedLicenses_Result> GetSubscribedLicenses(string sFromDate, string sToDate, Nullable<decimal> iStartPrice, Nullable<decimal> iEndPrice, Nullable<byte> iLicenseTypeId, Nullable<byte> iAccountTypeId, string sZip, Nullable<int> iStateId, Nullable<int> iCountryId, Nullable<int> pageNo, Nullable<int> pageLength, ObjectParameter recordCount)
        {
            var sFromDateParameter = sFromDate != null ?
                new ObjectParameter("sFromDate", sFromDate) :
                new ObjectParameter("sFromDate", typeof(string));
    
            var sToDateParameter = sToDate != null ?
                new ObjectParameter("sToDate", sToDate) :
                new ObjectParameter("sToDate", typeof(string));
    
            var iStartPriceParameter = iStartPrice.HasValue ?
                new ObjectParameter("iStartPrice", iStartPrice) :
                new ObjectParameter("iStartPrice", typeof(decimal));
    
            var iEndPriceParameter = iEndPrice.HasValue ?
                new ObjectParameter("iEndPrice", iEndPrice) :
                new ObjectParameter("iEndPrice", typeof(decimal));
    
            var iLicenseTypeIdParameter = iLicenseTypeId.HasValue ?
                new ObjectParameter("iLicenseTypeId", iLicenseTypeId) :
                new ObjectParameter("iLicenseTypeId", typeof(byte));
    
            var iAccountTypeIdParameter = iAccountTypeId.HasValue ?
                new ObjectParameter("iAccountTypeId", iAccountTypeId) :
                new ObjectParameter("iAccountTypeId", typeof(byte));
    
            var sZipParameter = sZip != null ?
                new ObjectParameter("sZip", sZip) :
                new ObjectParameter("sZip", typeof(string));
    
            var iStateIdParameter = iStateId.HasValue ?
                new ObjectParameter("iStateId", iStateId) :
                new ObjectParameter("iStateId", typeof(int));
    
            var iCountryIdParameter = iCountryId.HasValue ?
                new ObjectParameter("iCountryId", iCountryId) :
                new ObjectParameter("iCountryId", typeof(int));
    
            var pageNoParameter = pageNo.HasValue ?
                new ObjectParameter("pageNo", pageNo) :
                new ObjectParameter("pageNo", typeof(int));
    
            var pageLengthParameter = pageLength.HasValue ?
                new ObjectParameter("pageLength", pageLength) :
                new ObjectParameter("pageLength", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetSubscribedLicenses_Result>("GetSubscribedLicenses", sFromDateParameter, sToDateParameter, iStartPriceParameter, iEndPriceParameter, iLicenseTypeIdParameter, iAccountTypeIdParameter, sZipParameter, iStateIdParameter, iCountryIdParameter, pageNoParameter, pageLengthParameter, recordCount);
        }
    
        public virtual ObjectResult<GetSubscriptionDetailsByLicenseId_Result> GetSubscriptionDetailsByLicenseId(Nullable<int> iLicenseId)
        {
            var iLicenseIdParameter = iLicenseId.HasValue ?
                new ObjectParameter("iLicenseId", iLicenseId) :
                new ObjectParameter("iLicenseId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetSubscriptionDetailsByLicenseId_Result>("GetSubscriptionDetailsByLicenseId", iLicenseIdParameter);
        }
    
        public virtual int GetTermNumberData()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("GetTermNumberData");
        }
    
        public virtual ObjectResult<GetTermsAndConditions_Result> GetTermsAndConditions()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetTermsAndConditions_Result>("GetTermsAndConditions");
        }
    
        public virtual ObjectResult<GetTermsOfServiceText_Result> GetTermsOfServiceText()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetTermsOfServiceText_Result>("GetTermsOfServiceText");
        }
    
        public virtual int GetThreeDHighLightData()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("GetThreeDHighLightData");
        }
    
        public virtual ObjectResult<GetTotalLoggedInUsersByLicenseIdAndEditionId_Result> GetTotalLoggedInUsersByLicenseIdAndEditionId(Nullable<int> iLicenseId, Nullable<int> iEditionId)
        {
            var iLicenseIdParameter = iLicenseId.HasValue ?
                new ObjectParameter("iLicenseId", iLicenseId) :
                new ObjectParameter("iLicenseId", typeof(int));
    
            var iEditionIdParameter = iEditionId.HasValue ?
                new ObjectParameter("iEditionId", iEditionId) :
                new ObjectParameter("iEditionId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetTotalLoggedInUsersByLicenseIdAndEditionId_Result>("GetTotalLoggedInUsersByLicenseIdAndEditionId", iLicenseIdParameter, iEditionIdParameter);
        }
    
        public virtual ObjectResult<Nullable<int>> GetTotalLoginsByLicenseEditionId(Nullable<int> licenseEditionId)
        {
            var licenseEditionIdParameter = licenseEditionId.HasValue ?
                new ObjectParameter("LicenseEditionId", licenseEditionId) :
                new ObjectParameter("LicenseEditionId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<int>>("GetTotalLoginsByLicenseEditionId", licenseEditionIdParameter);
        }
    
        public virtual ObjectResult<GetUsageReport_Result> GetUsageReport(string sFromDate, string sToDate, string sAccoutNumber, string sZip, Nullable<int> iState, Nullable<int> iCountry, Nullable<int> pageNo, Nullable<int> pageLength, ObjectParameter recordCount)
        {
            var sFromDateParameter = sFromDate != null ?
                new ObjectParameter("sFromDate", sFromDate) :
                new ObjectParameter("sFromDate", typeof(string));
    
            var sToDateParameter = sToDate != null ?
                new ObjectParameter("sToDate", sToDate) :
                new ObjectParameter("sToDate", typeof(string));
    
            var sAccoutNumberParameter = sAccoutNumber != null ?
                new ObjectParameter("sAccoutNumber", sAccoutNumber) :
                new ObjectParameter("sAccoutNumber", typeof(string));
    
            var sZipParameter = sZip != null ?
                new ObjectParameter("sZip", sZip) :
                new ObjectParameter("sZip", typeof(string));
    
            var iStateParameter = iState.HasValue ?
                new ObjectParameter("iState", iState) :
                new ObjectParameter("iState", typeof(int));
    
            var iCountryParameter = iCountry.HasValue ?
                new ObjectParameter("iCountry", iCountry) :
                new ObjectParameter("iCountry", typeof(int));
    
            var pageNoParameter = pageNo.HasValue ?
                new ObjectParameter("pageNo", pageNo) :
                new ObjectParameter("pageNo", typeof(int));
    
            var pageLengthParameter = pageLength.HasValue ?
                new ObjectParameter("pageLength", pageLength) :
                new ObjectParameter("pageLength", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetUsageReport_Result>("GetUsageReport", sFromDateParameter, sToDateParameter, sAccoutNumberParameter, sZipParameter, iStateParameter, iCountryParameter, pageNoParameter, pageLengthParameter, recordCount);
        }
    
        public virtual ObjectResult<GetUsageReport_OLD_PROC_Result> GetUsageReport_OLD_PROC(string sFromDate, string sToDate, string sAccoutNumber, string sZip, Nullable<int> iState, Nullable<int> iCountry)
        {
            var sFromDateParameter = sFromDate != null ?
                new ObjectParameter("sFromDate", sFromDate) :
                new ObjectParameter("sFromDate", typeof(string));
    
            var sToDateParameter = sToDate != null ?
                new ObjectParameter("sToDate", sToDate) :
                new ObjectParameter("sToDate", typeof(string));
    
            var sAccoutNumberParameter = sAccoutNumber != null ?
                new ObjectParameter("sAccoutNumber", sAccoutNumber) :
                new ObjectParameter("sAccoutNumber", typeof(string));
    
            var sZipParameter = sZip != null ?
                new ObjectParameter("sZip", sZip) :
                new ObjectParameter("sZip", typeof(string));
    
            var iStateParameter = iState.HasValue ?
                new ObjectParameter("iState", iState) :
                new ObjectParameter("iState", typeof(int));
    
            var iCountryParameter = iCountry.HasValue ?
                new ObjectParameter("iCountry", iCountry) :
                new ObjectParameter("iCountry", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetUsageReport_OLD_PROC_Result>("GetUsageReport_OLD_PROC", sFromDateParameter, sToDateParameter, sAccoutNumberParameter, sZipParameter, iStateParameter, iCountryParameter);
        }
    
        public virtual ObjectResult<GetUserByUserId_Result> GetUserByUserId(Nullable<int> id)
        {
            var idParameter = id.HasValue ?
                new ObjectParameter("Id", id) :
                new ObjectParameter("Id", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetUserByUserId_Result>("GetUserByUserId", idParameter);
        }
    
        public virtual ObjectResult<GetUserDetailsByLoginId_Result> GetUserDetailsByLoginId(string sLoginId)
        {
            var sLoginIdParameter = sLoginId != null ?
                new ObjectParameter("sLoginId", sLoginId) :
                new ObjectParameter("sLoginId", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetUserDetailsByLoginId_Result>("GetUserDetailsByLoginId", sLoginIdParameter);
        }
    
        public virtual ObjectResult<GetUserDetailsByLoginIdAndPassword_Result> GetUserDetailsByLoginIdAndPassword(string sLoginId, string sPassword)
        {
            var sLoginIdParameter = sLoginId != null ?
                new ObjectParameter("sLoginId", sLoginId) :
                new ObjectParameter("sLoginId", typeof(string));
    
            var sPasswordParameter = sPassword != null ?
                new ObjectParameter("sPassword", sPassword) :
                new ObjectParameter("sPassword", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetUserDetailsByLoginIdAndPassword_Result>("GetUserDetailsByLoginIdAndPassword", sLoginIdParameter, sPasswordParameter);
        }
    
        public virtual ObjectResult<GetUserInfoByEmailId_Result> GetUserInfoByEmailId(string sEmailId)
        {
            var sEmailIdParameter = sEmailId != null ?
                new ObjectParameter("sEmailId", sEmailId) :
                new ObjectParameter("sEmailId", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetUserInfoByEmailId_Result>("GetUserInfoByEmailId", sEmailIdParameter);
        }
    
        public virtual ObjectResult<GetUserInGroup_Result> GetUserInGroup(Nullable<int> iLicenseId, Nullable<int> iGroupId)
        {
            var iLicenseIdParameter = iLicenseId.HasValue ?
                new ObjectParameter("iLicenseId", iLicenseId) :
                new ObjectParameter("iLicenseId", typeof(int));
    
            var iGroupIdParameter = iGroupId.HasValue ?
                new ObjectParameter("iGroupId", iGroupId) :
                new ObjectParameter("iGroupId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetUserInGroup_Result>("GetUserInGroup", iLicenseIdParameter, iGroupIdParameter);
        }
    
        public virtual ObjectResult<GetUserlActivities_Result> GetUserlActivities(Nullable<int> iUserId)
        {
            var iUserIdParameter = iUserId.HasValue ?
                new ObjectParameter("iUserId", iUserId) :
                new ObjectParameter("iUserId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetUserlActivities_Result>("GetUserlActivities", iUserIdParameter);
        }
    
        public virtual ObjectResult<GetUserModulesByLicenseId_Result> GetUserModulesByLicenseId(Nullable<int> iLicenseId)
        {
            var iLicenseIdParameter = iLicenseId.HasValue ?
                new ObjectParameter("iLicenseId", iLicenseId) :
                new ObjectParameter("iLicenseId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetUserModulesByLicenseId_Result>("GetUserModulesByLicenseId", iLicenseIdParameter);
        }
    
        public virtual ObjectResult<GetUserSessionDetails_Result> GetUserSessionDetails(Nullable<int> iLicenseId, Nullable<byte> iEditionId)
        {
            var iLicenseIdParameter = iLicenseId.HasValue ?
                new ObjectParameter("iLicenseId", iLicenseId) :
                new ObjectParameter("iLicenseId", typeof(int));
    
            var iEditionIdParameter = iEditionId.HasValue ?
                new ObjectParameter("iEditionId", iEditionId) :
                new ObjectParameter("iEditionId", typeof(byte));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetUserSessionDetails_Result>("GetUserSessionDetails", iLicenseIdParameter, iEditionIdParameter);
        }
    
        public virtual ObjectResult<GetUserTyeByAccountNumber_Result> GetUserTyeByAccountNumber(Nullable<byte> iUserTypeId, Nullable<int> iLicenseId)
        {
            var iUserTypeIdParameter = iUserTypeId.HasValue ?
                new ObjectParameter("iUserTypeId", iUserTypeId) :
                new ObjectParameter("iUserTypeId", typeof(byte));
    
            var iLicenseIdParameter = iLicenseId.HasValue ?
                new ObjectParameter("iLicenseId", iLicenseId) :
                new ObjectParameter("iLicenseId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetUserTyeByAccountNumber_Result>("GetUserTyeByAccountNumber", iUserTypeIdParameter, iLicenseIdParameter);
        }
    
        public virtual ObjectResult<Nullable<System.DateTime>> IncorrectLoginAttempt(Nullable<int> iUserId)
        {
            var iUserIdParameter = iUserId.HasValue ?
                new ObjectParameter("iUserId", iUserId) :
                new ObjectParameter("iUserId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<System.DateTime>>("IncorrectLoginAttempt", iUserIdParameter);
        }
    
        public virtual int InsertAIAUser(string sLoginId, string sPassword, string sFirstname, string sLastname, Nullable<byte> iUserTypeId, string sEmailId, Nullable<byte> iSecurityQuesId, string sSecurityAnswer, Nullable<int> iCreatorId, Nullable<int> iLicenseId, Nullable<byte> iEditionId, ObjectParameter status)
        {
            var sLoginIdParameter = sLoginId != null ?
                new ObjectParameter("sLoginId", sLoginId) :
                new ObjectParameter("sLoginId", typeof(string));
    
            var sPasswordParameter = sPassword != null ?
                new ObjectParameter("sPassword", sPassword) :
                new ObjectParameter("sPassword", typeof(string));
    
            var sFirstnameParameter = sFirstname != null ?
                new ObjectParameter("sFirstname", sFirstname) :
                new ObjectParameter("sFirstname", typeof(string));
    
            var sLastnameParameter = sLastname != null ?
                new ObjectParameter("sLastname", sLastname) :
                new ObjectParameter("sLastname", typeof(string));
    
            var iUserTypeIdParameter = iUserTypeId.HasValue ?
                new ObjectParameter("iUserTypeId", iUserTypeId) :
                new ObjectParameter("iUserTypeId", typeof(byte));
    
            var sEmailIdParameter = sEmailId != null ?
                new ObjectParameter("sEmailId", sEmailId) :
                new ObjectParameter("sEmailId", typeof(string));
    
            var iSecurityQuesIdParameter = iSecurityQuesId.HasValue ?
                new ObjectParameter("iSecurityQuesId", iSecurityQuesId) :
                new ObjectParameter("iSecurityQuesId", typeof(byte));
    
            var sSecurityAnswerParameter = sSecurityAnswer != null ?
                new ObjectParameter("sSecurityAnswer", sSecurityAnswer) :
                new ObjectParameter("sSecurityAnswer", typeof(string));
    
            var iCreatorIdParameter = iCreatorId.HasValue ?
                new ObjectParameter("iCreatorId", iCreatorId) :
                new ObjectParameter("iCreatorId", typeof(int));
    
            var iLicenseIdParameter = iLicenseId.HasValue ?
                new ObjectParameter("iLicenseId", iLicenseId) :
                new ObjectParameter("iLicenseId", typeof(int));
    
            var iEditionIdParameter = iEditionId.HasValue ?
                new ObjectParameter("iEditionId", iEditionId) :
                new ObjectParameter("iEditionId", typeof(byte));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("InsertAIAUser", sLoginIdParameter, sPasswordParameter, sFirstnameParameter, sLastnameParameter, iUserTypeIdParameter, sEmailIdParameter, iSecurityQuesIdParameter, sSecurityAnswerParameter, iCreatorIdParameter, iLicenseIdParameter, iEditionIdParameter, status);
        }
    
        public virtual int InsertDemoLicenseAccount()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("InsertDemoLicenseAccount");
        }
    
        public virtual int InsertIncorrectLoginAttempt(Nullable<int> iUserId)
        {
            var iUserIdParameter = iUserId.HasValue ?
                new ObjectParameter("iUserId", iUserId) :
                new ObjectParameter("iUserId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("InsertIncorrectLoginAttempt", iUserIdParameter);
        }
    
        public virtual int InsertIncorrectLoginAttempts(Nullable<int> iUserId)
        {
            var iUserIdParameter = iUserId.HasValue ?
                new ObjectParameter("iUserId", iUserId) :
                new ObjectParameter("iUserId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("InsertIncorrectLoginAttempts", iUserIdParameter);
        }
    
        public virtual int InsertLoginDetail(Nullable<int> iUserId)
        {
            var iUserIdParameter = iUserId.HasValue ?
                new ObjectParameter("iUserId", iUserId) :
                new ObjectParameter("iUserId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("InsertLoginDetail", iUserIdParameter);
        }
    
        public virtual int InsertLoginDetail_1(Nullable<int> iUserId, string callFromURL)
        {
            var iUserIdParameter = iUserId.HasValue ?
                new ObjectParameter("iUserId", iUserId) :
                new ObjectParameter("iUserId", typeof(int));
    
            var callFromURLParameter = callFromURL != null ?
                new ObjectParameter("CallFromURL", callFromURL) :
                new ObjectParameter("CallFromURL", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("InsertLoginDetail_1", iUserIdParameter, callFromURLParameter);
        }
    
        public virtual int InsertLoginDetailsInSessionManager(string sSessionId, Nullable<int> iUserId, Nullable<int> iLicenseId, Nullable<int> iEditionId)
        {
            var sSessionIdParameter = sSessionId != null ?
                new ObjectParameter("sSessionId", sSessionId) :
                new ObjectParameter("sSessionId", typeof(string));
    
            var iUserIdParameter = iUserId.HasValue ?
                new ObjectParameter("iUserId", iUserId) :
                new ObjectParameter("iUserId", typeof(int));
    
            var iLicenseIdParameter = iLicenseId.HasValue ?
                new ObjectParameter("iLicenseId", iLicenseId) :
                new ObjectParameter("iLicenseId", typeof(int));
    
            var iEditionIdParameter = iEditionId.HasValue ?
                new ObjectParameter("iEditionId", iEditionId) :
                new ObjectParameter("iEditionId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("InsertLoginDetailsInSessionManager", sSessionIdParameter, iUserIdParameter, iLicenseIdParameter, iEditionIdParameter);
        }
    
        public virtual int InsertLoginErrorLog(string nvAccountNumber, Nullable<System.DateTime> dtLogDate, Nullable<byte> tiFailureId, string nvReferalUrl, string nvEdition, string nvHttpReferer)
        {
            var nvAccountNumberParameter = nvAccountNumber != null ?
                new ObjectParameter("nvAccountNumber", nvAccountNumber) :
                new ObjectParameter("nvAccountNumber", typeof(string));
    
            var dtLogDateParameter = dtLogDate.HasValue ?
                new ObjectParameter("dtLogDate", dtLogDate) :
                new ObjectParameter("dtLogDate", typeof(System.DateTime));
    
            var tiFailureIdParameter = tiFailureId.HasValue ?
                new ObjectParameter("tiFailureId", tiFailureId) :
                new ObjectParameter("tiFailureId", typeof(byte));
    
            var nvReferalUrlParameter = nvReferalUrl != null ?
                new ObjectParameter("nvReferalUrl", nvReferalUrl) :
                new ObjectParameter("nvReferalUrl", typeof(string));
    
            var nvEditionParameter = nvEdition != null ?
                new ObjectParameter("nvEdition", nvEdition) :
                new ObjectParameter("nvEdition", typeof(string));
    
            var nvHttpRefererParameter = nvHttpReferer != null ?
                new ObjectParameter("nvHttpReferer", nvHttpReferer) :
                new ObjectParameter("nvHttpReferer", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("InsertLoginErrorLog", nvAccountNumberParameter, dtLogDateParameter, tiFailureIdParameter, nvReferalUrlParameter, nvEditionParameter, nvHttpRefererParameter);
        }
    
        public virtual ObjectResult<string> InsertNewDiscount(Nullable<decimal> dPercentage, string sStartDate, string sEndDate, string sDiscountCode)
        {
            var dPercentageParameter = dPercentage.HasValue ?
                new ObjectParameter("dPercentage", dPercentage) :
                new ObjectParameter("dPercentage", typeof(decimal));
    
            var sStartDateParameter = sStartDate != null ?
                new ObjectParameter("sStartDate", sStartDate) :
                new ObjectParameter("sStartDate", typeof(string));
    
            var sEndDateParameter = sEndDate != null ?
                new ObjectParameter("sEndDate", sEndDate) :
                new ObjectParameter("sEndDate", typeof(string));
    
            var sDiscountCodeParameter = sDiscountCode != null ?
                new ObjectParameter("sDiscountCode", sDiscountCode) :
                new ObjectParameter("sDiscountCode", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("InsertNewDiscount", dPercentageParameter, sStartDateParameter, sEndDateParameter, sDiscountCodeParameter);
        }
    
        public virtual ObjectResult<string> InsertNewLicenseAccount(string sAccountNumber, string sLicenseeFname, string sLicenseeLname, Nullable<byte> iLicenseTypeId, Nullable<byte> iAccountTypeId, string sInstitutionName, string sAddress1, string sAddress2, string sCity, string sZip, Nullable<int> iStateId, Nullable<int> iCountryId, string sPhone, string sEmailId, Nullable<int> iTotalLogins, string sStartDate, string sEndDate, string sMasterIP, string sEditionList, Nullable<decimal> iPrice, string sProductKey, string sSiteIPTo, string sSiteMasterIPTo, Nullable<int> iNoofImages)
        {
            var sAccountNumberParameter = sAccountNumber != null ?
                new ObjectParameter("sAccountNumber", sAccountNumber) :
                new ObjectParameter("sAccountNumber", typeof(string));
    
            var sLicenseeFnameParameter = sLicenseeFname != null ?
                new ObjectParameter("sLicenseeFname", sLicenseeFname) :
                new ObjectParameter("sLicenseeFname", typeof(string));
    
            var sLicenseeLnameParameter = sLicenseeLname != null ?
                new ObjectParameter("sLicenseeLname", sLicenseeLname) :
                new ObjectParameter("sLicenseeLname", typeof(string));
    
            var iLicenseTypeIdParameter = iLicenseTypeId.HasValue ?
                new ObjectParameter("iLicenseTypeId", iLicenseTypeId) :
                new ObjectParameter("iLicenseTypeId", typeof(byte));
    
            var iAccountTypeIdParameter = iAccountTypeId.HasValue ?
                new ObjectParameter("iAccountTypeId", iAccountTypeId) :
                new ObjectParameter("iAccountTypeId", typeof(byte));
    
            var sInstitutionNameParameter = sInstitutionName != null ?
                new ObjectParameter("sInstitutionName", sInstitutionName) :
                new ObjectParameter("sInstitutionName", typeof(string));
    
            var sAddress1Parameter = sAddress1 != null ?
                new ObjectParameter("sAddress1", sAddress1) :
                new ObjectParameter("sAddress1", typeof(string));
    
            var sAddress2Parameter = sAddress2 != null ?
                new ObjectParameter("sAddress2", sAddress2) :
                new ObjectParameter("sAddress2", typeof(string));
    
            var sCityParameter = sCity != null ?
                new ObjectParameter("sCity", sCity) :
                new ObjectParameter("sCity", typeof(string));
    
            var sZipParameter = sZip != null ?
                new ObjectParameter("sZip", sZip) :
                new ObjectParameter("sZip", typeof(string));
    
            var iStateIdParameter = iStateId.HasValue ?
                new ObjectParameter("iStateId", iStateId) :
                new ObjectParameter("iStateId", typeof(int));
    
            var iCountryIdParameter = iCountryId.HasValue ?
                new ObjectParameter("iCountryId", iCountryId) :
                new ObjectParameter("iCountryId", typeof(int));
    
            var sPhoneParameter = sPhone != null ?
                new ObjectParameter("sPhone", sPhone) :
                new ObjectParameter("sPhone", typeof(string));
    
            var sEmailIdParameter = sEmailId != null ?
                new ObjectParameter("sEmailId", sEmailId) :
                new ObjectParameter("sEmailId", typeof(string));
    
            var iTotalLoginsParameter = iTotalLogins.HasValue ?
                new ObjectParameter("iTotalLogins", iTotalLogins) :
                new ObjectParameter("iTotalLogins", typeof(int));
    
            var sStartDateParameter = sStartDate != null ?
                new ObjectParameter("sStartDate", sStartDate) :
                new ObjectParameter("sStartDate", typeof(string));
    
            var sEndDateParameter = sEndDate != null ?
                new ObjectParameter("sEndDate", sEndDate) :
                new ObjectParameter("sEndDate", typeof(string));
    
            var sMasterIPParameter = sMasterIP != null ?
                new ObjectParameter("sMasterIP", sMasterIP) :
                new ObjectParameter("sMasterIP", typeof(string));
    
            var sEditionListParameter = sEditionList != null ?
                new ObjectParameter("sEditionList", sEditionList) :
                new ObjectParameter("sEditionList", typeof(string));
    
            var iPriceParameter = iPrice.HasValue ?
                new ObjectParameter("iPrice", iPrice) :
                new ObjectParameter("iPrice", typeof(decimal));
    
            var sProductKeyParameter = sProductKey != null ?
                new ObjectParameter("sProductKey", sProductKey) :
                new ObjectParameter("sProductKey", typeof(string));
    
            var sSiteIPToParameter = sSiteIPTo != null ?
                new ObjectParameter("sSiteIPTo", sSiteIPTo) :
                new ObjectParameter("sSiteIPTo", typeof(string));
    
            var sSiteMasterIPToParameter = sSiteMasterIPTo != null ?
                new ObjectParameter("sSiteMasterIPTo", sSiteMasterIPTo) :
                new ObjectParameter("sSiteMasterIPTo", typeof(string));
    
            var iNoofImagesParameter = iNoofImages.HasValue ?
                new ObjectParameter("iNoofImages", iNoofImages) :
                new ObjectParameter("iNoofImages", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("InsertNewLicenseAccount", sAccountNumberParameter, sLicenseeFnameParameter, sLicenseeLnameParameter, iLicenseTypeIdParameter, iAccountTypeIdParameter, sInstitutionNameParameter, sAddress1Parameter, sAddress2Parameter, sCityParameter, sZipParameter, iStateIdParameter, iCountryIdParameter, sPhoneParameter, sEmailIdParameter, iTotalLoginsParameter, sStartDateParameter, sEndDateParameter, sMasterIPParameter, sEditionListParameter, iPriceParameter, sProductKeyParameter, sSiteIPToParameter, sSiteMasterIPToParameter, iNoofImagesParameter);
        }
    
        public virtual ObjectResult<InsertResellerLicenseAccount_Result> InsertResellerLicenseAccount(string sLicenseeFname, string sLicenseeLname, Nullable<byte> iLicenseTypeId, Nullable<byte> iAccountTypeId, string sInstitutionName, string sAddress1, string sAddress2, string sCity, string sZip, Nullable<int> iStateId, Nullable<int> iCountryId, string sPhone, string sEmailId, Nullable<int> iTotalLogins, string sStartDate, string sEndDate, string sEditionList, Nullable<decimal> iTotalPrice, Nullable<int> iCreatorId, string sProductKey, Nullable<int> iNoofImages)
        {
            var sLicenseeFnameParameter = sLicenseeFname != null ?
                new ObjectParameter("sLicenseeFname", sLicenseeFname) :
                new ObjectParameter("sLicenseeFname", typeof(string));
    
            var sLicenseeLnameParameter = sLicenseeLname != null ?
                new ObjectParameter("sLicenseeLname", sLicenseeLname) :
                new ObjectParameter("sLicenseeLname", typeof(string));
    
            var iLicenseTypeIdParameter = iLicenseTypeId.HasValue ?
                new ObjectParameter("iLicenseTypeId", iLicenseTypeId) :
                new ObjectParameter("iLicenseTypeId", typeof(byte));
    
            var iAccountTypeIdParameter = iAccountTypeId.HasValue ?
                new ObjectParameter("iAccountTypeId", iAccountTypeId) :
                new ObjectParameter("iAccountTypeId", typeof(byte));
    
            var sInstitutionNameParameter = sInstitutionName != null ?
                new ObjectParameter("sInstitutionName", sInstitutionName) :
                new ObjectParameter("sInstitutionName", typeof(string));
    
            var sAddress1Parameter = sAddress1 != null ?
                new ObjectParameter("sAddress1", sAddress1) :
                new ObjectParameter("sAddress1", typeof(string));
    
            var sAddress2Parameter = sAddress2 != null ?
                new ObjectParameter("sAddress2", sAddress2) :
                new ObjectParameter("sAddress2", typeof(string));
    
            var sCityParameter = sCity != null ?
                new ObjectParameter("sCity", sCity) :
                new ObjectParameter("sCity", typeof(string));
    
            var sZipParameter = sZip != null ?
                new ObjectParameter("sZip", sZip) :
                new ObjectParameter("sZip", typeof(string));
    
            var iStateIdParameter = iStateId.HasValue ?
                new ObjectParameter("iStateId", iStateId) :
                new ObjectParameter("iStateId", typeof(int));
    
            var iCountryIdParameter = iCountryId.HasValue ?
                new ObjectParameter("iCountryId", iCountryId) :
                new ObjectParameter("iCountryId", typeof(int));
    
            var sPhoneParameter = sPhone != null ?
                new ObjectParameter("sPhone", sPhone) :
                new ObjectParameter("sPhone", typeof(string));
    
            var sEmailIdParameter = sEmailId != null ?
                new ObjectParameter("sEmailId", sEmailId) :
                new ObjectParameter("sEmailId", typeof(string));
    
            var iTotalLoginsParameter = iTotalLogins.HasValue ?
                new ObjectParameter("iTotalLogins", iTotalLogins) :
                new ObjectParameter("iTotalLogins", typeof(int));
    
            var sStartDateParameter = sStartDate != null ?
                new ObjectParameter("sStartDate", sStartDate) :
                new ObjectParameter("sStartDate", typeof(string));
    
            var sEndDateParameter = sEndDate != null ?
                new ObjectParameter("sEndDate", sEndDate) :
                new ObjectParameter("sEndDate", typeof(string));
    
            var sEditionListParameter = sEditionList != null ?
                new ObjectParameter("sEditionList", sEditionList) :
                new ObjectParameter("sEditionList", typeof(string));
    
            var iTotalPriceParameter = iTotalPrice.HasValue ?
                new ObjectParameter("iTotalPrice", iTotalPrice) :
                new ObjectParameter("iTotalPrice", typeof(decimal));
    
            var iCreatorIdParameter = iCreatorId.HasValue ?
                new ObjectParameter("iCreatorId", iCreatorId) :
                new ObjectParameter("iCreatorId", typeof(int));
    
            var sProductKeyParameter = sProductKey != null ?
                new ObjectParameter("sProductKey", sProductKey) :
                new ObjectParameter("sProductKey", typeof(string));
    
            var iNoofImagesParameter = iNoofImages.HasValue ?
                new ObjectParameter("iNoofImages", iNoofImages) :
                new ObjectParameter("iNoofImages", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<InsertResellerLicenseAccount_Result>("InsertResellerLicenseAccount", sLicenseeFnameParameter, sLicenseeLnameParameter, iLicenseTypeIdParameter, iAccountTypeIdParameter, sInstitutionNameParameter, sAddress1Parameter, sAddress2Parameter, sCityParameter, sZipParameter, iStateIdParameter, iCountryIdParameter, sPhoneParameter, sEmailIdParameter, iTotalLoginsParameter, sStartDateParameter, sEndDateParameter, sEditionListParameter, iTotalPriceParameter, iCreatorIdParameter, sProductKeyParameter, iNoofImagesParameter);
        }
    
        public virtual ObjectResult<string> InsertSingleLicenseAccount(string sAccountNumber, string sLicenseeFname, string sLicenseeLname, Nullable<byte> iAccountTypeId, string sInstitutionName, string sAddress1, string sAddress2, string sCity, string sZip, Nullable<int> iStateId, Nullable<int> iCountryId, string sPhone, string sEmailId, Nullable<int> iTotalLogins, string sStartDate, string sEndDate, string sEditionList, Nullable<decimal> iPrice, string sProductKey, string sLoginId, string sPassword, Nullable<byte> iSecurityQuesId, string sSecurityAnswer, Nullable<int> iCreatorId, Nullable<int> iNoofImages)
        {
            var sAccountNumberParameter = sAccountNumber != null ?
                new ObjectParameter("sAccountNumber", sAccountNumber) :
                new ObjectParameter("sAccountNumber", typeof(string));
    
            var sLicenseeFnameParameter = sLicenseeFname != null ?
                new ObjectParameter("sLicenseeFname", sLicenseeFname) :
                new ObjectParameter("sLicenseeFname", typeof(string));
    
            var sLicenseeLnameParameter = sLicenseeLname != null ?
                new ObjectParameter("sLicenseeLname", sLicenseeLname) :
                new ObjectParameter("sLicenseeLname", typeof(string));
    
            var iAccountTypeIdParameter = iAccountTypeId.HasValue ?
                new ObjectParameter("iAccountTypeId", iAccountTypeId) :
                new ObjectParameter("iAccountTypeId", typeof(byte));
    
            var sInstitutionNameParameter = sInstitutionName != null ?
                new ObjectParameter("sInstitutionName", sInstitutionName) :
                new ObjectParameter("sInstitutionName", typeof(string));
    
            var sAddress1Parameter = sAddress1 != null ?
                new ObjectParameter("sAddress1", sAddress1) :
                new ObjectParameter("sAddress1", typeof(string));
    
            var sAddress2Parameter = sAddress2 != null ?
                new ObjectParameter("sAddress2", sAddress2) :
                new ObjectParameter("sAddress2", typeof(string));
    
            var sCityParameter = sCity != null ?
                new ObjectParameter("sCity", sCity) :
                new ObjectParameter("sCity", typeof(string));
    
            var sZipParameter = sZip != null ?
                new ObjectParameter("sZip", sZip) :
                new ObjectParameter("sZip", typeof(string));
    
            var iStateIdParameter = iStateId.HasValue ?
                new ObjectParameter("iStateId", iStateId) :
                new ObjectParameter("iStateId", typeof(int));
    
            var iCountryIdParameter = iCountryId.HasValue ?
                new ObjectParameter("iCountryId", iCountryId) :
                new ObjectParameter("iCountryId", typeof(int));
    
            var sPhoneParameter = sPhone != null ?
                new ObjectParameter("sPhone", sPhone) :
                new ObjectParameter("sPhone", typeof(string));
    
            var sEmailIdParameter = sEmailId != null ?
                new ObjectParameter("sEmailId", sEmailId) :
                new ObjectParameter("sEmailId", typeof(string));
    
            var iTotalLoginsParameter = iTotalLogins.HasValue ?
                new ObjectParameter("iTotalLogins", iTotalLogins) :
                new ObjectParameter("iTotalLogins", typeof(int));
    
            var sStartDateParameter = sStartDate != null ?
                new ObjectParameter("sStartDate", sStartDate) :
                new ObjectParameter("sStartDate", typeof(string));
    
            var sEndDateParameter = sEndDate != null ?
                new ObjectParameter("sEndDate", sEndDate) :
                new ObjectParameter("sEndDate", typeof(string));
    
            var sEditionListParameter = sEditionList != null ?
                new ObjectParameter("sEditionList", sEditionList) :
                new ObjectParameter("sEditionList", typeof(string));
    
            var iPriceParameter = iPrice.HasValue ?
                new ObjectParameter("iPrice", iPrice) :
                new ObjectParameter("iPrice", typeof(decimal));
    
            var sProductKeyParameter = sProductKey != null ?
                new ObjectParameter("sProductKey", sProductKey) :
                new ObjectParameter("sProductKey", typeof(string));
    
            var sLoginIdParameter = sLoginId != null ?
                new ObjectParameter("sLoginId", sLoginId) :
                new ObjectParameter("sLoginId", typeof(string));
    
            var sPasswordParameter = sPassword != null ?
                new ObjectParameter("sPassword", sPassword) :
                new ObjectParameter("sPassword", typeof(string));
    
            var iSecurityQuesIdParameter = iSecurityQuesId.HasValue ?
                new ObjectParameter("iSecurityQuesId", iSecurityQuesId) :
                new ObjectParameter("iSecurityQuesId", typeof(byte));
    
            var sSecurityAnswerParameter = sSecurityAnswer != null ?
                new ObjectParameter("sSecurityAnswer", sSecurityAnswer) :
                new ObjectParameter("sSecurityAnswer", typeof(string));
    
            var iCreatorIdParameter = iCreatorId.HasValue ?
                new ObjectParameter("iCreatorId", iCreatorId) :
                new ObjectParameter("iCreatorId", typeof(int));
    
            var iNoofImagesParameter = iNoofImages.HasValue ?
                new ObjectParameter("iNoofImages", iNoofImages) :
                new ObjectParameter("iNoofImages", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("InsertSingleLicenseAccount", sAccountNumberParameter, sLicenseeFnameParameter, sLicenseeLnameParameter, iAccountTypeIdParameter, sInstitutionNameParameter, sAddress1Parameter, sAddress2Parameter, sCityParameter, sZipParameter, iStateIdParameter, iCountryIdParameter, sPhoneParameter, sEmailIdParameter, iTotalLoginsParameter, sStartDateParameter, sEndDateParameter, sEditionListParameter, iPriceParameter, sProductKeyParameter, sLoginIdParameter, sPasswordParameter, iSecurityQuesIdParameter, sSecurityAnswerParameter, iCreatorIdParameter, iNoofImagesParameter);
        }
    
        public virtual ObjectResult<string> InsertTestLicenseAccount(string sAccountNumber, string sLicenseeFname, string sLicenseeLname, string sLoginId, string sPassword, string sEmailId, Nullable<byte> iAccountTypeId, Nullable<byte> iEditionId, string sAddress, string sCity, string sZip, Nullable<int> iStateId, Nullable<int> iCountryId, string sPhone, string sStartDate, string sEndDate, Nullable<int> iCreatorId, Nullable<int> iNoofImages)
        {
            var sAccountNumberParameter = sAccountNumber != null ?
                new ObjectParameter("sAccountNumber", sAccountNumber) :
                new ObjectParameter("sAccountNumber", typeof(string));
    
            var sLicenseeFnameParameter = sLicenseeFname != null ?
                new ObjectParameter("sLicenseeFname", sLicenseeFname) :
                new ObjectParameter("sLicenseeFname", typeof(string));
    
            var sLicenseeLnameParameter = sLicenseeLname != null ?
                new ObjectParameter("sLicenseeLname", sLicenseeLname) :
                new ObjectParameter("sLicenseeLname", typeof(string));
    
            var sLoginIdParameter = sLoginId != null ?
                new ObjectParameter("sLoginId", sLoginId) :
                new ObjectParameter("sLoginId", typeof(string));
    
            var sPasswordParameter = sPassword != null ?
                new ObjectParameter("sPassword", sPassword) :
                new ObjectParameter("sPassword", typeof(string));
    
            var sEmailIdParameter = sEmailId != null ?
                new ObjectParameter("sEmailId", sEmailId) :
                new ObjectParameter("sEmailId", typeof(string));
    
            var iAccountTypeIdParameter = iAccountTypeId.HasValue ?
                new ObjectParameter("iAccountTypeId", iAccountTypeId) :
                new ObjectParameter("iAccountTypeId", typeof(byte));
    
            var iEditionIdParameter = iEditionId.HasValue ?
                new ObjectParameter("iEditionId", iEditionId) :
                new ObjectParameter("iEditionId", typeof(byte));
    
            var sAddressParameter = sAddress != null ?
                new ObjectParameter("sAddress", sAddress) :
                new ObjectParameter("sAddress", typeof(string));
    
            var sCityParameter = sCity != null ?
                new ObjectParameter("sCity", sCity) :
                new ObjectParameter("sCity", typeof(string));
    
            var sZipParameter = sZip != null ?
                new ObjectParameter("sZip", sZip) :
                new ObjectParameter("sZip", typeof(string));
    
            var iStateIdParameter = iStateId.HasValue ?
                new ObjectParameter("iStateId", iStateId) :
                new ObjectParameter("iStateId", typeof(int));
    
            var iCountryIdParameter = iCountryId.HasValue ?
                new ObjectParameter("iCountryId", iCountryId) :
                new ObjectParameter("iCountryId", typeof(int));
    
            var sPhoneParameter = sPhone != null ?
                new ObjectParameter("sPhone", sPhone) :
                new ObjectParameter("sPhone", typeof(string));
    
            var sStartDateParameter = sStartDate != null ?
                new ObjectParameter("sStartDate", sStartDate) :
                new ObjectParameter("sStartDate", typeof(string));
    
            var sEndDateParameter = sEndDate != null ?
                new ObjectParameter("sEndDate", sEndDate) :
                new ObjectParameter("sEndDate", typeof(string));
    
            var iCreatorIdParameter = iCreatorId.HasValue ?
                new ObjectParameter("iCreatorId", iCreatorId) :
                new ObjectParameter("iCreatorId", typeof(int));
    
            var iNoofImagesParameter = iNoofImages.HasValue ?
                new ObjectParameter("iNoofImages", iNoofImages) :
                new ObjectParameter("iNoofImages", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("InsertTestLicenseAccount", sAccountNumberParameter, sLicenseeFnameParameter, sLicenseeLnameParameter, sLoginIdParameter, sPasswordParameter, sEmailIdParameter, iAccountTypeIdParameter, iEditionIdParameter, sAddressParameter, sCityParameter, sZipParameter, iStateIdParameter, iCountryIdParameter, sPhoneParameter, sStartDateParameter, sEndDateParameter, iCreatorIdParameter, iNoofImagesParameter);
        }
    
        public virtual ObjectResult<InsertUpdateSiteAccount_Result> InsertUpdateSiteAccount(Nullable<int> iSiteId, string sSiteIP, string sTitle, string sInstituteName, string sDepartment, string sAddress1, string sAddress2, string sCity, string zip, string phone, Nullable<int> stateId, Nullable<int> countryId, Nullable<bool> isMaster, Nullable<System.DateTime> creationDate, Nullable<System.DateTime> modifiedDate, Nullable<bool> isActive, Nullable<bool> isModesty, Nullable<int> userId, string sSiteIPTo)
        {
            var iSiteIdParameter = iSiteId.HasValue ?
                new ObjectParameter("iSiteId", iSiteId) :
                new ObjectParameter("iSiteId", typeof(int));
    
            var sSiteIPParameter = sSiteIP != null ?
                new ObjectParameter("sSiteIP", sSiteIP) :
                new ObjectParameter("sSiteIP", typeof(string));
    
            var sTitleParameter = sTitle != null ?
                new ObjectParameter("sTitle", sTitle) :
                new ObjectParameter("sTitle", typeof(string));
    
            var sInstituteNameParameter = sInstituteName != null ?
                new ObjectParameter("sInstituteName", sInstituteName) :
                new ObjectParameter("sInstituteName", typeof(string));
    
            var sDepartmentParameter = sDepartment != null ?
                new ObjectParameter("sDepartment", sDepartment) :
                new ObjectParameter("sDepartment", typeof(string));
    
            var sAddress1Parameter = sAddress1 != null ?
                new ObjectParameter("sAddress1", sAddress1) :
                new ObjectParameter("sAddress1", typeof(string));
    
            var sAddress2Parameter = sAddress2 != null ?
                new ObjectParameter("sAddress2", sAddress2) :
                new ObjectParameter("sAddress2", typeof(string));
    
            var sCityParameter = sCity != null ?
                new ObjectParameter("sCity", sCity) :
                new ObjectParameter("sCity", typeof(string));
    
            var zipParameter = zip != null ?
                new ObjectParameter("Zip", zip) :
                new ObjectParameter("Zip", typeof(string));
    
            var phoneParameter = phone != null ?
                new ObjectParameter("Phone", phone) :
                new ObjectParameter("Phone", typeof(string));
    
            var stateIdParameter = stateId.HasValue ?
                new ObjectParameter("StateId", stateId) :
                new ObjectParameter("StateId", typeof(int));
    
            var countryIdParameter = countryId.HasValue ?
                new ObjectParameter("CountryId", countryId) :
                new ObjectParameter("CountryId", typeof(int));
    
            var isMasterParameter = isMaster.HasValue ?
                new ObjectParameter("IsMaster", isMaster) :
                new ObjectParameter("IsMaster", typeof(bool));
    
            var creationDateParameter = creationDate.HasValue ?
                new ObjectParameter("CreationDate", creationDate) :
                new ObjectParameter("CreationDate", typeof(System.DateTime));
    
            var modifiedDateParameter = modifiedDate.HasValue ?
                new ObjectParameter("ModifiedDate", modifiedDate) :
                new ObjectParameter("ModifiedDate", typeof(System.DateTime));
    
            var isActiveParameter = isActive.HasValue ?
                new ObjectParameter("IsActive", isActive) :
                new ObjectParameter("IsActive", typeof(bool));
    
            var isModestyParameter = isModesty.HasValue ?
                new ObjectParameter("IsModesty", isModesty) :
                new ObjectParameter("IsModesty", typeof(bool));
    
            var userIdParameter = userId.HasValue ?
                new ObjectParameter("UserId", userId) :
                new ObjectParameter("UserId", typeof(int));
    
            var sSiteIPToParameter = sSiteIPTo != null ?
                new ObjectParameter("sSiteIPTo", sSiteIPTo) :
                new ObjectParameter("sSiteIPTo", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<InsertUpdateSiteAccount_Result>("InsertUpdateSiteAccount", iSiteIdParameter, sSiteIPParameter, sTitleParameter, sInstituteNameParameter, sDepartmentParameter, sAddress1Parameter, sAddress2Parameter, sCityParameter, zipParameter, phoneParameter, stateIdParameter, countryIdParameter, isMasterParameter, creationDateParameter, modifiedDateParameter, isActiveParameter, isModestyParameter, userIdParameter, sSiteIPToParameter);
        }
    
        public virtual int InsertUserSessionDetails(string sSessionId, Nullable<int> iUserId, Nullable<int> iLicenseId, Nullable<byte> iEditionId)
        {
            var sSessionIdParameter = sSessionId != null ?
                new ObjectParameter("sSessionId", sSessionId) :
                new ObjectParameter("sSessionId", typeof(string));
    
            var iUserIdParameter = iUserId.HasValue ?
                new ObjectParameter("iUserId", iUserId) :
                new ObjectParameter("iUserId", typeof(int));
    
            var iLicenseIdParameter = iLicenseId.HasValue ?
                new ObjectParameter("iLicenseId", iLicenseId) :
                new ObjectParameter("iLicenseId", typeof(int));
    
            var iEditionIdParameter = iEditionId.HasValue ?
                new ObjectParameter("iEditionId", iEditionId) :
                new ObjectParameter("iEditionId", typeof(byte));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("InsertUserSessionDetails", sSessionIdParameter, iUserIdParameter, iLicenseIdParameter, iEditionIdParameter);
        }
    
        public virtual int NewDeleteCommand(Nullable<byte> original_Id, string original_Title, Nullable<byte> original_Priority, Nullable<bool> original_IsActive)
        {
            var original_IdParameter = original_Id.HasValue ?
                new ObjectParameter("Original_Id", original_Id) :
                new ObjectParameter("Original_Id", typeof(byte));
    
            var original_TitleParameter = original_Title != null ?
                new ObjectParameter("Original_Title", original_Title) :
                new ObjectParameter("Original_Title", typeof(string));
    
            var original_PriorityParameter = original_Priority.HasValue ?
                new ObjectParameter("Original_Priority", original_Priority) :
                new ObjectParameter("Original_Priority", typeof(byte));
    
            var original_IsActiveParameter = original_IsActive.HasValue ?
                new ObjectParameter("Original_IsActive", original_IsActive) :
                new ObjectParameter("Original_IsActive", typeof(bool));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("NewDeleteCommand", original_IdParameter, original_TitleParameter, original_PriorityParameter, original_IsActiveParameter);
        }
    
        public virtual ObjectResult<NewInsertCommand_Result> NewInsertCommand(string title, Nullable<byte> priority, Nullable<bool> isActive)
        {
            var titleParameter = title != null ?
                new ObjectParameter("Title", title) :
                new ObjectParameter("Title", typeof(string));
    
            var priorityParameter = priority.HasValue ?
                new ObjectParameter("Priority", priority) :
                new ObjectParameter("Priority", typeof(byte));
    
            var isActiveParameter = isActive.HasValue ?
                new ObjectParameter("IsActive", isActive) :
                new ObjectParameter("IsActive", typeof(bool));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<NewInsertCommand_Result>("NewInsertCommand", titleParameter, priorityParameter, isActiveParameter);
        }
    
        public virtual ObjectResult<NewUpdateCommand_Result> NewUpdateCommand(string title, Nullable<byte> priority, Nullable<bool> isActive, Nullable<byte> original_Id, string original_Title, Nullable<byte> original_Priority, Nullable<bool> original_IsActive, Nullable<byte> id)
        {
            var titleParameter = title != null ?
                new ObjectParameter("Title", title) :
                new ObjectParameter("Title", typeof(string));
    
            var priorityParameter = priority.HasValue ?
                new ObjectParameter("Priority", priority) :
                new ObjectParameter("Priority", typeof(byte));
    
            var isActiveParameter = isActive.HasValue ?
                new ObjectParameter("IsActive", isActive) :
                new ObjectParameter("IsActive", typeof(bool));
    
            var original_IdParameter = original_Id.HasValue ?
                new ObjectParameter("Original_Id", original_Id) :
                new ObjectParameter("Original_Id", typeof(byte));
    
            var original_TitleParameter = original_Title != null ?
                new ObjectParameter("Original_Title", original_Title) :
                new ObjectParameter("Original_Title", typeof(string));
    
            var original_PriorityParameter = original_Priority.HasValue ?
                new ObjectParameter("Original_Priority", original_Priority) :
                new ObjectParameter("Original_Priority", typeof(byte));
    
            var original_IsActiveParameter = original_IsActive.HasValue ?
                new ObjectParameter("Original_IsActive", original_IsActive) :
                new ObjectParameter("Original_IsActive", typeof(bool));
    
            var idParameter = id.HasValue ?
                new ObjectParameter("Id", id) :
                new ObjectParameter("Id", typeof(byte));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<NewUpdateCommand_Result>("NewUpdateCommand", titleParameter, priorityParameter, isActiveParameter, original_IdParameter, original_TitleParameter, original_PriorityParameter, original_IsActiveParameter, idParameter);
        }
    
        public virtual int sp_alterdiagram(string diagramname, Nullable<int> owner_id, Nullable<int> version, byte[] definition)
        {
            var diagramnameParameter = diagramname != null ?
                new ObjectParameter("diagramname", diagramname) :
                new ObjectParameter("diagramname", typeof(string));
    
            var owner_idParameter = owner_id.HasValue ?
                new ObjectParameter("owner_id", owner_id) :
                new ObjectParameter("owner_id", typeof(int));
    
            var versionParameter = version.HasValue ?
                new ObjectParameter("version", version) :
                new ObjectParameter("version", typeof(int));
    
            var definitionParameter = definition != null ?
                new ObjectParameter("definition", definition) :
                new ObjectParameter("definition", typeof(byte[]));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("sp_alterdiagram", diagramnameParameter, owner_idParameter, versionParameter, definitionParameter);
        }
    
        public virtual int sp_creatediagram(string diagramname, Nullable<int> owner_id, Nullable<int> version, byte[] definition)
        {
            var diagramnameParameter = diagramname != null ?
                new ObjectParameter("diagramname", diagramname) :
                new ObjectParameter("diagramname", typeof(string));
    
            var owner_idParameter = owner_id.HasValue ?
                new ObjectParameter("owner_id", owner_id) :
                new ObjectParameter("owner_id", typeof(int));
    
            var versionParameter = version.HasValue ?
                new ObjectParameter("version", version) :
                new ObjectParameter("version", typeof(int));
    
            var definitionParameter = definition != null ?
                new ObjectParameter("definition", definition) :
                new ObjectParameter("definition", typeof(byte[]));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("sp_creatediagram", diagramnameParameter, owner_idParameter, versionParameter, definitionParameter);
        }
    
        public virtual int sp_dropdiagram(string diagramname, Nullable<int> owner_id)
        {
            var diagramnameParameter = diagramname != null ?
                new ObjectParameter("diagramname", diagramname) :
                new ObjectParameter("diagramname", typeof(string));
    
            var owner_idParameter = owner_id.HasValue ?
                new ObjectParameter("owner_id", owner_id) :
                new ObjectParameter("owner_id", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("sp_dropdiagram", diagramnameParameter, owner_idParameter);
        }
    
        public virtual ObjectResult<sp_helpdiagramdefinition_Result> sp_helpdiagramdefinition(string diagramname, Nullable<int> owner_id)
        {
            var diagramnameParameter = diagramname != null ?
                new ObjectParameter("diagramname", diagramname) :
                new ObjectParameter("diagramname", typeof(string));
    
            var owner_idParameter = owner_id.HasValue ?
                new ObjectParameter("owner_id", owner_id) :
                new ObjectParameter("owner_id", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<sp_helpdiagramdefinition_Result>("sp_helpdiagramdefinition", diagramnameParameter, owner_idParameter);
        }
    
        public virtual ObjectResult<sp_helpdiagrams_Result> sp_helpdiagrams(string diagramname, Nullable<int> owner_id)
        {
            var diagramnameParameter = diagramname != null ?
                new ObjectParameter("diagramname", diagramname) :
                new ObjectParameter("diagramname", typeof(string));
    
            var owner_idParameter = owner_id.HasValue ?
                new ObjectParameter("owner_id", owner_id) :
                new ObjectParameter("owner_id", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<sp_helpdiagrams_Result>("sp_helpdiagrams", diagramnameParameter, owner_idParameter);
        }
    
        public virtual int sp_renamediagram(string diagramname, Nullable<int> owner_id, string new_diagramname)
        {
            var diagramnameParameter = diagramname != null ?
                new ObjectParameter("diagramname", diagramname) :
                new ObjectParameter("diagramname", typeof(string));
    
            var owner_idParameter = owner_id.HasValue ?
                new ObjectParameter("owner_id", owner_id) :
                new ObjectParameter("owner_id", typeof(int));
    
            var new_diagramnameParameter = new_diagramname != null ?
                new ObjectParameter("new_diagramname", new_diagramname) :
                new ObjectParameter("new_diagramname", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("sp_renamediagram", diagramnameParameter, owner_idParameter, new_diagramnameParameter);
        }
    
        public virtual int sp_upgraddiagrams()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("sp_upgraddiagrams");
        }
    
        public virtual int StartResellerSubscription(Nullable<int> iLicenseId)
        {
            var iLicenseIdParameter = iLicenseId.HasValue ?
                new ObjectParameter("iLicenseId", iLicenseId) :
                new ObjectParameter("iLicenseId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("StartResellerSubscription", iLicenseIdParameter);
        }
    
        public virtual int UpdateAiaUserPassword(Nullable<int> id, string newPassword, ObjectParameter status)
        {
            var idParameter = id.HasValue ?
                new ObjectParameter("Id", id) :
                new ObjectParameter("Id", typeof(int));
    
            var newPasswordParameter = newPassword != null ?
                new ObjectParameter("NewPassword", newPassword) :
                new ObjectParameter("NewPassword", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("UpdateAiaUserPassword", idParameter, newPasswordParameter, status);
        }
    
        public virtual ObjectResult<string> UpdateDiscount(Nullable<int> iDiscountId, Nullable<decimal> dPercentage, string sStartDate, string sEndDate, Nullable<byte> iActive, string sDiscountCode)
        {
            var iDiscountIdParameter = iDiscountId.HasValue ?
                new ObjectParameter("iDiscountId", iDiscountId) :
                new ObjectParameter("iDiscountId", typeof(int));
    
            var dPercentageParameter = dPercentage.HasValue ?
                new ObjectParameter("dPercentage", dPercentage) :
                new ObjectParameter("dPercentage", typeof(decimal));
    
            var sStartDateParameter = sStartDate != null ?
                new ObjectParameter("sStartDate", sStartDate) :
                new ObjectParameter("sStartDate", typeof(string));
    
            var sEndDateParameter = sEndDate != null ?
                new ObjectParameter("sEndDate", sEndDate) :
                new ObjectParameter("sEndDate", typeof(string));
    
            var iActiveParameter = iActive.HasValue ?
                new ObjectParameter("iActive", iActive) :
                new ObjectParameter("iActive", typeof(byte));
    
            var sDiscountCodeParameter = sDiscountCode != null ?
                new ObjectParameter("sDiscountCode", sDiscountCode) :
                new ObjectParameter("sDiscountCode", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("UpdateDiscount", iDiscountIdParameter, dPercentageParameter, sStartDateParameter, sEndDateParameter, iActiveParameter, sDiscountCodeParameter);
        }
    
        public virtual int UpdateDiscountStatus()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("UpdateDiscountStatus");
        }
    
        public virtual int UpdateIncorrectLoginAttempts(Nullable<int> iUserId)
        {
            var iUserIdParameter = iUserId.HasValue ?
                new ObjectParameter("iUserId", iUserId) :
                new ObjectParameter("iUserId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("UpdateIncorrectLoginAttempts", iUserIdParameter);
        }
    
        public virtual ObjectResult<string> UpdateLicenseAccount(Nullable<int> iLicenseId, string sLicenseeFname, string sLicenseeLname, Nullable<byte> iLicenseTypeId, Nullable<byte> iAccountTypeId, string sInstitutionName, string sAddress1, string sAddress2, string sCity, string sZip, Nullable<int> iStateId, Nullable<int> iCountryId, string sPhone, string sEmailId, Nullable<byte> iIsActive, Nullable<int> iTotalLogins, Nullable<byte> iIsRennew, string sStartDate, string sEndDate, string sRenewDate, string sMasterIP, string sEditionList, Nullable<decimal> iPrice, string sProductKey, string sSiteIPTo, string sSiteMasterIPTo, Nullable<int> iNoofImages)
        {
            var iLicenseIdParameter = iLicenseId.HasValue ?
                new ObjectParameter("iLicenseId", iLicenseId) :
                new ObjectParameter("iLicenseId", typeof(int));
    
            var sLicenseeFnameParameter = sLicenseeFname != null ?
                new ObjectParameter("sLicenseeFname", sLicenseeFname) :
                new ObjectParameter("sLicenseeFname", typeof(string));
    
            var sLicenseeLnameParameter = sLicenseeLname != null ?
                new ObjectParameter("sLicenseeLname", sLicenseeLname) :
                new ObjectParameter("sLicenseeLname", typeof(string));
    
            var iLicenseTypeIdParameter = iLicenseTypeId.HasValue ?
                new ObjectParameter("iLicenseTypeId", iLicenseTypeId) :
                new ObjectParameter("iLicenseTypeId", typeof(byte));
    
            var iAccountTypeIdParameter = iAccountTypeId.HasValue ?
                new ObjectParameter("iAccountTypeId", iAccountTypeId) :
                new ObjectParameter("iAccountTypeId", typeof(byte));
    
            var sInstitutionNameParameter = sInstitutionName != null ?
                new ObjectParameter("sInstitutionName", sInstitutionName) :
                new ObjectParameter("sInstitutionName", typeof(string));
    
            var sAddress1Parameter = sAddress1 != null ?
                new ObjectParameter("sAddress1", sAddress1) :
                new ObjectParameter("sAddress1", typeof(string));
    
            var sAddress2Parameter = sAddress2 != null ?
                new ObjectParameter("sAddress2", sAddress2) :
                new ObjectParameter("sAddress2", typeof(string));
    
            var sCityParameter = sCity != null ?
                new ObjectParameter("sCity", sCity) :
                new ObjectParameter("sCity", typeof(string));
    
            var sZipParameter = sZip != null ?
                new ObjectParameter("sZip", sZip) :
                new ObjectParameter("sZip", typeof(string));
    
            var iStateIdParameter = iStateId.HasValue ?
                new ObjectParameter("iStateId", iStateId) :
                new ObjectParameter("iStateId", typeof(int));
    
            var iCountryIdParameter = iCountryId.HasValue ?
                new ObjectParameter("iCountryId", iCountryId) :
                new ObjectParameter("iCountryId", typeof(int));
    
            var sPhoneParameter = sPhone != null ?
                new ObjectParameter("sPhone", sPhone) :
                new ObjectParameter("sPhone", typeof(string));
    
            var sEmailIdParameter = sEmailId != null ?
                new ObjectParameter("sEmailId", sEmailId) :
                new ObjectParameter("sEmailId", typeof(string));
    
            var iIsActiveParameter = iIsActive.HasValue ?
                new ObjectParameter("iIsActive", iIsActive) :
                new ObjectParameter("iIsActive", typeof(byte));
    
            var iTotalLoginsParameter = iTotalLogins.HasValue ?
                new ObjectParameter("iTotalLogins", iTotalLogins) :
                new ObjectParameter("iTotalLogins", typeof(int));
    
            var iIsRennewParameter = iIsRennew.HasValue ?
                new ObjectParameter("iIsRennew", iIsRennew) :
                new ObjectParameter("iIsRennew", typeof(byte));
    
            var sStartDateParameter = sStartDate != null ?
                new ObjectParameter("sStartDate", sStartDate) :
                new ObjectParameter("sStartDate", typeof(string));
    
            var sEndDateParameter = sEndDate != null ?
                new ObjectParameter("sEndDate", sEndDate) :
                new ObjectParameter("sEndDate", typeof(string));
    
            var sRenewDateParameter = sRenewDate != null ?
                new ObjectParameter("sRenewDate", sRenewDate) :
                new ObjectParameter("sRenewDate", typeof(string));
    
            var sMasterIPParameter = sMasterIP != null ?
                new ObjectParameter("sMasterIP", sMasterIP) :
                new ObjectParameter("sMasterIP", typeof(string));
    
            var sEditionListParameter = sEditionList != null ?
                new ObjectParameter("sEditionList", sEditionList) :
                new ObjectParameter("sEditionList", typeof(string));
    
            var iPriceParameter = iPrice.HasValue ?
                new ObjectParameter("iPrice", iPrice) :
                new ObjectParameter("iPrice", typeof(decimal));
    
            var sProductKeyParameter = sProductKey != null ?
                new ObjectParameter("sProductKey", sProductKey) :
                new ObjectParameter("sProductKey", typeof(string));
    
            var sSiteIPToParameter = sSiteIPTo != null ?
                new ObjectParameter("sSiteIPTo", sSiteIPTo) :
                new ObjectParameter("sSiteIPTo", typeof(string));
    
            var sSiteMasterIPToParameter = sSiteMasterIPTo != null ?
                new ObjectParameter("sSiteMasterIPTo", sSiteMasterIPTo) :
                new ObjectParameter("sSiteMasterIPTo", typeof(string));
    
            var iNoofImagesParameter = iNoofImages.HasValue ?
                new ObjectParameter("iNoofImages", iNoofImages) :
                new ObjectParameter("iNoofImages", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("UpdateLicenseAccount", iLicenseIdParameter, sLicenseeFnameParameter, sLicenseeLnameParameter, iLicenseTypeIdParameter, iAccountTypeIdParameter, sInstitutionNameParameter, sAddress1Parameter, sAddress2Parameter, sCityParameter, sZipParameter, iStateIdParameter, iCountryIdParameter, sPhoneParameter, sEmailIdParameter, iIsActiveParameter, iTotalLoginsParameter, iIsRennewParameter, sStartDateParameter, sEndDateParameter, sRenewDateParameter, sMasterIPParameter, sEditionListParameter, iPriceParameter, sProductKeyParameter, sSiteIPToParameter, sSiteMasterIPToParameter, iNoofImagesParameter);
        }
    
        public virtual ObjectResult<string> UpdateLicenseModule(Nullable<int> iLicenseId, string sModuleTitle, Nullable<int> iStatus)
        {
            var iLicenseIdParameter = iLicenseId.HasValue ?
                new ObjectParameter("iLicenseId", iLicenseId) :
                new ObjectParameter("iLicenseId", typeof(int));
    
            var sModuleTitleParameter = sModuleTitle != null ?
                new ObjectParameter("sModuleTitle", sModuleTitle) :
                new ObjectParameter("sModuleTitle", typeof(string));
    
            var iStatusParameter = iStatus.HasValue ?
                new ObjectParameter("iStatus", iStatus) :
                new ObjectParameter("iStatus", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("UpdateLicenseModule", iLicenseIdParameter, sModuleTitleParameter, iStatusParameter);
        }
    
        public virtual int UpdateLicenseStatus()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("UpdateLicenseStatus");
        }
    
        public virtual int UpdateLicenseTermAcceptedStatus(string sAccountNumber)
        {
            var sAccountNumberParameter = sAccountNumber != null ?
                new ObjectParameter("sAccountNumber", sAccountNumber) :
                new ObjectParameter("sAccountNumber", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("UpdateLicenseTermAcceptedStatus", sAccountNumberParameter);
        }
    
        public virtual int UpdateUserPassword(string sLoginId, string sEmailId, string sNewPassword)
        {
            var sLoginIdParameter = sLoginId != null ?
                new ObjectParameter("sLoginId", sLoginId) :
                new ObjectParameter("sLoginId", typeof(string));
    
            var sEmailIdParameter = sEmailId != null ?
                new ObjectParameter("sEmailId", sEmailId) :
                new ObjectParameter("sEmailId", typeof(string));
    
            var sNewPasswordParameter = sNewPassword != null ?
                new ObjectParameter("sNewPassword", sNewPassword) :
                new ObjectParameter("sNewPassword", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("UpdateUserPassword", sLoginIdParameter, sEmailIdParameter, sNewPasswordParameter);
        }
    
        public virtual int UpdateUserProfile(Nullable<int> id, string firstName, string lastName, string emailId, ObjectParameter status)
        {
            var idParameter = id.HasValue ?
                new ObjectParameter("Id", id) :
                new ObjectParameter("Id", typeof(int));
    
            var firstNameParameter = firstName != null ?
                new ObjectParameter("FirstName", firstName) :
                new ObjectParameter("FirstName", typeof(string));
    
            var lastNameParameter = lastName != null ?
                new ObjectParameter("LastName", lastName) :
                new ObjectParameter("LastName", typeof(string));
    
            var emailIdParameter = emailId != null ?
                new ObjectParameter("EmailId", emailId) :
                new ObjectParameter("EmailId", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("UpdateUserProfile", idParameter, firstNameParameter, lastNameParameter, emailIdParameter, status);
        }
    
        public virtual int usp_CheckAccountNoExists(string accountNo, ObjectParameter status)
        {
            var accountNoParameter = accountNo != null ?
                new ObjectParameter("AccountNo", accountNo) :
                new ObjectParameter("AccountNo", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("usp_CheckAccountNoExists", accountNoParameter, status);
        }
    
        public virtual ObjectResult<usp_DB_TblRowCOUNT_Result> usp_DB_TblRowCOUNT()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_DB_TblRowCOUNT_Result>("usp_DB_TblRowCOUNT");
        }
    
        public virtual int usp_DeleteLicenseUserGroup(Nullable<int> userGroupId, ObjectParameter status)
        {
            var userGroupIdParameter = userGroupId.HasValue ?
                new ObjectParameter("UserGroupId", userGroupId) :
                new ObjectParameter("UserGroupId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("usp_DeleteLicenseUserGroup", userGroupIdParameter, status);
        }
    
        public virtual int usp_DeleteSiteAccount(Nullable<int> iSiteId, Nullable<int> licenseId, Nullable<int> userId, ObjectParameter status)
        {
            var iSiteIdParameter = iSiteId.HasValue ?
                new ObjectParameter("iSiteId", iSiteId) :
                new ObjectParameter("iSiteId", typeof(int));
    
            var licenseIdParameter = licenseId.HasValue ?
                new ObjectParameter("LicenseId", licenseId) :
                new ObjectParameter("LicenseId", typeof(int));
    
            var userIdParameter = userId.HasValue ?
                new ObjectParameter("UserId", userId) :
                new ObjectParameter("UserId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("usp_DeleteSiteAccount", iSiteIdParameter, licenseIdParameter, userIdParameter, status);
        }
    
        public virtual int usp_DeleteSubscriptionPlan(Nullable<byte> id, ObjectParameter status)
        {
            var idParameter = id.HasValue ?
                new ObjectParameter("Id", id) :
                new ObjectParameter("Id", typeof(byte));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("usp_DeleteSubscriptionPlan", idParameter, status);
        }
    
        public virtual ObjectResult<usp_GetAccountNumber_Result> usp_GetAccountNumber(Nullable<int> licenseType)
        {
            var licenseTypeParameter = licenseType.HasValue ?
                new ObjectParameter("LicenseType", licenseType) :
                new ObjectParameter("LicenseType", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_GetAccountNumber_Result>("usp_GetAccountNumber", licenseTypeParameter);
        }
    
        public virtual ObjectResult<usp_GetAccountTypeList_Result> usp_GetAccountTypeList(Nullable<int> id)
        {
            var idParameter = id.HasValue ?
                new ObjectParameter("Id", id) :
                new ObjectParameter("Id", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_GetAccountTypeList_Result>("usp_GetAccountTypeList", idParameter);
        }
    
        public virtual ObjectResult<usp_GetEditions_Result> usp_GetEditions()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_GetEditions_Result>("usp_GetEditions");
        }
    
        public virtual ObjectResult<usp_GetLicenseById_Result> usp_GetLicenseById(Nullable<int> id)
        {
            var idParameter = id.HasValue ?
                new ObjectParameter("Id", id) :
                new ObjectParameter("Id", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_GetLicenseById_Result>("usp_GetLicenseById", idParameter);
        }
    
        public virtual ObjectResult<usp_GetLicenseModestySettings_Result> usp_GetLicenseModestySettings(Nullable<int> iLicenseId, Nullable<int> iBuildingLevelId)
        {
            var iLicenseIdParameter = iLicenseId.HasValue ?
                new ObjectParameter("iLicenseId", iLicenseId) :
                new ObjectParameter("iLicenseId", typeof(int));
    
            var iBuildingLevelIdParameter = iBuildingLevelId.HasValue ?
                new ObjectParameter("iBuildingLevelId", iBuildingLevelId) :
                new ObjectParameter("iBuildingLevelId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_GetLicenseModestySettings_Result>("usp_GetLicenseModestySettings", iLicenseIdParameter, iBuildingLevelIdParameter);
        }
    
        public virtual ObjectResult<usp_GetLicenses_Result> usp_GetLicenses(string sStartDate, string sEndDate, string sAccoutNumber, string sLicenseeFirstName, string sLicenseeLastName, Nullable<byte> iLicenseTypeId, string sInstituteName, string sEmail, Nullable<int> iStateId, Nullable<int> iCountryId, Nullable<bool> bisActive, Nullable<int> pageNo, Nullable<int> pageLength, ObjectParameter recordCount)
        {
            var sStartDateParameter = sStartDate != null ?
                new ObjectParameter("sStartDate", sStartDate) :
                new ObjectParameter("sStartDate", typeof(string));
    
            var sEndDateParameter = sEndDate != null ?
                new ObjectParameter("sEndDate", sEndDate) :
                new ObjectParameter("sEndDate", typeof(string));
    
            var sAccoutNumberParameter = sAccoutNumber != null ?
                new ObjectParameter("sAccoutNumber", sAccoutNumber) :
                new ObjectParameter("sAccoutNumber", typeof(string));
    
            var sLicenseeFirstNameParameter = sLicenseeFirstName != null ?
                new ObjectParameter("sLicenseeFirstName", sLicenseeFirstName) :
                new ObjectParameter("sLicenseeFirstName", typeof(string));
    
            var sLicenseeLastNameParameter = sLicenseeLastName != null ?
                new ObjectParameter("sLicenseeLastName", sLicenseeLastName) :
                new ObjectParameter("sLicenseeLastName", typeof(string));
    
            var iLicenseTypeIdParameter = iLicenseTypeId.HasValue ?
                new ObjectParameter("iLicenseTypeId", iLicenseTypeId) :
                new ObjectParameter("iLicenseTypeId", typeof(byte));
    
            var sInstituteNameParameter = sInstituteName != null ?
                new ObjectParameter("sInstituteName", sInstituteName) :
                new ObjectParameter("sInstituteName", typeof(string));
    
            var sEmailParameter = sEmail != null ?
                new ObjectParameter("sEmail", sEmail) :
                new ObjectParameter("sEmail", typeof(string));
    
            var iStateIdParameter = iStateId.HasValue ?
                new ObjectParameter("iStateId", iStateId) :
                new ObjectParameter("iStateId", typeof(int));
    
            var iCountryIdParameter = iCountryId.HasValue ?
                new ObjectParameter("iCountryId", iCountryId) :
                new ObjectParameter("iCountryId", typeof(int));
    
            var bisActiveParameter = bisActive.HasValue ?
                new ObjectParameter("bisActive", bisActive) :
                new ObjectParameter("bisActive", typeof(bool));
    
            var pageNoParameter = pageNo.HasValue ?
                new ObjectParameter("pageNo", pageNo) :
                new ObjectParameter("pageNo", typeof(int));
    
            var pageLengthParameter = pageLength.HasValue ?
                new ObjectParameter("pageLength", pageLength) :
                new ObjectParameter("pageLength", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_GetLicenses_Result>("usp_GetLicenses", sStartDateParameter, sEndDateParameter, sAccoutNumberParameter, sLicenseeFirstNameParameter, sLicenseeLastNameParameter, iLicenseTypeIdParameter, sInstituteNameParameter, sEmailParameter, iStateIdParameter, iCountryIdParameter, bisActiveParameter, pageNoParameter, pageLengthParameter, recordCount);
        }
    
        public virtual ObjectResult<usp_GetlicensesList_Result> usp_GetlicensesList(string sStartDate, string sEndDate, string sAccoutNumber, string sLicenseeFirstName, string sLicenseeLastName, Nullable<byte> iLicenseTypeId, string sInstituteName, string sEmail, Nullable<int> iStateId, Nullable<int> iCountryId, Nullable<bool> bisActive, Nullable<int> pageNo, Nullable<int> pageLength, ObjectParameter recordCount)
        {
            var sStartDateParameter = sStartDate != null ?
                new ObjectParameter("sStartDate", sStartDate) :
                new ObjectParameter("sStartDate", typeof(string));
    
            var sEndDateParameter = sEndDate != null ?
                new ObjectParameter("sEndDate", sEndDate) :
                new ObjectParameter("sEndDate", typeof(string));
    
            var sAccoutNumberParameter = sAccoutNumber != null ?
                new ObjectParameter("sAccoutNumber", sAccoutNumber) :
                new ObjectParameter("sAccoutNumber", typeof(string));
    
            var sLicenseeFirstNameParameter = sLicenseeFirstName != null ?
                new ObjectParameter("sLicenseeFirstName", sLicenseeFirstName) :
                new ObjectParameter("sLicenseeFirstName", typeof(string));
    
            var sLicenseeLastNameParameter = sLicenseeLastName != null ?
                new ObjectParameter("sLicenseeLastName", sLicenseeLastName) :
                new ObjectParameter("sLicenseeLastName", typeof(string));
    
            var iLicenseTypeIdParameter = iLicenseTypeId.HasValue ?
                new ObjectParameter("iLicenseTypeId", iLicenseTypeId) :
                new ObjectParameter("iLicenseTypeId", typeof(byte));
    
            var sInstituteNameParameter = sInstituteName != null ?
                new ObjectParameter("sInstituteName", sInstituteName) :
                new ObjectParameter("sInstituteName", typeof(string));
    
            var sEmailParameter = sEmail != null ?
                new ObjectParameter("sEmail", sEmail) :
                new ObjectParameter("sEmail", typeof(string));
    
            var iStateIdParameter = iStateId.HasValue ?
                new ObjectParameter("iStateId", iStateId) :
                new ObjectParameter("iStateId", typeof(int));
    
            var iCountryIdParameter = iCountryId.HasValue ?
                new ObjectParameter("iCountryId", iCountryId) :
                new ObjectParameter("iCountryId", typeof(int));
    
            var bisActiveParameter = bisActive.HasValue ?
                new ObjectParameter("bisActive", bisActive) :
                new ObjectParameter("bisActive", typeof(bool));
    
            var pageNoParameter = pageNo.HasValue ?
                new ObjectParameter("pageNo", pageNo) :
                new ObjectParameter("pageNo", typeof(int));
    
            var pageLengthParameter = pageLength.HasValue ?
                new ObjectParameter("pageLength", pageLength) :
                new ObjectParameter("pageLength", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_GetlicensesList_Result>("usp_GetlicensesList", sStartDateParameter, sEndDateParameter, sAccoutNumberParameter, sLicenseeFirstNameParameter, sLicenseeLastNameParameter, iLicenseTypeIdParameter, sInstituteNameParameter, sEmailParameter, iStateIdParameter, iCountryIdParameter, bisActiveParameter, pageNoParameter, pageLengthParameter, recordCount);
        }
    
        public virtual ObjectResult<usp_GetLicenseTypes_Result> usp_GetLicenseTypes()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_GetLicenseTypes_Result>("usp_GetLicenseTypes");
        }
    
        public virtual ObjectResult<usp_GetLicenseUserGroups_Result> usp_GetLicenseUserGroups(Nullable<int> licenseId, Nullable<int> pageNo, Nullable<int> pageLength, ObjectParameter recordCount)
        {
            var licenseIdParameter = licenseId.HasValue ?
                new ObjectParameter("LicenseId", licenseId) :
                new ObjectParameter("LicenseId", typeof(int));
    
            var pageNoParameter = pageNo.HasValue ?
                new ObjectParameter("pageNo", pageNo) :
                new ObjectParameter("pageNo", typeof(int));
    
            var pageLengthParameter = pageLength.HasValue ?
                new ObjectParameter("pageLength", pageLength) :
                new ObjectParameter("pageLength", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_GetLicenseUserGroups_Result>("usp_GetLicenseUserGroups", licenseIdParameter, pageNoParameter, pageLengthParameter, recordCount);
        }
    
        public virtual ObjectResult<usp_GetManageRights_Result> usp_GetManageRights(Nullable<int> userId, string roleName)
        {
            var userIdParameter = userId.HasValue ?
                new ObjectParameter("UserId", userId) :
                new ObjectParameter("UserId", typeof(int));
    
            var roleNameParameter = roleName != null ?
                new ObjectParameter("RoleName", roleName) :
                new ObjectParameter("RoleName", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_GetManageRights_Result>("usp_GetManageRights", userIdParameter, roleNameParameter);
        }
    
        public virtual ObjectResult<usp_GetProductEditionByLicense_Result> usp_GetProductEditionByLicense(Nullable<int> iLicenseId)
        {
            var iLicenseIdParameter = iLicenseId.HasValue ?
                new ObjectParameter("iLicenseId", iLicenseId) :
                new ObjectParameter("iLicenseId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_GetProductEditionByLicense_Result>("usp_GetProductEditionByLicense", iLicenseIdParameter);
        }
    
        public virtual ObjectResult<usp_GetSiteAccountEditions_Result> usp_GetSiteAccountEditions(Nullable<int> siteId, Nullable<int> licenseId)
        {
            var siteIdParameter = siteId.HasValue ?
                new ObjectParameter("SiteId", siteId) :
                new ObjectParameter("SiteId", typeof(int));
    
            var licenseIdParameter = licenseId.HasValue ?
                new ObjectParameter("LicenseId", licenseId) :
                new ObjectParameter("LicenseId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_GetSiteAccountEditions_Result>("usp_GetSiteAccountEditions", siteIdParameter, licenseIdParameter);
        }
    
        public virtual ObjectResult<usp_GetSiteById_Result> usp_GetSiteById(Nullable<int> siteId)
        {
            var siteIdParameter = siteId.HasValue ?
                new ObjectParameter("SiteId", siteId) :
                new ObjectParameter("SiteId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_GetSiteById_Result>("usp_GetSiteById", siteIdParameter);
        }
    
        public virtual ObjectResult<usp_GetSubscriptionPlans_Result> usp_GetSubscriptionPlans(Nullable<byte> iEditionId, Nullable<int> pageNo, Nullable<int> pageLength, ObjectParameter recordCount)
        {
            var iEditionIdParameter = iEditionId.HasValue ?
                new ObjectParameter("iEditionId", iEditionId) :
                new ObjectParameter("iEditionId", typeof(byte));
    
            var pageNoParameter = pageNo.HasValue ?
                new ObjectParameter("pageNo", pageNo) :
                new ObjectParameter("pageNo", typeof(int));
    
            var pageLengthParameter = pageLength.HasValue ?
                new ObjectParameter("pageLength", pageLength) :
                new ObjectParameter("pageLength", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_GetSubscriptionPlans_Result>("usp_GetSubscriptionPlans", iEditionIdParameter, pageNoParameter, pageLengthParameter, recordCount);
        }
    
        public virtual ObjectResult<usp_GetUserType_Result> usp_GetUserType(Nullable<int> id)
        {
            var idParameter = id.HasValue ?
                new ObjectParameter("id", id) :
                new ObjectParameter("id", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_GetUserType_Result>("usp_GetUserType", idParameter);
        }
    
        public virtual int usp_InsertDeleteUserManageRights(string roleName, Nullable<int> activityId, Nullable<int> userId, string requestType, ObjectParameter status)
        {
            var roleNameParameter = roleName != null ?
                new ObjectParameter("RoleName", roleName) :
                new ObjectParameter("RoleName", typeof(string));
    
            var activityIdParameter = activityId.HasValue ?
                new ObjectParameter("ActivityId", activityId) :
                new ObjectParameter("ActivityId", typeof(int));
    
            var userIdParameter = userId.HasValue ?
                new ObjectParameter("UserId", userId) :
                new ObjectParameter("UserId", typeof(int));
    
            var requestTypeParameter = requestType != null ?
                new ObjectParameter("RequestType", requestType) :
                new ObjectParameter("RequestType", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("usp_InsertDeleteUserManageRights", roleNameParameter, activityIdParameter, userIdParameter, requestTypeParameter, status);
        }
    
        public virtual int usp_InsertSubscriptionPlan(Nullable<byte> id, string title, Nullable<decimal> price, Nullable<byte> duration, Nullable<byte> editionId, Nullable<bool> isActive, ObjectParameter status)
        {
            var idParameter = id.HasValue ?
                new ObjectParameter("Id", id) :
                new ObjectParameter("Id", typeof(byte));
    
            var titleParameter = title != null ?
                new ObjectParameter("Title", title) :
                new ObjectParameter("Title", typeof(string));
    
            var priceParameter = price.HasValue ?
                new ObjectParameter("Price", price) :
                new ObjectParameter("Price", typeof(decimal));
    
            var durationParameter = duration.HasValue ?
                new ObjectParameter("Duration", duration) :
                new ObjectParameter("Duration", typeof(byte));
    
            var editionIdParameter = editionId.HasValue ?
                new ObjectParameter("EditionId", editionId) :
                new ObjectParameter("EditionId", typeof(byte));
    
            var isActiveParameter = isActive.HasValue ?
                new ObjectParameter("IsActive", isActive) :
                new ObjectParameter("IsActive", typeof(bool));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("usp_InsertSubscriptionPlan", idParameter, titleParameter, priceParameter, durationParameter, editionIdParameter, isActiveParameter, status);
        }
    
        public virtual int usp_InsertUpdateLicenseUserGroup(Nullable<int> id, Nullable<int> licenseId, string title, Nullable<System.DateTime> creationDate, Nullable<System.DateTime> modifiedDate, Nullable<bool> isActive, ObjectParameter status)
        {
            var idParameter = id.HasValue ?
                new ObjectParameter("Id", id) :
                new ObjectParameter("Id", typeof(int));
    
            var licenseIdParameter = licenseId.HasValue ?
                new ObjectParameter("LicenseId", licenseId) :
                new ObjectParameter("LicenseId", typeof(int));
    
            var titleParameter = title != null ?
                new ObjectParameter("Title", title) :
                new ObjectParameter("Title", typeof(string));
    
            var creationDateParameter = creationDate.HasValue ?
                new ObjectParameter("CreationDate", creationDate) :
                new ObjectParameter("CreationDate", typeof(System.DateTime));
    
            var modifiedDateParameter = modifiedDate.HasValue ?
                new ObjectParameter("ModifiedDate", modifiedDate) :
                new ObjectParameter("ModifiedDate", typeof(System.DateTime));
    
            var isActiveParameter = isActive.HasValue ?
                new ObjectParameter("IsActive", isActive) :
                new ObjectParameter("IsActive", typeof(bool));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("usp_InsertUpdateLicenseUserGroup", idParameter, licenseIdParameter, titleParameter, creationDateParameter, modifiedDateParameter, isActiveParameter, status);
        }
    
        public virtual int usp_InsertUpdateSiteAccount(Nullable<int> iSiteId, string sSiteIP, string sTitle, string sInstituteName, string sDepartment, string sAddress1, string sAddress2, string sCity, string zip, string phone, Nullable<int> stateId, Nullable<int> countryId, Nullable<bool> isMaster, Nullable<System.DateTime> creationDate, Nullable<System.DateTime> modifiedDate, Nullable<bool> isActive, Nullable<int> userId, string sSiteIPTo, Nullable<int> licenseId, string siteEditionIds, ObjectParameter status)
        {
            var iSiteIdParameter = iSiteId.HasValue ?
                new ObjectParameter("iSiteId", iSiteId) :
                new ObjectParameter("iSiteId", typeof(int));
    
            var sSiteIPParameter = sSiteIP != null ?
                new ObjectParameter("sSiteIP", sSiteIP) :
                new ObjectParameter("sSiteIP", typeof(string));
    
            var sTitleParameter = sTitle != null ?
                new ObjectParameter("sTitle", sTitle) :
                new ObjectParameter("sTitle", typeof(string));
    
            var sInstituteNameParameter = sInstituteName != null ?
                new ObjectParameter("sInstituteName", sInstituteName) :
                new ObjectParameter("sInstituteName", typeof(string));
    
            var sDepartmentParameter = sDepartment != null ?
                new ObjectParameter("sDepartment", sDepartment) :
                new ObjectParameter("sDepartment", typeof(string));
    
            var sAddress1Parameter = sAddress1 != null ?
                new ObjectParameter("sAddress1", sAddress1) :
                new ObjectParameter("sAddress1", typeof(string));
    
            var sAddress2Parameter = sAddress2 != null ?
                new ObjectParameter("sAddress2", sAddress2) :
                new ObjectParameter("sAddress2", typeof(string));
    
            var sCityParameter = sCity != null ?
                new ObjectParameter("sCity", sCity) :
                new ObjectParameter("sCity", typeof(string));
    
            var zipParameter = zip != null ?
                new ObjectParameter("Zip", zip) :
                new ObjectParameter("Zip", typeof(string));
    
            var phoneParameter = phone != null ?
                new ObjectParameter("Phone", phone) :
                new ObjectParameter("Phone", typeof(string));
    
            var stateIdParameter = stateId.HasValue ?
                new ObjectParameter("StateId", stateId) :
                new ObjectParameter("StateId", typeof(int));
    
            var countryIdParameter = countryId.HasValue ?
                new ObjectParameter("CountryId", countryId) :
                new ObjectParameter("CountryId", typeof(int));
    
            var isMasterParameter = isMaster.HasValue ?
                new ObjectParameter("IsMaster", isMaster) :
                new ObjectParameter("IsMaster", typeof(bool));
    
            var creationDateParameter = creationDate.HasValue ?
                new ObjectParameter("CreationDate", creationDate) :
                new ObjectParameter("CreationDate", typeof(System.DateTime));
    
            var modifiedDateParameter = modifiedDate.HasValue ?
                new ObjectParameter("ModifiedDate", modifiedDate) :
                new ObjectParameter("ModifiedDate", typeof(System.DateTime));
    
            var isActiveParameter = isActive.HasValue ?
                new ObjectParameter("IsActive", isActive) :
                new ObjectParameter("IsActive", typeof(bool));
    
            var userIdParameter = userId.HasValue ?
                new ObjectParameter("UserId", userId) :
                new ObjectParameter("UserId", typeof(int));
    
            var sSiteIPToParameter = sSiteIPTo != null ?
                new ObjectParameter("sSiteIPTo", sSiteIPTo) :
                new ObjectParameter("sSiteIPTo", typeof(string));
    
            var licenseIdParameter = licenseId.HasValue ?
                new ObjectParameter("LicenseId", licenseId) :
                new ObjectParameter("LicenseId", typeof(int));
    
            var siteEditionIdsParameter = siteEditionIds != null ?
                new ObjectParameter("SiteEditionIds", siteEditionIds) :
                new ObjectParameter("SiteEditionIds", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("usp_InsertUpdateSiteAccount", iSiteIdParameter, sSiteIPParameter, sTitleParameter, sInstituteNameParameter, sDepartmentParameter, sAddress1Parameter, sAddress2Parameter, sCityParameter, zipParameter, phoneParameter, stateIdParameter, countryIdParameter, isMasterParameter, creationDateParameter, modifiedDateParameter, isActiveParameter, userIdParameter, sSiteIPToParameter, licenseIdParameter, siteEditionIdsParameter, status);
        }
    
        public virtual int usp_SaveLabExerciseAttempts(Nullable<int> userId, string labExerciseIdentifier, Nullable<int> lastQuestion, Nullable<int> totalQuestions)
        {
            var userIdParameter = userId.HasValue ?
                new ObjectParameter("UserId", userId) :
                new ObjectParameter("UserId", typeof(int));
    
            var labExerciseIdentifierParameter = labExerciseIdentifier != null ?
                new ObjectParameter("LabExerciseIdentifier", labExerciseIdentifier) :
                new ObjectParameter("LabExerciseIdentifier", typeof(string));
    
            var lastQuestionParameter = lastQuestion.HasValue ?
                new ObjectParameter("LastQuestion", lastQuestion) :
                new ObjectParameter("LastQuestion", typeof(int));
    
            var totalQuestionsParameter = totalQuestions.HasValue ?
                new ObjectParameter("TotalQuestions", totalQuestions) :
                new ObjectParameter("TotalQuestions", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("usp_SaveLabExerciseAttempts", userIdParameter, labExerciseIdentifierParameter, lastQuestionParameter, totalQuestionsParameter);
        }
    
        public virtual int usp_UpdateAIAUser(string sLoginId, string sPassword, string sFirstname, string sLastname, string sEmailId, Nullable<int> id, Nullable<int> iCreatorId, Nullable<byte> isActive, Nullable<System.DateTime> deactivateDate, ObjectParameter status)
        {
            var sLoginIdParameter = sLoginId != null ?
                new ObjectParameter("sLoginId", sLoginId) :
                new ObjectParameter("sLoginId", typeof(string));
    
            var sPasswordParameter = sPassword != null ?
                new ObjectParameter("sPassword", sPassword) :
                new ObjectParameter("sPassword", typeof(string));
    
            var sFirstnameParameter = sFirstname != null ?
                new ObjectParameter("sFirstname", sFirstname) :
                new ObjectParameter("sFirstname", typeof(string));
    
            var sLastnameParameter = sLastname != null ?
                new ObjectParameter("sLastname", sLastname) :
                new ObjectParameter("sLastname", typeof(string));
    
            var sEmailIdParameter = sEmailId != null ?
                new ObjectParameter("sEmailId", sEmailId) :
                new ObjectParameter("sEmailId", typeof(string));
    
            var idParameter = id.HasValue ?
                new ObjectParameter("id", id) :
                new ObjectParameter("id", typeof(int));
    
            var iCreatorIdParameter = iCreatorId.HasValue ?
                new ObjectParameter("iCreatorId", iCreatorId) :
                new ObjectParameter("iCreatorId", typeof(int));
    
            var isActiveParameter = isActive.HasValue ?
                new ObjectParameter("isActive", isActive) :
                new ObjectParameter("isActive", typeof(byte));
    
            var deactivateDateParameter = deactivateDate.HasValue ?
                new ObjectParameter("deactivateDate", deactivateDate) :
                new ObjectParameter("deactivateDate", typeof(System.DateTime));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("usp_UpdateAIAUser", sLoginIdParameter, sPasswordParameter, sFirstnameParameter, sLastnameParameter, sEmailIdParameter, idParameter, iCreatorIdParameter, isActiveParameter, deactivateDateParameter, status);
        }
    
        public virtual int usp_UpdateblockedUser(Nullable<int> id, ObjectParameter status)
        {
            var idParameter = id.HasValue ?
                new ObjectParameter("Id", id) :
                new ObjectParameter("Id", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("usp_UpdateblockedUser", idParameter, status);
        }
    
        public virtual int usp_UpdateLicenseBasicSettings(Nullable<int> iLicenseId, string sLicenseeFname, string sLicenseeLname, string sInstitutionName, string sAddress1, string sAddress2, string sCity, string sZip, Nullable<int> iStateId, Nullable<int> iCountryId, string sPhone, string sEmailId, ObjectParameter status)
        {
            var iLicenseIdParameter = iLicenseId.HasValue ?
                new ObjectParameter("iLicenseId", iLicenseId) :
                new ObjectParameter("iLicenseId", typeof(int));
    
            var sLicenseeFnameParameter = sLicenseeFname != null ?
                new ObjectParameter("sLicenseeFname", sLicenseeFname) :
                new ObjectParameter("sLicenseeFname", typeof(string));
    
            var sLicenseeLnameParameter = sLicenseeLname != null ?
                new ObjectParameter("sLicenseeLname", sLicenseeLname) :
                new ObjectParameter("sLicenseeLname", typeof(string));
    
            var sInstitutionNameParameter = sInstitutionName != null ?
                new ObjectParameter("sInstitutionName", sInstitutionName) :
                new ObjectParameter("sInstitutionName", typeof(string));
    
            var sAddress1Parameter = sAddress1 != null ?
                new ObjectParameter("sAddress1", sAddress1) :
                new ObjectParameter("sAddress1", typeof(string));
    
            var sAddress2Parameter = sAddress2 != null ?
                new ObjectParameter("sAddress2", sAddress2) :
                new ObjectParameter("sAddress2", typeof(string));
    
            var sCityParameter = sCity != null ?
                new ObjectParameter("sCity", sCity) :
                new ObjectParameter("sCity", typeof(string));
    
            var sZipParameter = sZip != null ?
                new ObjectParameter("sZip", sZip) :
                new ObjectParameter("sZip", typeof(string));
    
            var iStateIdParameter = iStateId.HasValue ?
                new ObjectParameter("iStateId", iStateId) :
                new ObjectParameter("iStateId", typeof(int));
    
            var iCountryIdParameter = iCountryId.HasValue ?
                new ObjectParameter("iCountryId", iCountryId) :
                new ObjectParameter("iCountryId", typeof(int));
    
            var sPhoneParameter = sPhone != null ?
                new ObjectParameter("sPhone", sPhone) :
                new ObjectParameter("sPhone", typeof(string));
    
            var sEmailIdParameter = sEmailId != null ?
                new ObjectParameter("sEmailId", sEmailId) :
                new ObjectParameter("sEmailId", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("usp_UpdateLicenseBasicSettings", iLicenseIdParameter, sLicenseeFnameParameter, sLicenseeLnameParameter, sInstitutionNameParameter, sAddress1Parameter, sAddress2Parameter, sCityParameter, sZipParameter, iStateIdParameter, iCountryIdParameter, sPhoneParameter, sEmailIdParameter, status);
        }
    
        public virtual int usp_UpdateLicenseModestySettings(Nullable<int> licenseEditionId, Nullable<int> siteId, Nullable<bool> isModesty, ObjectParameter status)
        {
            var licenseEditionIdParameter = licenseEditionId.HasValue ?
                new ObjectParameter("LicenseEditionId", licenseEditionId) :
                new ObjectParameter("LicenseEditionId", typeof(int));
    
            var siteIdParameter = siteId.HasValue ?
                new ObjectParameter("SiteId", siteId) :
                new ObjectParameter("SiteId", typeof(int));
    
            var isModestyParameter = isModesty.HasValue ?
                new ObjectParameter("IsModesty", isModesty) :
                new ObjectParameter("IsModesty", typeof(bool));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("usp_UpdateLicenseModestySettings", licenseEditionIdParameter, siteIdParameter, isModestyParameter, status);
        }
    
        public virtual int usp_UpdateLicenseModuleStatus(Nullable<int> licenseId, string moduleStatusText, ObjectParameter status)
        {
            var licenseIdParameter = licenseId.HasValue ?
                new ObjectParameter("LicenseId", licenseId) :
                new ObjectParameter("LicenseId", typeof(int));
    
            var moduleStatusTextParameter = moduleStatusText != null ?
                new ObjectParameter("ModuleStatusText", moduleStatusText) :
                new ObjectParameter("ModuleStatusText", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("usp_UpdateLicenseModuleStatus", licenseIdParameter, moduleStatusTextParameter, status);
        }
    
        public virtual int usp_UpdateLicenseUserGroupUsers(Nullable<int> userGroupId, string userIds, ObjectParameter status)
        {
            var userGroupIdParameter = userGroupId.HasValue ?
                new ObjectParameter("UserGroupId", userGroupId) :
                new ObjectParameter("UserGroupId", typeof(int));
    
            var userIdsParameter = userIds != null ?
                new ObjectParameter("UserIds", userIds) :
                new ObjectParameter("UserIds", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("usp_UpdateLicenseUserGroupUsers", userGroupIdParameter, userIdsParameter, status);
        }
    
        public virtual int usp_UpdateSubscriptionPlan(Nullable<byte> id, string title, Nullable<decimal> price, Nullable<byte> duration, Nullable<byte> editionId, Nullable<bool> isActive, ObjectParameter status)
        {
            var idParameter = id.HasValue ?
                new ObjectParameter("Id", id) :
                new ObjectParameter("Id", typeof(byte));
    
            var titleParameter = title != null ?
                new ObjectParameter("Title", title) :
                new ObjectParameter("Title", typeof(string));
    
            var priceParameter = price.HasValue ?
                new ObjectParameter("Price", price) :
                new ObjectParameter("Price", typeof(decimal));
    
            var durationParameter = duration.HasValue ?
                new ObjectParameter("Duration", duration) :
                new ObjectParameter("Duration", typeof(byte));
    
            var editionIdParameter = editionId.HasValue ?
                new ObjectParameter("EditionId", editionId) :
                new ObjectParameter("EditionId", typeof(byte));
    
            var isActiveParameter = isActive.HasValue ?
                new ObjectParameter("IsActive", isActive) :
                new ObjectParameter("IsActive", typeof(bool));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("usp_UpdateSubscriptionPlan", idParameter, titleParameter, priceParameter, durationParameter, editionIdParameter, isActiveParameter, status);
        }
    
        public virtual int usp_UpdateUserId(Nullable<int> id, string userId, string olduserId, ObjectParameter status)
        {
            var idParameter = id.HasValue ?
                new ObjectParameter("Id", id) :
                new ObjectParameter("Id", typeof(int));
    
            var userIdParameter = userId != null ?
                new ObjectParameter("UserId", userId) :
                new ObjectParameter("UserId", typeof(string));
    
            var olduserIdParameter = olduserId != null ?
                new ObjectParameter("olduserId", olduserId) :
                new ObjectParameter("olduserId", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("usp_UpdateUserId", idParameter, userIdParameter, olduserIdParameter, status);
        }
    
        public virtual int uspInsertBulkRow()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("uspInsertBulkRow");
        }
    
        public virtual ObjectResult<usp_GetLicenseUserGroupUsers_Result> usp_GetLicenseUserGroupUsers(Nullable<int> licenseId, Nullable<int> groupId, Nullable<bool> allUsers, Nullable<int> pageNo, Nullable<int> pageLength, ObjectParameter recordCount)
        {
            var licenseIdParameter = licenseId.HasValue ?
                new ObjectParameter("licenseId", licenseId) :
                new ObjectParameter("licenseId", typeof(int));
    
            var groupIdParameter = groupId.HasValue ?
                new ObjectParameter("groupId", groupId) :
                new ObjectParameter("groupId", typeof(int));
    
            var allUsersParameter = allUsers.HasValue ?
                new ObjectParameter("allUsers", allUsers) :
                new ObjectParameter("allUsers", typeof(bool));
    
            var pageNoParameter = pageNo.HasValue ?
                new ObjectParameter("pageNo", pageNo) :
                new ObjectParameter("pageNo", typeof(int));
    
            var pageLengthParameter = pageLength.HasValue ?
                new ObjectParameter("pageLength", pageLength) :
                new ObjectParameter("pageLength", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_GetLicenseUserGroupUsers_Result>("usp_GetLicenseUserGroupUsers", licenseIdParameter, groupIdParameter, allUsersParameter, pageNoParameter, pageLengthParameter, recordCount);
        }
    
        public virtual ObjectResult<usp_InsertResellerLicenseAccount_Result> usp_InsertResellerLicenseAccount(string sLicenseeFname, string sLicenseeLname, Nullable<byte> iLicenseTypeId, Nullable<byte> iAccountTypeId, string sInstitutionName, string sAddress1, string sAddress2, string sCity, string sZip, Nullable<int> iStateId, Nullable<int> iCountryId, string sPhone, string sEmailId, Nullable<int> iTotalLogins, string sStartDate, string sEndDate, string sEditionList, Nullable<decimal> iTotalPrice, Nullable<int> iCreatorId, string sProductKey, Nullable<int> iNoofImages)
        {
            var sLicenseeFnameParameter = sLicenseeFname != null ?
                new ObjectParameter("sLicenseeFname", sLicenseeFname) :
                new ObjectParameter("sLicenseeFname", typeof(string));
    
            var sLicenseeLnameParameter = sLicenseeLname != null ?
                new ObjectParameter("sLicenseeLname", sLicenseeLname) :
                new ObjectParameter("sLicenseeLname", typeof(string));
    
            var iLicenseTypeIdParameter = iLicenseTypeId.HasValue ?
                new ObjectParameter("iLicenseTypeId", iLicenseTypeId) :
                new ObjectParameter("iLicenseTypeId", typeof(byte));
    
            var iAccountTypeIdParameter = iAccountTypeId.HasValue ?
                new ObjectParameter("iAccountTypeId", iAccountTypeId) :
                new ObjectParameter("iAccountTypeId", typeof(byte));
    
            var sInstitutionNameParameter = sInstitutionName != null ?
                new ObjectParameter("sInstitutionName", sInstitutionName) :
                new ObjectParameter("sInstitutionName", typeof(string));
    
            var sAddress1Parameter = sAddress1 != null ?
                new ObjectParameter("sAddress1", sAddress1) :
                new ObjectParameter("sAddress1", typeof(string));
    
            var sAddress2Parameter = sAddress2 != null ?
                new ObjectParameter("sAddress2", sAddress2) :
                new ObjectParameter("sAddress2", typeof(string));
    
            var sCityParameter = sCity != null ?
                new ObjectParameter("sCity", sCity) :
                new ObjectParameter("sCity", typeof(string));
    
            var sZipParameter = sZip != null ?
                new ObjectParameter("sZip", sZip) :
                new ObjectParameter("sZip", typeof(string));
    
            var iStateIdParameter = iStateId.HasValue ?
                new ObjectParameter("iStateId", iStateId) :
                new ObjectParameter("iStateId", typeof(int));
    
            var iCountryIdParameter = iCountryId.HasValue ?
                new ObjectParameter("iCountryId", iCountryId) :
                new ObjectParameter("iCountryId", typeof(int));
    
            var sPhoneParameter = sPhone != null ?
                new ObjectParameter("sPhone", sPhone) :
                new ObjectParameter("sPhone", typeof(string));
    
            var sEmailIdParameter = sEmailId != null ?
                new ObjectParameter("sEmailId", sEmailId) :
                new ObjectParameter("sEmailId", typeof(string));
    
            var iTotalLoginsParameter = iTotalLogins.HasValue ?
                new ObjectParameter("iTotalLogins", iTotalLogins) :
                new ObjectParameter("iTotalLogins", typeof(int));
    
            var sStartDateParameter = sStartDate != null ?
                new ObjectParameter("sStartDate", sStartDate) :
                new ObjectParameter("sStartDate", typeof(string));
    
            var sEndDateParameter = sEndDate != null ?
                new ObjectParameter("sEndDate", sEndDate) :
                new ObjectParameter("sEndDate", typeof(string));
    
            var sEditionListParameter = sEditionList != null ?
                new ObjectParameter("sEditionList", sEditionList) :
                new ObjectParameter("sEditionList", typeof(string));
    
            var iTotalPriceParameter = iTotalPrice.HasValue ?
                new ObjectParameter("iTotalPrice", iTotalPrice) :
                new ObjectParameter("iTotalPrice", typeof(decimal));
    
            var iCreatorIdParameter = iCreatorId.HasValue ?
                new ObjectParameter("iCreatorId", iCreatorId) :
                new ObjectParameter("iCreatorId", typeof(int));
    
            var sProductKeyParameter = sProductKey != null ?
                new ObjectParameter("sProductKey", sProductKey) :
                new ObjectParameter("sProductKey", typeof(string));
    
            var iNoofImagesParameter = iNoofImages.HasValue ?
                new ObjectParameter("iNoofImages", iNoofImages) :
                new ObjectParameter("iNoofImages", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_InsertResellerLicenseAccount_Result>("usp_InsertResellerLicenseAccount", sLicenseeFnameParameter, sLicenseeLnameParameter, iLicenseTypeIdParameter, iAccountTypeIdParameter, sInstitutionNameParameter, sAddress1Parameter, sAddress2Parameter, sCityParameter, sZipParameter, iStateIdParameter, iCountryIdParameter, sPhoneParameter, sEmailIdParameter, iTotalLoginsParameter, sStartDateParameter, sEndDateParameter, sEditionListParameter, iTotalPriceParameter, iCreatorIdParameter, sProductKeyParameter, iNoofImagesParameter);
        }
    
        public virtual int usp_CheckSubscriptionForLicense(Nullable<byte> id, ObjectParameter status)
        {
            var idParameter = id.HasValue ?
                new ObjectParameter("Id", id) :
                new ObjectParameter("Id", typeof(byte));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("usp_CheckSubscriptionForLicense", idParameter, status);
        }
    
        public virtual int usp_CheckDuplicateLicenseUserGroup(Nullable<int> licenseId, string title, ObjectParameter status)
        {
            var licenseIdParameter = licenseId.HasValue ?
                new ObjectParameter("LicenseId", licenseId) :
                new ObjectParameter("LicenseId", typeof(int));
    
            var titleParameter = title != null ?
                new ObjectParameter("Title", title) :
                new ObjectParameter("Title", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("usp_CheckDuplicateLicenseUserGroup", licenseIdParameter, titleParameter, status);
        }
    
        public virtual ObjectResult<usp_GetSiteAccountAdmin_Result> usp_GetSiteAccountAdmin(string accountNumber)
        {
            var accountNumberParameter = accountNumber != null ?
                new ObjectParameter("AccountNumber", accountNumber) :
                new ObjectParameter("AccountNumber", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_GetSiteAccountAdmin_Result>("usp_GetSiteAccountAdmin", accountNumberParameter);
        }
    
        public virtual ObjectResult<usp_GetSiteAccountSites_Result> usp_GetSiteAccountSites(string strAccountNumber, Nullable<int> pageNo, Nullable<int> pageLength, ObjectParameter recordCount)
        {
            var strAccountNumberParameter = strAccountNumber != null ?
                new ObjectParameter("strAccountNumber", strAccountNumber) :
                new ObjectParameter("strAccountNumber", typeof(string));
    
            var pageNoParameter = pageNo.HasValue ?
                new ObjectParameter("pageNo", pageNo) :
                new ObjectParameter("pageNo", typeof(int));
    
            var pageLengthParameter = pageLength.HasValue ?
                new ObjectParameter("pageLength", pageLength) :
                new ObjectParameter("pageLength", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_GetSiteAccountSites_Result>("usp_GetSiteAccountSites", strAccountNumberParameter, pageNoParameter, pageLengthParameter, recordCount);
        }
    
        public virtual ObjectResult<string> usp_DeleteLicense(Nullable<int> iLicenseId)
        {
            var iLicenseIdParameter = iLicenseId.HasValue ?
                new ObjectParameter("iLicenseId", iLicenseId) :
                new ObjectParameter("iLicenseId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("usp_DeleteLicense", iLicenseIdParameter);
        }
    
        public virtual ObjectResult<usp_EC_GetAccountTypeList_Result> usp_EC_GetAccountTypeList()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_EC_GetAccountTypeList_Result>("usp_EC_GetAccountTypeList");
        }
    
        public virtual ObjectResult<usp_EC_GetCountryList_Result> usp_EC_GetCountryList()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_EC_GetCountryList_Result>("usp_EC_GetCountryList");
        }
    
        public virtual ObjectResult<usp_EC_GetSecurityQuestionList_Result> usp_EC_GetSecurityQuestionList()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_EC_GetSecurityQuestionList_Result>("usp_EC_GetSecurityQuestionList");
        }
    
        public virtual ObjectResult<usp_EC_GetStateList_Result> usp_EC_GetStateList()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_EC_GetStateList_Result>("usp_EC_GetStateList");
        }
    
        public virtual ObjectResult<usp_GetAIAUserToLicenseEditionDetailByUserId_Result> usp_GetAIAUserToLicenseEditionDetailByUserId(Nullable<int> userId)
        {
            var userIdParameter = userId.HasValue ?
                new ObjectParameter("userId", userId) :
                new ObjectParameter("userId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_GetAIAUserToLicenseEditionDetailByUserId_Result>("usp_GetAIAUserToLicenseEditionDetailByUserId", userIdParameter);
        }
    
        public virtual ObjectResult<usp_GetBlockedUserByAccNoAndType_Result> usp_GetBlockedUserByAccNoAndType(Nullable<byte> iUserTypeId, Nullable<int> iLicenseId)
        {
            var iUserTypeIdParameter = iUserTypeId.HasValue ?
                new ObjectParameter("iUserTypeId", iUserTypeId) :
                new ObjectParameter("iUserTypeId", typeof(byte));
    
            var iLicenseIdParameter = iLicenseId.HasValue ?
                new ObjectParameter("iLicenseId", iLicenseId) :
                new ObjectParameter("iLicenseId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_GetBlockedUserByAccNoAndType_Result>("usp_GetBlockedUserByAccNoAndType", iUserTypeIdParameter, iLicenseIdParameter);
        }
    
        public virtual ObjectResult<usp_GetCancelledLicenses_Result> usp_GetCancelledLicenses(string sFromDate, string sToDate, Nullable<decimal> iStartPrice, Nullable<decimal> iEndPrice, Nullable<byte> iLicenseTypeId, Nullable<byte> iAccountTypeId, string sZip, Nullable<int> iStateId, Nullable<int> iCountryId, Nullable<int> pageNo, Nullable<int> pageLength, ObjectParameter recordCount)
        {
            var sFromDateParameter = sFromDate != null ?
                new ObjectParameter("sFromDate", sFromDate) :
                new ObjectParameter("sFromDate", typeof(string));
    
            var sToDateParameter = sToDate != null ?
                new ObjectParameter("sToDate", sToDate) :
                new ObjectParameter("sToDate", typeof(string));
    
            var iStartPriceParameter = iStartPrice.HasValue ?
                new ObjectParameter("iStartPrice", iStartPrice) :
                new ObjectParameter("iStartPrice", typeof(decimal));
    
            var iEndPriceParameter = iEndPrice.HasValue ?
                new ObjectParameter("iEndPrice", iEndPrice) :
                new ObjectParameter("iEndPrice", typeof(decimal));
    
            var iLicenseTypeIdParameter = iLicenseTypeId.HasValue ?
                new ObjectParameter("iLicenseTypeId", iLicenseTypeId) :
                new ObjectParameter("iLicenseTypeId", typeof(byte));
    
            var iAccountTypeIdParameter = iAccountTypeId.HasValue ?
                new ObjectParameter("iAccountTypeId", iAccountTypeId) :
                new ObjectParameter("iAccountTypeId", typeof(byte));
    
            var sZipParameter = sZip != null ?
                new ObjectParameter("sZip", sZip) :
                new ObjectParameter("sZip", typeof(string));
    
            var iStateIdParameter = iStateId.HasValue ?
                new ObjectParameter("iStateId", iStateId) :
                new ObjectParameter("iStateId", typeof(int));
    
            var iCountryIdParameter = iCountryId.HasValue ?
                new ObjectParameter("iCountryId", iCountryId) :
                new ObjectParameter("iCountryId", typeof(int));
    
            var pageNoParameter = pageNo.HasValue ?
                new ObjectParameter("pageNo", pageNo) :
                new ObjectParameter("pageNo", typeof(int));
    
            var pageLengthParameter = pageLength.HasValue ?
                new ObjectParameter("pageLength", pageLength) :
                new ObjectParameter("pageLength", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_GetCancelledLicenses_Result>("usp_GetCancelledLicenses", sFromDateParameter, sToDateParameter, iStartPriceParameter, iEndPriceParameter, iLicenseTypeIdParameter, iAccountTypeIdParameter, sZipParameter, iStateIdParameter, iCountryIdParameter, pageNoParameter, pageLengthParameter, recordCount);
        }
    
        public virtual ObjectResult<usp_GetCustomerSummary_Result> usp_GetCustomerSummary(string sAccoutNumber, string sLicenseeFullName, Nullable<decimal> iStartPrice, Nullable<decimal> iEndPrice, Nullable<byte> iLicenseType, Nullable<byte> iAccountType, string sZip, Nullable<int> iState, Nullable<int> iCountry, Nullable<int> pageNo, Nullable<int> pageLength, ObjectParameter recordCount)
        {
            var sAccoutNumberParameter = sAccoutNumber != null ?
                new ObjectParameter("sAccoutNumber", sAccoutNumber) :
                new ObjectParameter("sAccoutNumber", typeof(string));
    
            var sLicenseeFullNameParameter = sLicenseeFullName != null ?
                new ObjectParameter("sLicenseeFullName", sLicenseeFullName) :
                new ObjectParameter("sLicenseeFullName", typeof(string));
    
            var iStartPriceParameter = iStartPrice.HasValue ?
                new ObjectParameter("iStartPrice", iStartPrice) :
                new ObjectParameter("iStartPrice", typeof(decimal));
    
            var iEndPriceParameter = iEndPrice.HasValue ?
                new ObjectParameter("iEndPrice", iEndPrice) :
                new ObjectParameter("iEndPrice", typeof(decimal));
    
            var iLicenseTypeParameter = iLicenseType.HasValue ?
                new ObjectParameter("iLicenseType", iLicenseType) :
                new ObjectParameter("iLicenseType", typeof(byte));
    
            var iAccountTypeParameter = iAccountType.HasValue ?
                new ObjectParameter("iAccountType", iAccountType) :
                new ObjectParameter("iAccountType", typeof(byte));
    
            var sZipParameter = sZip != null ?
                new ObjectParameter("sZip", sZip) :
                new ObjectParameter("sZip", typeof(string));
    
            var iStateParameter = iState.HasValue ?
                new ObjectParameter("iState", iState) :
                new ObjectParameter("iState", typeof(int));
    
            var iCountryParameter = iCountry.HasValue ?
                new ObjectParameter("iCountry", iCountry) :
                new ObjectParameter("iCountry", typeof(int));
    
            var pageNoParameter = pageNo.HasValue ?
                new ObjectParameter("pageNo", pageNo) :
                new ObjectParameter("pageNo", typeof(int));
    
            var pageLengthParameter = pageLength.HasValue ?
                new ObjectParameter("pageLength", pageLength) :
                new ObjectParameter("pageLength", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_GetCustomerSummary_Result>("usp_GetCustomerSummary", sAccoutNumberParameter, sLicenseeFullNameParameter, iStartPriceParameter, iEndPriceParameter, iLicenseTypeParameter, iAccountTypeParameter, sZipParameter, iStateParameter, iCountryParameter, pageNoParameter, pageLengthParameter, recordCount);
        }
    
        public virtual ObjectResult<usp_GetDiscountCodes_Result> usp_GetDiscountCodes(string sDiscountCode, string sStartDate, string sEndDate, Nullable<int> pageNo, Nullable<int> pageLength, ObjectParameter recordCount)
        {
            var sDiscountCodeParameter = sDiscountCode != null ?
                new ObjectParameter("sDiscountCode", sDiscountCode) :
                new ObjectParameter("sDiscountCode", typeof(string));
    
            var sStartDateParameter = sStartDate != null ?
                new ObjectParameter("sStartDate", sStartDate) :
                new ObjectParameter("sStartDate", typeof(string));
    
            var sEndDateParameter = sEndDate != null ?
                new ObjectParameter("sEndDate", sEndDate) :
                new ObjectParameter("sEndDate", typeof(string));
    
            var pageNoParameter = pageNo.HasValue ?
                new ObjectParameter("pageNo", pageNo) :
                new ObjectParameter("pageNo", typeof(int));
    
            var pageLengthParameter = pageLength.HasValue ?
                new ObjectParameter("pageLength", pageLength) :
                new ObjectParameter("pageLength", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_GetDiscountCodes_Result>("usp_GetDiscountCodes", sDiscountCodeParameter, sStartDateParameter, sEndDateParameter, pageNoParameter, pageLengthParameter, recordCount);
        }
    
        public virtual ObjectResult<usp_GetDiscountReport_Result> usp_GetDiscountReport(string sStartDate, string sEndDate, Nullable<int> intDiscountID, string sAccoutNumber, Nullable<int> pageNo, Nullable<int> pageLength, ObjectParameter recordCount)
        {
            var sStartDateParameter = sStartDate != null ?
                new ObjectParameter("sStartDate", sStartDate) :
                new ObjectParameter("sStartDate", typeof(string));
    
            var sEndDateParameter = sEndDate != null ?
                new ObjectParameter("sEndDate", sEndDate) :
                new ObjectParameter("sEndDate", typeof(string));
    
            var intDiscountIDParameter = intDiscountID.HasValue ?
                new ObjectParameter("intDiscountID", intDiscountID) :
                new ObjectParameter("intDiscountID", typeof(int));
    
            var sAccoutNumberParameter = sAccoutNumber != null ?
                new ObjectParameter("sAccoutNumber", sAccoutNumber) :
                new ObjectParameter("sAccoutNumber", typeof(string));
    
            var pageNoParameter = pageNo.HasValue ?
                new ObjectParameter("pageNo", pageNo) :
                new ObjectParameter("pageNo", typeof(int));
    
            var pageLengthParameter = pageLength.HasValue ?
                new ObjectParameter("pageLength", pageLength) :
                new ObjectParameter("pageLength", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_GetDiscountReport_Result>("usp_GetDiscountReport", sStartDateParameter, sEndDateParameter, intDiscountIDParameter, sAccoutNumberParameter, pageNoParameter, pageLengthParameter, recordCount);
        }
    
        public virtual ObjectResult<usp_GetExpiringLicenses_Result> usp_GetExpiringLicenses(string sFromDate, string sToDate, Nullable<decimal> iStartPrice, Nullable<decimal> iEndPrice, Nullable<int> iLicenseTypeId, Nullable<int> iAccountTypeId, string sZip, Nullable<int> iStateId, Nullable<int> iCountryId, Nullable<int> pageNo, Nullable<int> pageLength, ObjectParameter recordCount)
        {
            var sFromDateParameter = sFromDate != null ?
                new ObjectParameter("sFromDate", sFromDate) :
                new ObjectParameter("sFromDate", typeof(string));
    
            var sToDateParameter = sToDate != null ?
                new ObjectParameter("sToDate", sToDate) :
                new ObjectParameter("sToDate", typeof(string));
    
            var iStartPriceParameter = iStartPrice.HasValue ?
                new ObjectParameter("iStartPrice", iStartPrice) :
                new ObjectParameter("iStartPrice", typeof(decimal));
    
            var iEndPriceParameter = iEndPrice.HasValue ?
                new ObjectParameter("iEndPrice", iEndPrice) :
                new ObjectParameter("iEndPrice", typeof(decimal));
    
            var iLicenseTypeIdParameter = iLicenseTypeId.HasValue ?
                new ObjectParameter("iLicenseTypeId", iLicenseTypeId) :
                new ObjectParameter("iLicenseTypeId", typeof(int));
    
            var iAccountTypeIdParameter = iAccountTypeId.HasValue ?
                new ObjectParameter("iAccountTypeId", iAccountTypeId) :
                new ObjectParameter("iAccountTypeId", typeof(int));
    
            var sZipParameter = sZip != null ?
                new ObjectParameter("sZip", sZip) :
                new ObjectParameter("sZip", typeof(string));
    
            var iStateIdParameter = iStateId.HasValue ?
                new ObjectParameter("iStateId", iStateId) :
                new ObjectParameter("iStateId", typeof(int));
    
            var iCountryIdParameter = iCountryId.HasValue ?
                new ObjectParameter("iCountryId", iCountryId) :
                new ObjectParameter("iCountryId", typeof(int));
    
            var pageNoParameter = pageNo.HasValue ?
                new ObjectParameter("pageNo", pageNo) :
                new ObjectParameter("pageNo", typeof(int));
    
            var pageLengthParameter = pageLength.HasValue ?
                new ObjectParameter("pageLength", pageLength) :
                new ObjectParameter("pageLength", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_GetExpiringLicenses_Result>("usp_GetExpiringLicenses", sFromDateParameter, sToDateParameter, iStartPriceParameter, iEndPriceParameter, iLicenseTypeIdParameter, iAccountTypeIdParameter, sZipParameter, iStateIdParameter, iCountryIdParameter, pageNoParameter, pageLengthParameter, recordCount);
        }
    
        public virtual ObjectResult<usp_GetExportedImageDetails_Result> usp_GetExportedImageDetails(string sStartDate, string sEndDate, string sAccoutNumber, Nullable<int> pageNo, Nullable<int> pageLength, ObjectParameter recordCount)
        {
            var sStartDateParameter = sStartDate != null ?
                new ObjectParameter("sStartDate", sStartDate) :
                new ObjectParameter("sStartDate", typeof(string));
    
            var sEndDateParameter = sEndDate != null ?
                new ObjectParameter("sEndDate", sEndDate) :
                new ObjectParameter("sEndDate", typeof(string));
    
            var sAccoutNumberParameter = sAccoutNumber != null ?
                new ObjectParameter("sAccoutNumber", sAccoutNumber) :
                new ObjectParameter("sAccoutNumber", typeof(string));
    
            var pageNoParameter = pageNo.HasValue ?
                new ObjectParameter("pageNo", pageNo) :
                new ObjectParameter("pageNo", typeof(int));
    
            var pageLengthParameter = pageLength.HasValue ?
                new ObjectParameter("pageLength", pageLength) :
                new ObjectParameter("pageLength", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_GetExportedImageDetails_Result>("usp_GetExportedImageDetails", sStartDateParameter, sEndDateParameter, sAccoutNumberParameter, pageNoParameter, pageLengthParameter, recordCount);
        }
    
        public virtual ObjectResult<Nullable<short>> usp_GetIncorrectLoginAttempt(Nullable<int> iUserId)
        {
            var iUserIdParameter = iUserId.HasValue ?
                new ObjectParameter("iUserId", iUserId) :
                new ObjectParameter("iUserId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<short>>("usp_GetIncorrectLoginAttempt", iUserIdParameter);
        }
    
        public virtual ObjectResult<usp_GetLicenseByLicenseId_Result> usp_GetLicenseByLicenseId(Nullable<int> licenseId)
        {
            var licenseIdParameter = licenseId.HasValue ?
                new ObjectParameter("LicenseId", licenseId) :
                new ObjectParameter("LicenseId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_GetLicenseByLicenseId_Result>("usp_GetLicenseByLicenseId", licenseIdParameter);
        }
    
        public virtual ObjectResult<usp_GetLicenseEditionById_Result> usp_GetLicenseEditionById(Nullable<int> licenseEditionId)
        {
            var licenseEditionIdParameter = licenseEditionId.HasValue ?
                new ObjectParameter("LicenseEditionId", licenseEditionId) :
                new ObjectParameter("LicenseEditionId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_GetLicenseEditionById_Result>("usp_GetLicenseEditionById", licenseEditionIdParameter);
        }
    
        public virtual ObjectResult<Nullable<bool>> usp_GetModestyForThisLicense(Nullable<int> licenseId, Nullable<byte> editionId)
        {
            var licenseIdParameter = licenseId.HasValue ?
                new ObjectParameter("licenseId", licenseId) :
                new ObjectParameter("licenseId", typeof(int));
    
            var editionIdParameter = editionId.HasValue ?
                new ObjectParameter("editionId", editionId) :
                new ObjectParameter("editionId", typeof(byte));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<bool>>("usp_GetModestyForThisLicense", licenseIdParameter, editionIdParameter);
        }
    
        public virtual ObjectResult<usp_GetModuleStatusByLicenseId_Result> usp_GetModuleStatusByLicenseId(Nullable<int> iLicenseId)
        {
            var iLicenseIdParameter = iLicenseId.HasValue ?
                new ObjectParameter("iLicenseId", iLicenseId) :
                new ObjectParameter("iLicenseId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_GetModuleStatusByLicenseId_Result>("usp_GetModuleStatusByLicenseId", iLicenseIdParameter);
        }
    
        public virtual ObjectResult<usp_GetNetAdSummaryReport_Result> usp_GetNetAdSummaryReport(string sFromDate, string sToDate, Nullable<decimal> iStartPrice, Nullable<decimal> iEndPrice, Nullable<byte> iLicenseTypeId, Nullable<int> pageNo, Nullable<int> pageLength, ObjectParameter recordCount)
        {
            var sFromDateParameter = sFromDate != null ?
                new ObjectParameter("sFromDate", sFromDate) :
                new ObjectParameter("sFromDate", typeof(string));
    
            var sToDateParameter = sToDate != null ?
                new ObjectParameter("sToDate", sToDate) :
                new ObjectParameter("sToDate", typeof(string));
    
            var iStartPriceParameter = iStartPrice.HasValue ?
                new ObjectParameter("iStartPrice", iStartPrice) :
                new ObjectParameter("iStartPrice", typeof(decimal));
    
            var iEndPriceParameter = iEndPrice.HasValue ?
                new ObjectParameter("iEndPrice", iEndPrice) :
                new ObjectParameter("iEndPrice", typeof(decimal));
    
            var iLicenseTypeIdParameter = iLicenseTypeId.HasValue ?
                new ObjectParameter("iLicenseTypeId", iLicenseTypeId) :
                new ObjectParameter("iLicenseTypeId", typeof(byte));
    
            var pageNoParameter = pageNo.HasValue ?
                new ObjectParameter("pageNo", pageNo) :
                new ObjectParameter("pageNo", typeof(int));
    
            var pageLengthParameter = pageLength.HasValue ?
                new ObjectParameter("pageLength", pageLength) :
                new ObjectParameter("pageLength", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_GetNetAdSummaryReport_Result>("usp_GetNetAdSummaryReport", sFromDateParameter, sToDateParameter, iStartPriceParameter, iEndPriceParameter, iLicenseTypeIdParameter, pageNoParameter, pageLengthParameter, recordCount);
        }
    
        public virtual ObjectResult<string> usp_GetSearchUser(string sFirstName, string sLastName, string sEmailId, string sAccoutNumber, Nullable<int> iUserTypeId, Nullable<int> iAccountTypeId, Nullable<int> iLoginUserType, Nullable<int> pageNo, Nullable<int> pageLength, ObjectParameter recordCount)
        {
            var sFirstNameParameter = sFirstName != null ?
                new ObjectParameter("sFirstName", sFirstName) :
                new ObjectParameter("sFirstName", typeof(string));
    
            var sLastNameParameter = sLastName != null ?
                new ObjectParameter("sLastName", sLastName) :
                new ObjectParameter("sLastName", typeof(string));
    
            var sEmailIdParameter = sEmailId != null ?
                new ObjectParameter("sEmailId", sEmailId) :
                new ObjectParameter("sEmailId", typeof(string));
    
            var sAccoutNumberParameter = sAccoutNumber != null ?
                new ObjectParameter("sAccoutNumber", sAccoutNumber) :
                new ObjectParameter("sAccoutNumber", typeof(string));
    
            var iUserTypeIdParameter = iUserTypeId.HasValue ?
                new ObjectParameter("iUserTypeId", iUserTypeId) :
                new ObjectParameter("iUserTypeId", typeof(int));
    
            var iAccountTypeIdParameter = iAccountTypeId.HasValue ?
                new ObjectParameter("iAccountTypeId", iAccountTypeId) :
                new ObjectParameter("iAccountTypeId", typeof(int));
    
            var iLoginUserTypeParameter = iLoginUserType.HasValue ?
                new ObjectParameter("iLoginUserType", iLoginUserType) :
                new ObjectParameter("iLoginUserType", typeof(int));
    
            var pageNoParameter = pageNo.HasValue ?
                new ObjectParameter("pageNo", pageNo) :
                new ObjectParameter("pageNo", typeof(int));
    
            var pageLengthParameter = pageLength.HasValue ?
                new ObjectParameter("pageLength", pageLength) :
                new ObjectParameter("pageLength", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("usp_GetSearchUser", sFirstNameParameter, sLastNameParameter, sEmailIdParameter, sAccoutNumberParameter, iUserTypeIdParameter, iAccountTypeIdParameter, iLoginUserTypeParameter, pageNoParameter, pageLengthParameter, recordCount);
        }
    
        public virtual ObjectResult<usp_GetSessionByLicenseEditionId_Result> usp_GetSessionByLicenseEditionId(Nullable<int> licenseId, Nullable<int> editionId)
        {
            var licenseIdParameter = licenseId.HasValue ?
                new ObjectParameter("LicenseId", licenseId) :
                new ObjectParameter("LicenseId", typeof(int));
    
            var editionIdParameter = editionId.HasValue ?
                new ObjectParameter("EditionId", editionId) :
                new ObjectParameter("EditionId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_GetSessionByLicenseEditionId_Result>("usp_GetSessionByLicenseEditionId", licenseIdParameter, editionIdParameter);
        }
    
        public virtual ObjectResult<usp_GetSiteAccoutDetail_Result> usp_GetSiteAccoutDetail(string strAccountNumber, Nullable<int> pageNo, Nullable<int> pageLength, ObjectParameter recordCount)
        {
            var strAccountNumberParameter = strAccountNumber != null ?
                new ObjectParameter("strAccountNumber", strAccountNumber) :
                new ObjectParameter("strAccountNumber", typeof(string));
    
            var pageNoParameter = pageNo.HasValue ?
                new ObjectParameter("pageNo", pageNo) :
                new ObjectParameter("pageNo", typeof(int));
    
            var pageLengthParameter = pageLength.HasValue ?
                new ObjectParameter("pageLength", pageLength) :
                new ObjectParameter("pageLength", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_GetSiteAccoutDetail_Result>("usp_GetSiteAccoutDetail", strAccountNumberParameter, pageNoParameter, pageLengthParameter, recordCount);
        }
    
        public virtual ObjectResult<usp_GetSiteLicenseUsageReport_Result> usp_GetSiteLicenseUsageReport(string sFromDate, string sToDate, string sAccoutNumber, Nullable<byte> iEditionId, Nullable<int> pageNo, Nullable<int> pageLength, ObjectParameter recordCount)
        {
            var sFromDateParameter = sFromDate != null ?
                new ObjectParameter("sFromDate", sFromDate) :
                new ObjectParameter("sFromDate", typeof(string));
    
            var sToDateParameter = sToDate != null ?
                new ObjectParameter("sToDate", sToDate) :
                new ObjectParameter("sToDate", typeof(string));
    
            var sAccoutNumberParameter = sAccoutNumber != null ?
                new ObjectParameter("sAccoutNumber", sAccoutNumber) :
                new ObjectParameter("sAccoutNumber", typeof(string));
    
            var iEditionIdParameter = iEditionId.HasValue ?
                new ObjectParameter("iEditionId", iEditionId) :
                new ObjectParameter("iEditionId", typeof(byte));
    
            var pageNoParameter = pageNo.HasValue ?
                new ObjectParameter("pageNo", pageNo) :
                new ObjectParameter("pageNo", typeof(int));
    
            var pageLengthParameter = pageLength.HasValue ?
                new ObjectParameter("pageLength", pageLength) :
                new ObjectParameter("pageLength", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_GetSiteLicenseUsageReport_Result>("usp_GetSiteLicenseUsageReport", sFromDateParameter, sToDateParameter, sAccoutNumberParameter, iEditionIdParameter, pageNoParameter, pageLengthParameter, recordCount);
        }
    
        public virtual ObjectResult<usp_GetSiteLicenseUsageReports_Result> usp_GetSiteLicenseUsageReports(string sFromDate, string sToDate, string sAccoutNumber, Nullable<byte> iEditionId, Nullable<int> pageNo, Nullable<int> pageLength, ObjectParameter recordCount)
        {
            var sFromDateParameter = sFromDate != null ?
                new ObjectParameter("sFromDate", sFromDate) :
                new ObjectParameter("sFromDate", typeof(string));
    
            var sToDateParameter = sToDate != null ?
                new ObjectParameter("sToDate", sToDate) :
                new ObjectParameter("sToDate", typeof(string));
    
            var sAccoutNumberParameter = sAccoutNumber != null ?
                new ObjectParameter("sAccoutNumber", sAccoutNumber) :
                new ObjectParameter("sAccoutNumber", typeof(string));
    
            var iEditionIdParameter = iEditionId.HasValue ?
                new ObjectParameter("iEditionId", iEditionId) :
                new ObjectParameter("iEditionId", typeof(byte));
    
            var pageNoParameter = pageNo.HasValue ?
                new ObjectParameter("pageNo", pageNo) :
                new ObjectParameter("pageNo", typeof(int));
    
            var pageLengthParameter = pageLength.HasValue ?
                new ObjectParameter("pageLength", pageLength) :
                new ObjectParameter("pageLength", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_GetSiteLicenseUsageReports_Result>("usp_GetSiteLicenseUsageReports", sFromDateParameter, sToDateParameter, sAccoutNumberParameter, iEditionIdParameter, pageNoParameter, pageLengthParameter, recordCount);
        }
    
        public virtual ObjectResult<usp_GetSubscribedLicenses_Result> usp_GetSubscribedLicenses(string sFromDate, string sToDate, Nullable<decimal> iStartPrice, Nullable<decimal> iEndPrice, Nullable<byte> iLicenseTypeId, Nullable<byte> iAccountTypeId, string sZip, Nullable<int> iStateId, Nullable<int> iCountryId, Nullable<int> pageNo, Nullable<int> pageLength, ObjectParameter recordCount)
        {
            var sFromDateParameter = sFromDate != null ?
                new ObjectParameter("sFromDate", sFromDate) :
                new ObjectParameter("sFromDate", typeof(string));
    
            var sToDateParameter = sToDate != null ?
                new ObjectParameter("sToDate", sToDate) :
                new ObjectParameter("sToDate", typeof(string));
    
            var iStartPriceParameter = iStartPrice.HasValue ?
                new ObjectParameter("iStartPrice", iStartPrice) :
                new ObjectParameter("iStartPrice", typeof(decimal));
    
            var iEndPriceParameter = iEndPrice.HasValue ?
                new ObjectParameter("iEndPrice", iEndPrice) :
                new ObjectParameter("iEndPrice", typeof(decimal));
    
            var iLicenseTypeIdParameter = iLicenseTypeId.HasValue ?
                new ObjectParameter("iLicenseTypeId", iLicenseTypeId) :
                new ObjectParameter("iLicenseTypeId", typeof(byte));
    
            var iAccountTypeIdParameter = iAccountTypeId.HasValue ?
                new ObjectParameter("iAccountTypeId", iAccountTypeId) :
                new ObjectParameter("iAccountTypeId", typeof(byte));
    
            var sZipParameter = sZip != null ?
                new ObjectParameter("sZip", sZip) :
                new ObjectParameter("sZip", typeof(string));
    
            var iStateIdParameter = iStateId.HasValue ?
                new ObjectParameter("iStateId", iStateId) :
                new ObjectParameter("iStateId", typeof(int));
    
            var iCountryIdParameter = iCountryId.HasValue ?
                new ObjectParameter("iCountryId", iCountryId) :
                new ObjectParameter("iCountryId", typeof(int));
    
            var pageNoParameter = pageNo.HasValue ?
                new ObjectParameter("pageNo", pageNo) :
                new ObjectParameter("pageNo", typeof(int));
    
            var pageLengthParameter = pageLength.HasValue ?
                new ObjectParameter("pageLength", pageLength) :
                new ObjectParameter("pageLength", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_GetSubscribedLicenses_Result>("usp_GetSubscribedLicenses", sFromDateParameter, sToDateParameter, iStartPriceParameter, iEndPriceParameter, iLicenseTypeIdParameter, iAccountTypeIdParameter, sZipParameter, iStateIdParameter, iCountryIdParameter, pageNoParameter, pageLengthParameter, recordCount);
        }
    
        public virtual ObjectResult<usp_GetUsageReport_Result> usp_GetUsageReport(string sFromDate, string sToDate, string sAccoutNumber, string sZip, Nullable<int> iState, Nullable<int> iCountry, Nullable<int> pageNo, Nullable<int> pageLength, ObjectParameter recordCount)
        {
            var sFromDateParameter = sFromDate != null ?
                new ObjectParameter("sFromDate", sFromDate) :
                new ObjectParameter("sFromDate", typeof(string));
    
            var sToDateParameter = sToDate != null ?
                new ObjectParameter("sToDate", sToDate) :
                new ObjectParameter("sToDate", typeof(string));
    
            var sAccoutNumberParameter = sAccoutNumber != null ?
                new ObjectParameter("sAccoutNumber", sAccoutNumber) :
                new ObjectParameter("sAccoutNumber", typeof(string));
    
            var sZipParameter = sZip != null ?
                new ObjectParameter("sZip", sZip) :
                new ObjectParameter("sZip", typeof(string));
    
            var iStateParameter = iState.HasValue ?
                new ObjectParameter("iState", iState) :
                new ObjectParameter("iState", typeof(int));
    
            var iCountryParameter = iCountry.HasValue ?
                new ObjectParameter("iCountry", iCountry) :
                new ObjectParameter("iCountry", typeof(int));
    
            var pageNoParameter = pageNo.HasValue ?
                new ObjectParameter("pageNo", pageNo) :
                new ObjectParameter("pageNo", typeof(int));
    
            var pageLengthParameter = pageLength.HasValue ?
                new ObjectParameter("pageLength", pageLength) :
                new ObjectParameter("pageLength", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_GetUsageReport_Result>("usp_GetUsageReport", sFromDateParameter, sToDateParameter, sAccoutNumberParameter, sZipParameter, iStateParameter, iCountryParameter, pageNoParameter, pageLengthParameter, recordCount);
        }
    
        public virtual ObjectResult<string> usp_GetUserList(string sFirstName, string sLastName, string sEmailId, string sAccoutNumber, Nullable<int> iUserTypeId, Nullable<int> iAccountTypeId, Nullable<int> iLoginUserType, Nullable<int> pageNo, Nullable<int> pageLength, ObjectParameter recordCount)
        {
            var sFirstNameParameter = sFirstName != null ?
                new ObjectParameter("sFirstName", sFirstName) :
                new ObjectParameter("sFirstName", typeof(string));
    
            var sLastNameParameter = sLastName != null ?
                new ObjectParameter("sLastName", sLastName) :
                new ObjectParameter("sLastName", typeof(string));
    
            var sEmailIdParameter = sEmailId != null ?
                new ObjectParameter("sEmailId", sEmailId) :
                new ObjectParameter("sEmailId", typeof(string));
    
            var sAccoutNumberParameter = sAccoutNumber != null ?
                new ObjectParameter("sAccoutNumber", sAccoutNumber) :
                new ObjectParameter("sAccoutNumber", typeof(string));
    
            var iUserTypeIdParameter = iUserTypeId.HasValue ?
                new ObjectParameter("iUserTypeId", iUserTypeId) :
                new ObjectParameter("iUserTypeId", typeof(int));
    
            var iAccountTypeIdParameter = iAccountTypeId.HasValue ?
                new ObjectParameter("iAccountTypeId", iAccountTypeId) :
                new ObjectParameter("iAccountTypeId", typeof(int));
    
            var iLoginUserTypeParameter = iLoginUserType.HasValue ?
                new ObjectParameter("iLoginUserType", iLoginUserType) :
                new ObjectParameter("iLoginUserType", typeof(int));
    
            var pageNoParameter = pageNo.HasValue ?
                new ObjectParameter("pageNo", pageNo) :
                new ObjectParameter("pageNo", typeof(int));
    
            var pageLengthParameter = pageLength.HasValue ?
                new ObjectParameter("pageLength", pageLength) :
                new ObjectParameter("pageLength", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("usp_GetUserList", sFirstNameParameter, sLastNameParameter, sEmailIdParameter, sAccoutNumberParameter, iUserTypeIdParameter, iAccountTypeIdParameter, iLoginUserTypeParameter, pageNoParameter, pageLengthParameter, recordCount);
        }
    
        public virtual ObjectResult<usp_GetUsersList_Result> usp_GetUsersList(string sFirstName, string sLastName, string sEmailId, string sAccoutNumber, Nullable<int> iUserTypeId, Nullable<int> iAccountTypeId, Nullable<int> iLoginUserType, Nullable<int> pageNo, Nullable<int> pageLength, ObjectParameter recordCount)
        {
            var sFirstNameParameter = sFirstName != null ?
                new ObjectParameter("sFirstName", sFirstName) :
                new ObjectParameter("sFirstName", typeof(string));
    
            var sLastNameParameter = sLastName != null ?
                new ObjectParameter("sLastName", sLastName) :
                new ObjectParameter("sLastName", typeof(string));
    
            var sEmailIdParameter = sEmailId != null ?
                new ObjectParameter("sEmailId", sEmailId) :
                new ObjectParameter("sEmailId", typeof(string));
    
            var sAccoutNumberParameter = sAccoutNumber != null ?
                new ObjectParameter("sAccoutNumber", sAccoutNumber) :
                new ObjectParameter("sAccoutNumber", typeof(string));
    
            var iUserTypeIdParameter = iUserTypeId.HasValue ?
                new ObjectParameter("iUserTypeId", iUserTypeId) :
                new ObjectParameter("iUserTypeId", typeof(int));
    
            var iAccountTypeIdParameter = iAccountTypeId.HasValue ?
                new ObjectParameter("iAccountTypeId", iAccountTypeId) :
                new ObjectParameter("iAccountTypeId", typeof(int));
    
            var iLoginUserTypeParameter = iLoginUserType.HasValue ?
                new ObjectParameter("iLoginUserType", iLoginUserType) :
                new ObjectParameter("iLoginUserType", typeof(int));
    
            var pageNoParameter = pageNo.HasValue ?
                new ObjectParameter("pageNo", pageNo) :
                new ObjectParameter("pageNo", typeof(int));
    
            var pageLengthParameter = pageLength.HasValue ?
                new ObjectParameter("pageLength", pageLength) :
                new ObjectParameter("pageLength", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_GetUsersList_Result>("usp_GetUsersList", sFirstNameParameter, sLastNameParameter, sEmailIdParameter, sAccoutNumberParameter, iUserTypeIdParameter, iAccountTypeIdParameter, iLoginUserTypeParameter, pageNoParameter, pageLengthParameter, recordCount);
        }
    
        public virtual ObjectResult<usp_GetUserTyeByAccountNumber_Result> usp_GetUserTyeByAccountNumber(Nullable<byte> iUserTypeId, Nullable<int> iLicenseId)
        {
            var iUserTypeIdParameter = iUserTypeId.HasValue ?
                new ObjectParameter("iUserTypeId", iUserTypeId) :
                new ObjectParameter("iUserTypeId", typeof(byte));
    
            var iLicenseIdParameter = iLicenseId.HasValue ?
                new ObjectParameter("iLicenseId", iLicenseId) :
                new ObjectParameter("iLicenseId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<usp_GetUserTyeByAccountNumber_Result>("usp_GetUserTyeByAccountNumber", iUserTypeIdParameter, iLicenseIdParameter);
        }
    
        public virtual ObjectResult<Nullable<short>> usp_GetWrongAttemptInADayForThisUser(Nullable<int> userId)
        {
            var userIdParameter = userId.HasValue ?
                new ObjectParameter("userId", userId) :
                new ObjectParameter("userId", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<short>>("usp_GetWrongAttemptInADayForThisUser", userIdParameter);
        }
    
        public virtual ObjectResult<string> usp_InsertNewDiscount(Nullable<decimal> dPercentage, string sStartDate, string sEndDate, string sDiscountCode)
        {
            var dPercentageParameter = dPercentage.HasValue ?
                new ObjectParameter("dPercentage", dPercentage) :
                new ObjectParameter("dPercentage", typeof(decimal));
    
            var sStartDateParameter = sStartDate != null ?
                new ObjectParameter("sStartDate", sStartDate) :
                new ObjectParameter("sStartDate", typeof(string));
    
            var sEndDateParameter = sEndDate != null ?
                new ObjectParameter("sEndDate", sEndDate) :
                new ObjectParameter("sEndDate", typeof(string));
    
            var sDiscountCodeParameter = sDiscountCode != null ?
                new ObjectParameter("sDiscountCode", sDiscountCode) :
                new ObjectParameter("sDiscountCode", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("usp_InsertNewDiscount", dPercentageParameter, sStartDateParameter, sEndDateParameter, sDiscountCodeParameter);
        }
    
        public virtual ObjectResult<string> usp_InsertNewLicenseAccount(string sAccountNumber, string sLicenseeFname, string sLicenseeLname, Nullable<byte> iLicenseTypeId, Nullable<byte> iAccountTypeId, string sInstitutionName, string sAddress1, string sAddress2, string sCity, string sZip, Nullable<int> iStateId, Nullable<int> iCountryId, string sPhone, string sEmailId, Nullable<int> iTotalLogins, string sStartDate, string sEndDate, string sMasterIP, string sEditionList, Nullable<decimal> iPrice, string sProductKey, string sSiteIPTo, string sSiteMasterIPTo, Nullable<int> iNoofImages)
        {
            var sAccountNumberParameter = sAccountNumber != null ?
                new ObjectParameter("sAccountNumber", sAccountNumber) :
                new ObjectParameter("sAccountNumber", typeof(string));
    
            var sLicenseeFnameParameter = sLicenseeFname != null ?
                new ObjectParameter("sLicenseeFname", sLicenseeFname) :
                new ObjectParameter("sLicenseeFname", typeof(string));
    
            var sLicenseeLnameParameter = sLicenseeLname != null ?
                new ObjectParameter("sLicenseeLname", sLicenseeLname) :
                new ObjectParameter("sLicenseeLname", typeof(string));
    
            var iLicenseTypeIdParameter = iLicenseTypeId.HasValue ?
                new ObjectParameter("iLicenseTypeId", iLicenseTypeId) :
                new ObjectParameter("iLicenseTypeId", typeof(byte));
    
            var iAccountTypeIdParameter = iAccountTypeId.HasValue ?
                new ObjectParameter("iAccountTypeId", iAccountTypeId) :
                new ObjectParameter("iAccountTypeId", typeof(byte));
    
            var sInstitutionNameParameter = sInstitutionName != null ?
                new ObjectParameter("sInstitutionName", sInstitutionName) :
                new ObjectParameter("sInstitutionName", typeof(string));
    
            var sAddress1Parameter = sAddress1 != null ?
                new ObjectParameter("sAddress1", sAddress1) :
                new ObjectParameter("sAddress1", typeof(string));
    
            var sAddress2Parameter = sAddress2 != null ?
                new ObjectParameter("sAddress2", sAddress2) :
                new ObjectParameter("sAddress2", typeof(string));
    
            var sCityParameter = sCity != null ?
                new ObjectParameter("sCity", sCity) :
                new ObjectParameter("sCity", typeof(string));
    
            var sZipParameter = sZip != null ?
                new ObjectParameter("sZip", sZip) :
                new ObjectParameter("sZip", typeof(string));
    
            var iStateIdParameter = iStateId.HasValue ?
                new ObjectParameter("iStateId", iStateId) :
                new ObjectParameter("iStateId", typeof(int));
    
            var iCountryIdParameter = iCountryId.HasValue ?
                new ObjectParameter("iCountryId", iCountryId) :
                new ObjectParameter("iCountryId", typeof(int));
    
            var sPhoneParameter = sPhone != null ?
                new ObjectParameter("sPhone", sPhone) :
                new ObjectParameter("sPhone", typeof(string));
    
            var sEmailIdParameter = sEmailId != null ?
                new ObjectParameter("sEmailId", sEmailId) :
                new ObjectParameter("sEmailId", typeof(string));
    
            var iTotalLoginsParameter = iTotalLogins.HasValue ?
                new ObjectParameter("iTotalLogins", iTotalLogins) :
                new ObjectParameter("iTotalLogins", typeof(int));
    
            var sStartDateParameter = sStartDate != null ?
                new ObjectParameter("sStartDate", sStartDate) :
                new ObjectParameter("sStartDate", typeof(string));
    
            var sEndDateParameter = sEndDate != null ?
                new ObjectParameter("sEndDate", sEndDate) :
                new ObjectParameter("sEndDate", typeof(string));
    
            var sMasterIPParameter = sMasterIP != null ?
                new ObjectParameter("sMasterIP", sMasterIP) :
                new ObjectParameter("sMasterIP", typeof(string));
    
            var sEditionListParameter = sEditionList != null ?
                new ObjectParameter("sEditionList", sEditionList) :
                new ObjectParameter("sEditionList", typeof(string));
    
            var iPriceParameter = iPrice.HasValue ?
                new ObjectParameter("iPrice", iPrice) :
                new ObjectParameter("iPrice", typeof(decimal));
    
            var sProductKeyParameter = sProductKey != null ?
                new ObjectParameter("sProductKey", sProductKey) :
                new ObjectParameter("sProductKey", typeof(string));
    
            var sSiteIPToParameter = sSiteIPTo != null ?
                new ObjectParameter("sSiteIPTo", sSiteIPTo) :
                new ObjectParameter("sSiteIPTo", typeof(string));
    
            var sSiteMasterIPToParameter = sSiteMasterIPTo != null ?
                new ObjectParameter("sSiteMasterIPTo", sSiteMasterIPTo) :
                new ObjectParameter("sSiteMasterIPTo", typeof(string));
    
            var iNoofImagesParameter = iNoofImages.HasValue ?
                new ObjectParameter("iNoofImages", iNoofImages) :
                new ObjectParameter("iNoofImages", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("usp_InsertNewLicenseAccount", sAccountNumberParameter, sLicenseeFnameParameter, sLicenseeLnameParameter, iLicenseTypeIdParameter, iAccountTypeIdParameter, sInstitutionNameParameter, sAddress1Parameter, sAddress2Parameter, sCityParameter, sZipParameter, iStateIdParameter, iCountryIdParameter, sPhoneParameter, sEmailIdParameter, iTotalLoginsParameter, sStartDateParameter, sEndDateParameter, sMasterIPParameter, sEditionListParameter, iPriceParameter, sProductKeyParameter, sSiteIPToParameter, sSiteMasterIPToParameter, iNoofImagesParameter);
        }
    
        public virtual ObjectResult<string> usp_InsertSingleLicenseAccount(string sAccountNumber, string sLicenseeFname, string sLicenseeLname, Nullable<byte> iAccountTypeId, string sInstitutionName, string sAddress1, string sAddress2, string sCity, string sZip, Nullable<int> iStateId, Nullable<int> iCountryId, string sPhone, string sEmailId, Nullable<int> iTotalLogins, string sStartDate, string sEndDate, string sEditionList, Nullable<decimal> iPrice, string sProductKey, string sLoginId, string sPassword, Nullable<byte> iSecurityQuesId, string sSecurityAnswer, Nullable<int> iCreatorId, Nullable<int> iNoofImages)
        {
            var sAccountNumberParameter = sAccountNumber != null ?
                new ObjectParameter("sAccountNumber", sAccountNumber) :
                new ObjectParameter("sAccountNumber", typeof(string));
    
            var sLicenseeFnameParameter = sLicenseeFname != null ?
                new ObjectParameter("sLicenseeFname", sLicenseeFname) :
                new ObjectParameter("sLicenseeFname", typeof(string));
    
            var sLicenseeLnameParameter = sLicenseeLname != null ?
                new ObjectParameter("sLicenseeLname", sLicenseeLname) :
                new ObjectParameter("sLicenseeLname", typeof(string));
    
            var iAccountTypeIdParameter = iAccountTypeId.HasValue ?
                new ObjectParameter("iAccountTypeId", iAccountTypeId) :
                new ObjectParameter("iAccountTypeId", typeof(byte));
    
            var sInstitutionNameParameter = sInstitutionName != null ?
                new ObjectParameter("sInstitutionName", sInstitutionName) :
                new ObjectParameter("sInstitutionName", typeof(string));
    
            var sAddress1Parameter = sAddress1 != null ?
                new ObjectParameter("sAddress1", sAddress1) :
                new ObjectParameter("sAddress1", typeof(string));
    
            var sAddress2Parameter = sAddress2 != null ?
                new ObjectParameter("sAddress2", sAddress2) :
                new ObjectParameter("sAddress2", typeof(string));
    
            var sCityParameter = sCity != null ?
                new ObjectParameter("sCity", sCity) :
                new ObjectParameter("sCity", typeof(string));
    
            var sZipParameter = sZip != null ?
                new ObjectParameter("sZip", sZip) :
                new ObjectParameter("sZip", typeof(string));
    
            var iStateIdParameter = iStateId.HasValue ?
                new ObjectParameter("iStateId", iStateId) :
                new ObjectParameter("iStateId", typeof(int));
    
            var iCountryIdParameter = iCountryId.HasValue ?
                new ObjectParameter("iCountryId", iCountryId) :
                new ObjectParameter("iCountryId", typeof(int));
    
            var sPhoneParameter = sPhone != null ?
                new ObjectParameter("sPhone", sPhone) :
                new ObjectParameter("sPhone", typeof(string));
    
            var sEmailIdParameter = sEmailId != null ?
                new ObjectParameter("sEmailId", sEmailId) :
                new ObjectParameter("sEmailId", typeof(string));
    
            var iTotalLoginsParameter = iTotalLogins.HasValue ?
                new ObjectParameter("iTotalLogins", iTotalLogins) :
                new ObjectParameter("iTotalLogins", typeof(int));
    
            var sStartDateParameter = sStartDate != null ?
                new ObjectParameter("sStartDate", sStartDate) :
                new ObjectParameter("sStartDate", typeof(string));
    
            var sEndDateParameter = sEndDate != null ?
                new ObjectParameter("sEndDate", sEndDate) :
                new ObjectParameter("sEndDate", typeof(string));
    
            var sEditionListParameter = sEditionList != null ?
                new ObjectParameter("sEditionList", sEditionList) :
                new ObjectParameter("sEditionList", typeof(string));
    
            var iPriceParameter = iPrice.HasValue ?
                new ObjectParameter("iPrice", iPrice) :
                new ObjectParameter("iPrice", typeof(decimal));
    
            var sProductKeyParameter = sProductKey != null ?
                new ObjectParameter("sProductKey", sProductKey) :
                new ObjectParameter("sProductKey", typeof(string));
    
            var sLoginIdParameter = sLoginId != null ?
                new ObjectParameter("sLoginId", sLoginId) :
                new ObjectParameter("sLoginId", typeof(string));
    
            var sPasswordParameter = sPassword != null ?
                new ObjectParameter("sPassword", sPassword) :
                new ObjectParameter("sPassword", typeof(string));
    
            var iSecurityQuesIdParameter = iSecurityQuesId.HasValue ?
                new ObjectParameter("iSecurityQuesId", iSecurityQuesId) :
                new ObjectParameter("iSecurityQuesId", typeof(byte));
    
            var sSecurityAnswerParameter = sSecurityAnswer != null ?
                new ObjectParameter("sSecurityAnswer", sSecurityAnswer) :
                new ObjectParameter("sSecurityAnswer", typeof(string));
    
            var iCreatorIdParameter = iCreatorId.HasValue ?
                new ObjectParameter("iCreatorId", iCreatorId) :
                new ObjectParameter("iCreatorId", typeof(int));
    
            var iNoofImagesParameter = iNoofImages.HasValue ?
                new ObjectParameter("iNoofImages", iNoofImages) :
                new ObjectParameter("iNoofImages", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("usp_InsertSingleLicenseAccount", sAccountNumberParameter, sLicenseeFnameParameter, sLicenseeLnameParameter, iAccountTypeIdParameter, sInstitutionNameParameter, sAddress1Parameter, sAddress2Parameter, sCityParameter, sZipParameter, iStateIdParameter, iCountryIdParameter, sPhoneParameter, sEmailIdParameter, iTotalLoginsParameter, sStartDateParameter, sEndDateParameter, sEditionListParameter, iPriceParameter, sProductKeyParameter, sLoginIdParameter, sPasswordParameter, iSecurityQuesIdParameter, sSecurityAnswerParameter, iCreatorIdParameter, iNoofImagesParameter);
        }
    
        public virtual ObjectResult<string> usp_InsertTestLicenseAccount(string sAccountNumber, string sLicenseeFname, string sLicenseeLname, string sLoginId, string sPassword, string sEmailId, Nullable<byte> iAccountTypeId, Nullable<byte> iEditionId, string sAddress, string sCity, string sZip, Nullable<int> iStateId, Nullable<int> iCountryId, string sPhone, string sStartDate, string sEndDate, Nullable<int> iCreatorId, Nullable<int> iNoofImages)
        {
            var sAccountNumberParameter = sAccountNumber != null ?
                new ObjectParameter("sAccountNumber", sAccountNumber) :
                new ObjectParameter("sAccountNumber", typeof(string));
    
            var sLicenseeFnameParameter = sLicenseeFname != null ?
                new ObjectParameter("sLicenseeFname", sLicenseeFname) :
                new ObjectParameter("sLicenseeFname", typeof(string));
    
            var sLicenseeLnameParameter = sLicenseeLname != null ?
                new ObjectParameter("sLicenseeLname", sLicenseeLname) :
                new ObjectParameter("sLicenseeLname", typeof(string));
    
            var sLoginIdParameter = sLoginId != null ?
                new ObjectParameter("sLoginId", sLoginId) :
                new ObjectParameter("sLoginId", typeof(string));
    
            var sPasswordParameter = sPassword != null ?
                new ObjectParameter("sPassword", sPassword) :
                new ObjectParameter("sPassword", typeof(string));
    
            var sEmailIdParameter = sEmailId != null ?
                new ObjectParameter("sEmailId", sEmailId) :
                new ObjectParameter("sEmailId", typeof(string));
    
            var iAccountTypeIdParameter = iAccountTypeId.HasValue ?
                new ObjectParameter("iAccountTypeId", iAccountTypeId) :
                new ObjectParameter("iAccountTypeId", typeof(byte));
    
            var iEditionIdParameter = iEditionId.HasValue ?
                new ObjectParameter("iEditionId", iEditionId) :
                new ObjectParameter("iEditionId", typeof(byte));
    
            var sAddressParameter = sAddress != null ?
                new ObjectParameter("sAddress", sAddress) :
                new ObjectParameter("sAddress", typeof(string));
    
            var sCityParameter = sCity != null ?
                new ObjectParameter("sCity", sCity) :
                new ObjectParameter("sCity", typeof(string));
    
            var sZipParameter = sZip != null ?
                new ObjectParameter("sZip", sZip) :
                new ObjectParameter("sZip", typeof(string));
    
            var iStateIdParameter = iStateId.HasValue ?
                new ObjectParameter("iStateId", iStateId) :
                new ObjectParameter("iStateId", typeof(int));
    
            var iCountryIdParameter = iCountryId.HasValue ?
                new ObjectParameter("iCountryId", iCountryId) :
                new ObjectParameter("iCountryId", typeof(int));
    
            var sPhoneParameter = sPhone != null ?
                new ObjectParameter("sPhone", sPhone) :
                new ObjectParameter("sPhone", typeof(string));
    
            var sStartDateParameter = sStartDate != null ?
                new ObjectParameter("sStartDate", sStartDate) :
                new ObjectParameter("sStartDate", typeof(string));
    
            var sEndDateParameter = sEndDate != null ?
                new ObjectParameter("sEndDate", sEndDate) :
                new ObjectParameter("sEndDate", typeof(string));
    
            var iCreatorIdParameter = iCreatorId.HasValue ?
                new ObjectParameter("iCreatorId", iCreatorId) :
                new ObjectParameter("iCreatorId", typeof(int));
    
            var iNoofImagesParameter = iNoofImages.HasValue ?
                new ObjectParameter("iNoofImages", iNoofImages) :
                new ObjectParameter("iNoofImages", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("usp_InsertTestLicenseAccount", sAccountNumberParameter, sLicenseeFnameParameter, sLicenseeLnameParameter, sLoginIdParameter, sPasswordParameter, sEmailIdParameter, iAccountTypeIdParameter, iEditionIdParameter, sAddressParameter, sCityParameter, sZipParameter, iStateIdParameter, iCountryIdParameter, sPhoneParameter, sStartDateParameter, sEndDateParameter, iCreatorIdParameter, iNoofImagesParameter);
        }
    
        public virtual int usp_UpdateAiaUserPassword(Nullable<int> id, string newPassword, ObjectParameter status)
        {
            var idParameter = id.HasValue ?
                new ObjectParameter("Id", id) :
                new ObjectParameter("Id", typeof(int));
    
            var newPasswordParameter = newPassword != null ?
                new ObjectParameter("NewPassword", newPassword) :
                new ObjectParameter("NewPassword", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("usp_UpdateAiaUserPassword", idParameter, newPasswordParameter, status);
        }
    
        public virtual ObjectResult<string> usp_UpdateDiscount(Nullable<int> iDiscountId, Nullable<decimal> dPercentage, string sStartDate, string sEndDate, Nullable<byte> iActive, string sDiscountCode)
        {
            var iDiscountIdParameter = iDiscountId.HasValue ?
                new ObjectParameter("iDiscountId", iDiscountId) :
                new ObjectParameter("iDiscountId", typeof(int));
    
            var dPercentageParameter = dPercentage.HasValue ?
                new ObjectParameter("dPercentage", dPercentage) :
                new ObjectParameter("dPercentage", typeof(decimal));
    
            var sStartDateParameter = sStartDate != null ?
                new ObjectParameter("sStartDate", sStartDate) :
                new ObjectParameter("sStartDate", typeof(string));
    
            var sEndDateParameter = sEndDate != null ?
                new ObjectParameter("sEndDate", sEndDate) :
                new ObjectParameter("sEndDate", typeof(string));
    
            var iActiveParameter = iActive.HasValue ?
                new ObjectParameter("iActive", iActive) :
                new ObjectParameter("iActive", typeof(byte));
    
            var sDiscountCodeParameter = sDiscountCode != null ?
                new ObjectParameter("sDiscountCode", sDiscountCode) :
                new ObjectParameter("sDiscountCode", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("usp_UpdateDiscount", iDiscountIdParameter, dPercentageParameter, sStartDateParameter, sEndDateParameter, iActiveParameter, sDiscountCodeParameter);
        }
    
        public virtual ObjectResult<string> usp_UpdateLicenseAccount(Nullable<int> iLicenseId, string sLicenseeFname, string sLicenseeLname, Nullable<byte> iLicenseTypeId, Nullable<byte> iAccountTypeId, string sInstitutionName, string sAddress1, string sAddress2, string sCity, string sZip, Nullable<int> iStateId, Nullable<int> iCountryId, string sPhone, string sEmailId, Nullable<byte> iIsActive, Nullable<int> iTotalLogins, Nullable<byte> iIsRennew, string sStartDate, string sEndDate, string sRenewDate, string sMasterIP, string sEditionList, Nullable<decimal> iPrice, string sProductKey, string sSiteIPTo, string sSiteMasterIPTo, Nullable<int> iNoofImages)
        {
            var iLicenseIdParameter = iLicenseId.HasValue ?
                new ObjectParameter("iLicenseId", iLicenseId) :
                new ObjectParameter("iLicenseId", typeof(int));
    
            var sLicenseeFnameParameter = sLicenseeFname != null ?
                new ObjectParameter("sLicenseeFname", sLicenseeFname) :
                new ObjectParameter("sLicenseeFname", typeof(string));
    
            var sLicenseeLnameParameter = sLicenseeLname != null ?
                new ObjectParameter("sLicenseeLname", sLicenseeLname) :
                new ObjectParameter("sLicenseeLname", typeof(string));
    
            var iLicenseTypeIdParameter = iLicenseTypeId.HasValue ?
                new ObjectParameter("iLicenseTypeId", iLicenseTypeId) :
                new ObjectParameter("iLicenseTypeId", typeof(byte));
    
            var iAccountTypeIdParameter = iAccountTypeId.HasValue ?
                new ObjectParameter("iAccountTypeId", iAccountTypeId) :
                new ObjectParameter("iAccountTypeId", typeof(byte));
    
            var sInstitutionNameParameter = sInstitutionName != null ?
                new ObjectParameter("sInstitutionName", sInstitutionName) :
                new ObjectParameter("sInstitutionName", typeof(string));
    
            var sAddress1Parameter = sAddress1 != null ?
                new ObjectParameter("sAddress1", sAddress1) :
                new ObjectParameter("sAddress1", typeof(string));
    
            var sAddress2Parameter = sAddress2 != null ?
                new ObjectParameter("sAddress2", sAddress2) :
                new ObjectParameter("sAddress2", typeof(string));
    
            var sCityParameter = sCity != null ?
                new ObjectParameter("sCity", sCity) :
                new ObjectParameter("sCity", typeof(string));
    
            var sZipParameter = sZip != null ?
                new ObjectParameter("sZip", sZip) :
                new ObjectParameter("sZip", typeof(string));
    
            var iStateIdParameter = iStateId.HasValue ?
                new ObjectParameter("iStateId", iStateId) :
                new ObjectParameter("iStateId", typeof(int));
    
            var iCountryIdParameter = iCountryId.HasValue ?
                new ObjectParameter("iCountryId", iCountryId) :
                new ObjectParameter("iCountryId", typeof(int));
    
            var sPhoneParameter = sPhone != null ?
                new ObjectParameter("sPhone", sPhone) :
                new ObjectParameter("sPhone", typeof(string));
    
            var sEmailIdParameter = sEmailId != null ?
                new ObjectParameter("sEmailId", sEmailId) :
                new ObjectParameter("sEmailId", typeof(string));
    
            var iIsActiveParameter = iIsActive.HasValue ?
                new ObjectParameter("iIsActive", iIsActive) :
                new ObjectParameter("iIsActive", typeof(byte));
    
            var iTotalLoginsParameter = iTotalLogins.HasValue ?
                new ObjectParameter("iTotalLogins", iTotalLogins) :
                new ObjectParameter("iTotalLogins", typeof(int));
    
            var iIsRennewParameter = iIsRennew.HasValue ?
                new ObjectParameter("iIsRennew", iIsRennew) :
                new ObjectParameter("iIsRennew", typeof(byte));
    
            var sStartDateParameter = sStartDate != null ?
                new ObjectParameter("sStartDate", sStartDate) :
                new ObjectParameter("sStartDate", typeof(string));
    
            var sEndDateParameter = sEndDate != null ?
                new ObjectParameter("sEndDate", sEndDate) :
                new ObjectParameter("sEndDate", typeof(string));
    
            var sRenewDateParameter = sRenewDate != null ?
                new ObjectParameter("sRenewDate", sRenewDate) :
                new ObjectParameter("sRenewDate", typeof(string));
    
            var sMasterIPParameter = sMasterIP != null ?
                new ObjectParameter("sMasterIP", sMasterIP) :
                new ObjectParameter("sMasterIP", typeof(string));
    
            var sEditionListParameter = sEditionList != null ?
                new ObjectParameter("sEditionList", sEditionList) :
                new ObjectParameter("sEditionList", typeof(string));
    
            var iPriceParameter = iPrice.HasValue ?
                new ObjectParameter("iPrice", iPrice) :
                new ObjectParameter("iPrice", typeof(decimal));
    
            var sProductKeyParameter = sProductKey != null ?
                new ObjectParameter("sProductKey", sProductKey) :
                new ObjectParameter("sProductKey", typeof(string));
    
            var sSiteIPToParameter = sSiteIPTo != null ?
                new ObjectParameter("sSiteIPTo", sSiteIPTo) :
                new ObjectParameter("sSiteIPTo", typeof(string));
    
            var sSiteMasterIPToParameter = sSiteMasterIPTo != null ?
                new ObjectParameter("sSiteMasterIPTo", sSiteMasterIPTo) :
                new ObjectParameter("sSiteMasterIPTo", typeof(string));
    
            var iNoofImagesParameter = iNoofImages.HasValue ?
                new ObjectParameter("iNoofImages", iNoofImages) :
                new ObjectParameter("iNoofImages", typeof(int));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("usp_UpdateLicenseAccount", iLicenseIdParameter, sLicenseeFnameParameter, sLicenseeLnameParameter, iLicenseTypeIdParameter, iAccountTypeIdParameter, sInstitutionNameParameter, sAddress1Parameter, sAddress2Parameter, sCityParameter, sZipParameter, iStateIdParameter, iCountryIdParameter, sPhoneParameter, sEmailIdParameter, iIsActiveParameter, iTotalLoginsParameter, iIsRennewParameter, sStartDateParameter, sEndDateParameter, sRenewDateParameter, sMasterIPParameter, sEditionListParameter, iPriceParameter, sProductKeyParameter, sSiteIPToParameter, sSiteMasterIPToParameter, iNoofImagesParameter);
        }
    
        public virtual int usp_UpdateUserProfile(Nullable<int> id, string firstName, string lastName, string emailId, ObjectParameter status)
        {
            var idParameter = id.HasValue ?
                new ObjectParameter("Id", id) :
                new ObjectParameter("Id", typeof(int));
    
            var firstNameParameter = firstName != null ?
                new ObjectParameter("FirstName", firstName) :
                new ObjectParameter("FirstName", typeof(string));
    
            var lastNameParameter = lastName != null ?
                new ObjectParameter("LastName", lastName) :
                new ObjectParameter("LastName", typeof(string));
    
            var emailIdParameter = emailId != null ?
                new ObjectParameter("EmailId", emailId) :
                new ObjectParameter("EmailId", typeof(string));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("usp_UpdateUserProfile", idParameter, firstNameParameter, lastNameParameter, emailIdParameter, status);
        }
    
        public virtual int usp_InsertAIAUser(string sLoginId, string sPassword, string sFirstname, string sLastname, Nullable<byte> iUserTypeId, string sEmailId, Nullable<byte> iSecurityQuesId, string sSecurityAnswer, Nullable<int> iCreatorId, Nullable<int> iLicenseId, Nullable<byte> iEditionId, ObjectParameter status)
        {
            var sLoginIdParameter = sLoginId != null ?
                new ObjectParameter("sLoginId", sLoginId) :
                new ObjectParameter("sLoginId", typeof(string));
    
            var sPasswordParameter = sPassword != null ?
                new ObjectParameter("sPassword", sPassword) :
                new ObjectParameter("sPassword", typeof(string));
    
            var sFirstnameParameter = sFirstname != null ?
                new ObjectParameter("sFirstname", sFirstname) :
                new ObjectParameter("sFirstname", typeof(string));
    
            var sLastnameParameter = sLastname != null ?
                new ObjectParameter("sLastname", sLastname) :
                new ObjectParameter("sLastname", typeof(string));
    
            var iUserTypeIdParameter = iUserTypeId.HasValue ?
                new ObjectParameter("iUserTypeId", iUserTypeId) :
                new ObjectParameter("iUserTypeId", typeof(byte));
    
            var sEmailIdParameter = sEmailId != null ?
                new ObjectParameter("sEmailId", sEmailId) :
                new ObjectParameter("sEmailId", typeof(string));
    
            var iSecurityQuesIdParameter = iSecurityQuesId.HasValue ?
                new ObjectParameter("iSecurityQuesId", iSecurityQuesId) :
                new ObjectParameter("iSecurityQuesId", typeof(byte));
    
            var sSecurityAnswerParameter = sSecurityAnswer != null ?
                new ObjectParameter("sSecurityAnswer", sSecurityAnswer) :
                new ObjectParameter("sSecurityAnswer", typeof(string));
    
            var iCreatorIdParameter = iCreatorId.HasValue ?
                new ObjectParameter("iCreatorId", iCreatorId) :
                new ObjectParameter("iCreatorId", typeof(int));
    
            var iLicenseIdParameter = iLicenseId.HasValue ?
                new ObjectParameter("iLicenseId", iLicenseId) :
                new ObjectParameter("iLicenseId", typeof(int));
    
            var iEditionIdParameter = iEditionId.HasValue ?
                new ObjectParameter("iEditionId", iEditionId) :
                new ObjectParameter("iEditionId", typeof(byte));
    
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("usp_InsertAIAUser", sLoginIdParameter, sPasswordParameter, sFirstnameParameter, sLastnameParameter, iUserTypeIdParameter, sEmailIdParameter, iSecurityQuesIdParameter, sSecurityAnswerParameter, iCreatorIdParameter, iLicenseIdParameter, iEditionIdParameter, status);
        }
    }
}