public Institute GetCourseInstituteById(int InstituteId, string DbName) { try { var sqlParameterd = _dbHelper.CreateSqlParameter("Id", InstituteId, DataType.AsInt); DataTable dt = _dbHelper.GetDataTable(DbName, "[Common].[Master_GetInstituteById]", sqlParameterd); return(new Institute { Id = Convert.ToInt32(dt.Rows[0]["Id"]), InstituteName = Convert.ToString(dt.Rows[0]["InstituteName"]), CountryId = Convert.ToInt32(dt.Rows[0]["CountryId"]), StateId = Convert.ToInt32(dt.Rows[0]["StateId"]), CityId = Convert.ToInt32(dt.Rows[0]["CityId"]), CreatedBy = Convert.ToInt32(dt.Rows[0]["CreatedBy"]), CreatedDate = Convert.ToString(dt.Rows[0]["CreatedDate"]), IsActive = Convert.ToBoolean(dt.Rows[0]["IsActive"]), IsBlacklist = Convert.ToBoolean(dt.Rows[0]["IsBlacklist"]) }); } catch (Exception ex) { var helper = new Helpers.ExceptionHelper.DataException(ex); throw helper.GetException(); } }
public List <CourseType> GetAllCourseType(string DbName) { try { return(_dbHelper.GetDataTableToList <CourseType>(DbName, "[Common].[Master_GetAllCourseType]")); } catch (Exception ex) { var helper = new Helpers.ExceptionHelper.DataException(ex); throw helper.GetException(); } }
public List <GlobalProfileModel> GetAllGlobalProfile(string DbName) { try { return(_dbHelper.GetDataTableToList <GlobalProfileModel>(DbName, "[Employee].[GetAllGlobalProfileDetails]")); } catch (Exception ex) { var helper = new Helpers.ExceptionHelper.DataException(ex); throw helper.GetException(); } }
public List <UserDefinedField> GetAllUserDefinedField(string DbName) { try { return(_dbHelper.GetDataTableToList <UserDefinedField>(DbName, "[Employee].[GetAllUserDefinedField]")); } catch (Exception ex) { var helper = new Helpers.ExceptionHelper.DataException(ex); throw helper.GetException(); } }
public List <GroupCompany> GetGroupCompany(GroupCompany model, string CompanyCode) { try { var parameters = new string[] { "TransType" }; var sqlParameterd = _dbHelper.CreateSqlParamByObj(model, parameters); return(_dbHelper.GetDataTableToList <GroupCompany>(CompanyCode, "[Company].[GroupCompanyDetails]", sqlParameterd)); } catch (Exception ex) { var helper = new Helpers.ExceptionHelper.DataException(ex); throw helper.GetException(); } }
public List <SecuritySettings> GetSecuritySettings(SecuritySettings model, string CompanyCode) { try { var parameters = new string[] { "TransType" }; var sqlParameterd = _dbHelper.CreateSqlParamByObj(model, parameters); return(_dbHelper.GetDataTableToList <SecuritySettings>(CompanyCode, "[Company].[SecuritySetting]", sqlParameterd)); } catch (Exception ex) { var helper = new Helpers.ExceptionHelper.DataException(ex); throw helper.GetException(); } }
public ApplicationResponse AddUpdateGroupCompany(GroupCompany model, string CompanyCode) { try { var parameters = new string[] { "TransType", "Id", "Name", "Code", "TypeId", "IncorporationDate", "Address", "CountryId", "StateId", "CityId", "PinCode", "ContcatNo", "WebSite", "PAN", "TAN", "GSTIN", "PF", "ESIC", "Logo", "CreatedBy", "ModifiedBy" }; var sqlParameterd = _dbHelper.CreateSqlParamByObj(model, parameters); DataTable dt = _dbHelper.GetDataTable(CompanyCode, "[Company].[GroupCompanyDetails]", sqlParameterd); return(new ApplicationResponse { Code = Convert.ToInt32(dt.Rows[0][0]), Message = Convert.ToString(dt.Rows[0][1]), }); } catch (Exception ex) { var helper = new Helpers.ExceptionHelper.DataException(ex); throw helper.GetException(); } }
public ApplicationResponse AddUpdateSecuritySettings(SecuritySettings model, string CompanyCode) { try { var parameters = new string[] { "TransType", "PasswordExpiryIndays", "SessionTimeOutInMins", "HideMobileNumberFromEd", "CreatedBy", "ModifiedBy" }; var sqlParameterd = _dbHelper.CreateSqlParamByObj(model, parameters); DataTable dt = _dbHelper.GetDataTable(CompanyCode, "[Company].[SecuritySetting]", sqlParameterd); return(new ApplicationResponse { Code = Convert.ToInt32(dt.Rows[0][0]), Message = Convert.ToString(dt.Rows[0][1]), }); } catch (Exception ex) { var helper = new Helpers.ExceptionHelper.DataException(ex); throw helper.GetException(); } }
public ApplicationResponse AddCourseTitle(CourseTitle model, string DbName) { try { var parameters = new string[] { "TitleName", "CourseTypeId", "IsActive", "CreatedBy" }; var sqlParameterd = _dbHelper.CreateSqlParamByObj(model, parameters); DataTable dt = _dbHelper.GetDataTable(DbName, "[Common].[Master_AddCourseTitle]", sqlParameterd); return(new ApplicationResponse { Code = Convert.ToInt32(dt.Rows[0][0]), Message = Convert.ToString(dt.Rows[0][1]), }); } catch (Exception ex) { var helper = new Helpers.ExceptionHelper.DataException(ex); throw helper.GetException(); } }
public ApplicationResponse UpdateCourseInstitute(Institute model, string DbName) { try { var parameters = new string[] { "Id", "InstituteName", "UniversityId", "CountryId", "StateId", "CityId", "IsBlacklist", "IsActive", "CreatedBy" }; var sqlParameterd = _dbHelper.CreateSqlParamByObj(model, parameters); DataTable dt = _dbHelper.GetDataTable(DbName, "[Common].[Master_EditInstitute]", sqlParameterd); return(new ApplicationResponse { Code = Convert.ToInt32(dt.Rows[0][0]), Message = Convert.ToString(dt.Rows[0][1]), }); } catch (Exception ex) { var helper = new Helpers.ExceptionHelper.DataException(ex); throw helper.GetException(); } }
public GlobalProfileModel GetGlobalProfileById(int id, string DbName) { try { var sqlParameterd = _dbHelper.CreateSqlParameter("Id", id, DataType.AsInt); DataTable dt = _dbHelper.GetDataTable(DbName, "[Employee].[GetGlobalProfileDetailsById]", sqlParameterd); return(new GlobalProfileModel { Id = Convert.ToInt32(dt.Rows[0]["Id"]), SectionName = Convert.ToString(dt.Rows[0]["SectionName"]), SectionCode = Convert.ToString(dt.Rows[0]["SectionCode"]), IsEnable = Convert.ToBoolean(dt.Rows[0]["IsEnable"]), CreatedBy = Convert.ToInt64(dt.Rows[0]["CreatedBy"]) }); } catch (Exception ex) { var helper = new Helpers.ExceptionHelper.DataException(ex); throw helper.GetException(); } }
public ApplicationResponse UpdateGlobalProfile(List <GlobalProfileModel> model, string DbName) { try { GlobalProfileXML obj = new GlobalProfileXML(); string globalprofilexml = XMLHelper.Serialize(model); obj.globalprofilexml = globalprofilexml; var parameters = new string[] { "globalprofilexml" }; var sqlParameterd = _dbHelper.CreateSqlParamByObj(obj, parameters); DataTable dt = _dbHelper.GetDataTable(DbName, "[Employee].[EditGlobalProfileDetails]", sqlParameterd); return(new ApplicationResponse { Code = Convert.ToInt32(dt.Rows[0][0]), Message = Convert.ToString(dt.Rows[0][1]), }); } catch (Exception ex) { var helper = new Helpers.ExceptionHelper.DataException(ex); throw helper.GetException(); } }
public ApplicationResponse AddUpdatePageSettings(PageSettings model, string CompanyCode) { try { var parameters = new string[] { "TransType", "LoginPageBackGroundImgOne", "LoginPageBackGroundImgTwo", "LoginPageBackGroundImgThree", "DashboardPageBackGroundImgOne", "DashboardPageBackGroundImgTwo", "DashboardPageBackGroundImgThree", "DashboardPageBackGroundImgFour", "DashboardPageBackGroundImgFive", "SlideShoutContent", "IsBirthdayVisible", "IsWorkAnniversaryVisible", "IsMarriageAnniversaryVisible", "IsExitVisible", "IsNewJoineeVisible", "CreatedBy", "ModifiedBy" }; var sqlParameterd = _dbHelper.CreateSqlParamByObj(model, parameters); DataTable dt = _dbHelper.GetDataTable(CompanyCode, "[Company].[PageSetting]", sqlParameterd); return(new ApplicationResponse { Code = Convert.ToInt32(dt.Rows[0][0]), Message = Convert.ToString(dt.Rows[0][1]), }); } catch (Exception ex) { var helper = new Helpers.ExceptionHelper.DataException(ex); throw helper.GetException(); } }
public Major GetCourseMajorById(int CourseMajorId, string DbName) { try { var sqlParameterd = _dbHelper.CreateSqlParameter("Id", CourseMajorId, DataType.AsInt); DataTable dt = _dbHelper.GetDataTable(DbName, "[Common].[Master_GetMajorById]", sqlParameterd); return(new Major { Id = Convert.ToInt32(dt.Rows[0]["Id"]), TitleName = Convert.ToString(dt.Rows[0]["TitleName"]), MajorName = Convert.ToString(dt.Rows[0]["MajorName"]), TitleId = Convert.ToInt32(dt.Rows[0]["TitleId"]), CreatedBy = Convert.ToInt32(dt.Rows[0]["CreatedBy"]), CreatedDate = Convert.ToString(dt.Rows[0]["CreatedDate"]), IsActive = Convert.ToBoolean(dt.Rows[0]["IsActive"]) }); } catch (Exception ex) { var helper = new Helpers.ExceptionHelper.DataException(ex); throw helper.GetException(); } }
public ApplicationResponse UpdateUserDefinedField(List <UserDefinedField> model, string DbName) { try { UserProfileXML obj = new UserProfileXML(); string userprofilexml = XMLHelper.Serialize(model); obj.userprofilexml = userprofilexml; var parameters = new string[] { "userprofilexml" }; var sqlParameterd = _dbHelper.CreateSqlParamByObj(obj, parameters); DataTable dt = _dbHelper.GetDataTable(DbName, "[Employee].[EditUserDefinedField]", sqlParameterd); return(new ApplicationResponse { Code = Convert.ToInt32(dt.Rows[0][0]), Message = Convert.ToString(dt.Rows[0][1]), }); } catch (Exception ex) { var helper = new Helpers.ExceptionHelper.DataException(ex); throw helper.GetException(); } }