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();
}
}
