public List <ApplicantRegistrationBO> getApplicantsList()
{
DataSet objDataSet = null;
ApplicantRegistrationBO objApplicantRegistrationBO = null;
List <ApplicantRegistrationBO> objApplicantRegistrationBOList = new List <ApplicantRegistrationBO>();
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
objDataSet = objDBAccess.execuitDataSet(ProcGetApplicantList, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables.Count > 0)
{
for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
{
objApplicantRegistrationBO = new ApplicantRegistrationBO();
objApplicantRegistrationBO.ApplicantId = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString());
objApplicantRegistrationBO.FirstName = objDataSet.Tables[0].Rows[i][1].ToString();
objApplicantRegistrationBO.EmailAddress = objDataSet.Tables[0].Rows[i][2].ToString();
objApplicantRegistrationBO.PhoneNumber = objDataSet.Tables[0].Rows[i][3].ToString();
objApplicantRegistrationBO.Address = objDataSet.Tables[0].Rows[i][4].ToString();
objApplicantRegistrationBOList.Add(objApplicantRegistrationBO);
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "getApplicantsList");
throw ex;
}
return(objApplicantRegistrationBOList);
}
public string deleteUser(int iUserId)
{
string strResult = "";
try
{
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
ProcParameterBO objDbParameter = null;
objDbParameter = new ProcParameterBO();
objDbParameter.Direction = ParameterDirection.Input;
objDbParameter.ParameterName = "@iUserId";
objDbParameter.dbType = DbType.Int32;
objDbParameter.ParameterValue = iUserId;
objProcParameterBOList.Add(objDbParameter);
objDBAccess.executeNonQuery(ProcDeleteUser, ref objProcParameterBOList);
strResult = "DELETED";
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "deleteUser");
strResult = "FAILED";
throw ex;
}
return(strResult);
}
public string GetPasswordData(string strEmailAddress, string strPassword)
{
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
ProcParameterBO objDbParameter = null;
string strResult = "";
try
{
objDbParameter = new ProcParameterBO();
objDbParameter.Direction = ParameterDirection.Input;
objDbParameter.ParameterName = "@strEmailAddress";
objDbParameter.dbType = DbType.String;
objDbParameter.ParameterValue = strEmailAddress;
objProcParameterBOList.Add(objDbParameter);
objDbParameter = new ProcParameterBO();
objDbParameter.Direction = ParameterDirection.Input;
objDbParameter.ParameterName = "@strPassword";
objDbParameter.dbType = DbType.String;
objDbParameter.ParameterValue = strPassword;
objProcParameterBOList.Add(objDbParameter);
strResult = objDBAccess.executeScalar(ProcGetPasswordData, ref objProcParameterBOList).ToString();
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "GetPasswordData");
strResult = "FAILED";
throw ex;
}
return(strResult);
}
public string CheckApplicantExist(int iApplicantId)
{
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
ProcParameterBO objDbParameter = null;
string strResult = "";
try
{
objDbParameter = new ProcParameterBO();
objDbParameter.Direction = ParameterDirection.Input;
objDbParameter.ParameterName = "@iApplicantId";
objDbParameter.dbType = DbType.Int32;
objDbParameter.ParameterValue = iApplicantId;
objProcParameterBOList.Add(objDbParameter);
strResult = objDBAccess.executeScalar(ProcGetCheckApplicantExist, ref objProcParameterBOList).ToString();
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "CheckApplicantExist");
strResult = "FAILED";
throw ex;
}
return(strResult);
}
public List <CommonDropDownBO> CountriesList()
{
DataSet objDataSet = null;
CommonDropDownBO objCommonDropDownBO = null;
List <CommonDropDownBO> objCommonDropDownBOList = new List <CommonDropDownBO>();
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
objDataSet = objDBAccess.execuitDataSet(ProcCountriesList, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables.Count > 0)
{
for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
{
objCommonDropDownBO = new CommonDropDownBO();
objCommonDropDownBO.Id = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString());
objCommonDropDownBO.Value = objDataSet.Tables[0].Rows[i][1].ToString();
objCommonDropDownBOList.Add(objCommonDropDownBO);
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "CountriesList");
throw ex;
}
return(objCommonDropDownBOList);
}
public ChangePassWordBO GetEmailAddress(int iUserId)
{
DataSet objDataSet = null;
ChangePassWordBO objChangePassWordBO = null;
List <ProcParameterBO> objListProcParameterBo = new List <ProcParameterBO>();
try
{
ProcParameterBO objDbParameter = new ProcParameterBO();
objDbParameter.Direction = ParameterDirection.Input;
objDbParameter.ParameterName = "@iUserId";
objDbParameter.dbType = DbType.Int32;
objDbParameter.ParameterValue = iUserId;
objListProcParameterBo.Add(objDbParameter);
objDataSet = objDBAccess.execuitDataSet(ProcGetEmailAddress, ref objListProcParameterBo);
if (objDataSet != null && objDataSet.Tables[0].Rows.Count > 0)
{
objChangePassWordBO = new ChangePassWordBO();
objChangePassWordBO.UserId = Convert.ToInt32(objDataSet.Tables[0].Rows[0][0].ToString());
objChangePassWordBO.EmailAddress = objDataSet.Tables[0].Rows[0][1].ToString();
}
}
catch (Exception EX)
{
ExceptionError.Error_Log(EX, "GetEmailAddress");
throw EX;
}
return(objChangePassWordBO);
}
public List <MenuMasterBO> getMenuList()
{
DataSet objDataSet = null;
MenuMasterBO objMenuMasterBO = null;
List <MenuMasterBO> objMenuMasterBOList = new List <MenuMasterBO>();
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
objDataSet = objDbAcess.execuitDataSet(ProcGetMenuList, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables.Count > 0)
{
for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
{
objMenuMasterBO = new MenuMasterBO();
objMenuMasterBO.MenuId = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString());
objMenuMasterBO.MenuName = objDataSet.Tables[0].Rows[i][1].ToString();
objMenuMasterBO.DisplayOrder = Convert.ToInt32(objDataSet.Tables[0].Rows[i][2].ToString());
objMenuMasterBO.MenuKey = objDataSet.Tables[0].Rows[i][3].ToString();
objMenuMasterBO.IsActive = Convert.ToBoolean(objDataSet.Tables[0].Rows[i][4].ToString());
objMenuMasterBO.CreatedOn = objDataSet.Tables[0].Rows[i][5].ToString();
objMenuMasterBOList.Add(objMenuMasterBO);
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "getMenuList");
throw ex;
}
return(objMenuMasterBOList);
}
public List <BranchMasterBO> selectBranchList()
{
DataSet objDataSet = null;
BranchMasterBO objBranchMasterBO = null;
List <BranchMasterBO> objListBranchMasterBO = new List <BranchMasterBO>();
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
objDataSet = objDBAccess.execuitDataSet(ProcselectBranchList, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables.Count > 0)
{
for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
{
objBranchMasterBO = new BranchMasterBO();
objBranchMasterBO.BranchId = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString());
objBranchMasterBO.OrganizationName = objDataSet.Tables[0].Rows[i][1].ToString();
objBranchMasterBO.BranchName = objDataSet.Tables[0].Rows[i][2].ToString();
objBranchMasterBO.Details = objDataSet.Tables[0].Rows[i][3].ToString();
objBranchMasterBO.Address = objDataSet.Tables[0].Rows[i][4].ToString();
objBranchMasterBO.CellNumber = objDataSet.Tables[0].Rows[i][5].ToString();
objBranchMasterBO.LandNumber = objDataSet.Tables[0].Rows[i][6].ToString();
objBranchMasterBO.EmailId = objDataSet.Tables[0].Rows[i][7].ToString();
objBranchMasterBO.Website = objDataSet.Tables[0].Rows[i][8].ToString();
objListBranchMasterBO.Add(objBranchMasterBO);
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "selectBranchList");
throw ex;
}
return(objListBranchMasterBO);
}
public List <JobsReportBO> getApprovedJobsReportList()
{
DataSet objDataSet = null;
JobsReportBO objJobsReportBO = null;
List <JobsReportBO> objJobsReportBOList = new List <JobsReportBO>();
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
objDataSet = objDBAccess.execuitDataSet(ProcGetApprovedJobsReportList, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables.Count > 0)
{
for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
{
objJobsReportBO = new JobsReportBO();
objJobsReportBO.JobName = objDataSet.Tables[0].Rows[i][0].ToString();
objJobsReportBO.JobDescription = objDataSet.Tables[0].Rows[i][1].ToString();
objJobsReportBO.NoOfPositions = objDataSet.Tables[0].Rows[i][2].ToString();
objJobsReportBO.JobLocation = objDataSet.Tables[0].Rows[i][3].ToString();
objJobsReportBO.DonorProgramName = objDataSet.Tables[0].Rows[i][4].ToString();
objJobsReportBO.RequiredStaffLevel = objDataSet.Tables[0].Rows[i][5].ToString();
objJobsReportBO.CurrentStaffLevel = objDataSet.Tables[0].Rows[i][6].ToString();
objJobsReportBO.Gaps = objDataSet.Tables[0].Rows[i][7].ToString();
objJobsReportBO.Status = objDataSet.Tables[0].Rows[i][8].ToString();
objJobsReportBOList.Add(objJobsReportBO);
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "getApprovedJobsReportList");
throw ex;
}
return(objJobsReportBOList);
}
public List <ApprovedJobsListBO> getApprovedJobsList()
{
DataSet objDataSet = null;
ApprovedJobsListBO objApprovedJobsListBO = null;
List <ApprovedJobsListBO> objApprovedJobsBOList = new List <ApprovedJobsListBO>();
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
objDataSet = objDBAccess.execuitDataSet(ProcGetApprovedJobsList, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables.Count > 0)
{
for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
{
objApprovedJobsListBO = new ApprovedJobsListBO();
objApprovedJobsListBO.JobName = objDataSet.Tables[0].Rows[i][0].ToString();
objApprovedJobsListBO.JobDescription = objDataSet.Tables[0].Rows[i][1].ToString();
objApprovedJobsListBO.JobLocation = objDataSet.Tables[0].Rows[i][2].ToString();
objApprovedJobsListBO.NoOfPositions = Convert.ToInt32(objDataSet.Tables[0].Rows[i][3].ToString());
objApprovedJobsListBO.ApprovedDate = objDataSet.Tables[0].Rows[i][4].ToString();
objApprovedJobsListBO.Status = objDataSet.Tables[0].Rows[i][5].ToString();
objApprovedJobsListBO.Comments = objDataSet.Tables[0].Rows[i][6].ToString();
objApprovedJobsBOList.Add(objApprovedJobsListBO);
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "getApprovedJobsList");
throw ex;
}
return(objApprovedJobsBOList);
}
public IdTypeMasterBO EditIdTypeMaster(int iIdTypeMasterId)
{
DataSet objDataSet = null;
IdTypeMasterBO objIdTypeMasterBO = null;
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
ProcParameterBO objDbParameter = new ProcParameterBO();
objDbParameter.Direction = ParameterDirection.Input;
objDbParameter.ParameterName = "@iIdTypeMasterId";
objDbParameter.dbType = DbType.Int32;
objDbParameter.ParameterValue = iIdTypeMasterId;
objProcParameterBOList.Add(objDbParameter);
objDataSet = objDBAccess.execuitDataSet(ProcEditIdTypeMaster, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables[0].Rows.Count > 0)
{
objIdTypeMasterBO = new IdTypeMasterBO();
objIdTypeMasterBO.IdTypeMasterId = Convert.ToInt32(objDataSet.Tables[0].Rows[0][0].ToString());
objIdTypeMasterBO.IdType = objDataSet.Tables[0].Rows[0][1].ToString();
objIdTypeMasterBO.IsActive = Convert.ToBoolean(objDataSet.Tables[0].Rows[0][2].ToString());
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "EditIdTypeMaster");
throw ex;
}
return(objIdTypeMasterBO);
}
public List <UserRegistrationBO> getUsersList()
{
DataSet objDataSet = null;
UserRegistrationBO objUserRegistrationBO = null;
List <UserRegistrationBO> objUserRegistrationBOList = new List <UserRegistrationBO>();
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
objDataSet = objDBAccess.execuitDataSet(ProcGetUsersList, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables.Count > 0)
{
for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
{
objUserRegistrationBO = new UserRegistrationBO();
objUserRegistrationBO.UserId = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString());
objUserRegistrationBO.FirstName = objDataSet.Tables[0].Rows[i][1].ToString();
objUserRegistrationBO.LastName = objDataSet.Tables[0].Rows[i][2].ToString();
objUserRegistrationBO.EmailAddress = objDataSet.Tables[0].Rows[i][3].ToString();
objUserRegistrationBO.MobileNumber = objDataSet.Tables[0].Rows[i][4].ToString();
objUserRegistrationBO.Department = objDataSet.Tables[0].Rows[i][5].ToString();
objUserRegistrationBO.City = objDataSet.Tables[0].Rows[i][6].ToString();
objUserRegistrationBO.IsActive = Convert.ToBoolean(objDataSet.Tables[0].Rows[i][7].ToString());
objUserRegistrationBOList.Add(objUserRegistrationBO);
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "getUsersList");
throw ex;
}
return(objUserRegistrationBOList);
}
public List <IdTypeMasterBO> GetIdTypeMasterList()
{
DataSet objDataSet = null;
IdTypeMasterBO objIdTypeMasterBO = null;
List <IdTypeMasterBO> objIdTypeMasterBOList = new List <IdTypeMasterBO>();
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
objDataSet = objDBAccess.execuitDataSet(ProcGetIdTypeMasterList, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables.Count > 0)
{
for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
{
objIdTypeMasterBO = new IdTypeMasterBO();
objIdTypeMasterBO.IdTypeMasterId = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString());
objIdTypeMasterBO.IdType = objDataSet.Tables[0].Rows[i][1].ToString();
objIdTypeMasterBO.IsActive = Convert.ToBoolean(objDataSet.Tables[0].Rows[i][2].ToString());
objIdTypeMasterBOList.Add(objIdTypeMasterBO);
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "GetIdTypeMasterList");
throw ex;
}
return(objIdTypeMasterBOList);
}
public List <OrganizationMasterBO> selectOrganisationList()
{
DataSet objDataSet = null;
OrganizationMasterBO objOrganizationMasterBO = null;
List <OrganizationMasterBO> objListOrganizationMasterBO = new List <OrganizationMasterBO>();
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
objDataSet = objDBAccess.execuitDataSet(ProcselectOrganizationList, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables.Count > 0)
{
for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
{
objOrganizationMasterBO = new OrganizationMasterBO();
objOrganizationMasterBO.OrganisationId = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString());
objOrganizationMasterBO.OrganisationName = objDataSet.Tables[0].Rows[i][1].ToString();
objOrganizationMasterBO.IsActive = Convert.ToBoolean(objDataSet.Tables[0].Rows[0][3].ToString());
objListOrganizationMasterBO.Add(objOrganizationMasterBO);
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "selectOrganisationList");
throw ex;
}
return(objListOrganizationMasterBO);
}
public List <HRInteractionBO> getHRInteractionList()
{
DataSet objDataSet = null;
HRInteractionBO objHRInteractionBO = null;
List <HRInteractionBO> objHRInteractionBOList = new List <HRInteractionBO>();
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
objDataSet = objDBAccess.execuitDataSet(ProcHRInteractionList, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables.Count > 0)
{
for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
{
objHRInteractionBO = new HRInteractionBO();
objHRInteractionBO.RequestId = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString());
objHRInteractionBO.ApplicantName = objDataSet.Tables[0].Rows[i][1].ToString();
objHRInteractionBO.Subject = objDataSet.Tables[0].Rows[i][2].ToString();
objHRInteractionBO.RequestDate = objDataSet.Tables[0].Rows[i][3].ToString();
objHRInteractionBO.ResponseDate = objDataSet.Tables[0].Rows[i][4].ToString();
objHRInteractionBO.Status = objDataSet.Tables[0].Rows[i][5].ToString();
objHRInteractionBO.Comments = objDataSet.Tables[0].Rows[i][6].ToString();
objHRInteractionBOList.Add(objHRInteractionBO);
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "getHRInteractionList");
throw ex;
}
return(objHRInteractionBOList);
}
public List <CommonDropDownBO> getDonorProgramList(int iUserId)
{
DataSet objDataSet = null;
CommonDropDownBO objCommonDropDownBO = null;
List <CommonDropDownBO> objCommonDropDownBOList = new List <CommonDropDownBO>();
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
ProcParameterBO objParameterBO = new ProcParameterBO();
objParameterBO.Direction = ParameterDirection.Input;
objParameterBO.ParameterName = "@iUserId";
objParameterBO.dbType = DbType.Int32;
objParameterBO.ParameterValue = iUserId;
objProcParameterBOList.Add(objParameterBO);
objDataSet = objDBAccess.execuitDataSet(ProcDonorDropDown, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables.Count > 0)
{
for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
{
objCommonDropDownBO = new CommonDropDownBO();
objCommonDropDownBO.Id = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString());
objCommonDropDownBO.Value = objDataSet.Tables[0].Rows[i][1].ToString();
objCommonDropDownBOList.Add(objCommonDropDownBO);
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "getDonorProgramList");
throw ex;
}
return(objCommonDropDownBOList);
}
public List <string> getHRofficeUsersList()
{
DataSet objDataSet = null;
string strEmailAddress = "";
List <string> objUsersList = new List <string>();
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
objDataSet = objDBAccess.execuitDataSet(ProcGetHRofficeUsersList, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
{
strEmailAddress = objDataSet.Tables[0].Rows[i][0].ToString();
objUsersList.Add(strEmailAddress);
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "getHRofficeUsersList");
throw ex;
}
return(objUsersList);
}
public UserRegistrationBO EditUserDetails(int iUserId)
{
DataSet objDataSet = null;
UserRegistrationBO objUserRegistrationBO = null;
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
ProcParameterBO objDbParameter = new ProcParameterBO();
objDbParameter.Direction = ParameterDirection.Input;
objDbParameter.ParameterName = "@iuserId";
objDbParameter.dbType = DbType.Int32;
objDbParameter.ParameterValue = iUserId;
objProcParameterBOList.Add(objDbParameter);
objDataSet = objDBAccess.execuitDataSet(ProcEditUser, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables[0].Rows.Count > 0)
{
objUserRegistrationBO = new UserRegistrationBO();
objUserRegistrationBO.UserId = Convert.ToInt32(objDataSet.Tables[0].Rows[0][0].ToString());
objUserRegistrationBO.FirstName = objDataSet.Tables[0].Rows[0][1].ToString();
objUserRegistrationBO.MiddleName = objDataSet.Tables[0].Rows[0][2].ToString();
objUserRegistrationBO.LastName = objDataSet.Tables[0].Rows[0][3].ToString();
objUserRegistrationBO.Photo = objDataSet.Tables[0].Rows[0][4].ToString();
objUserRegistrationBO.Password = objDataSet.Tables[0].Rows[0][5].ToString();
//objUserRegistrationBO.ConfirmPassword = objDataSet.Tables[0].Rows[0][6].ToString();
objUserRegistrationBO.Gender = objDataSet.Tables[0].Rows[0][6].ToString();
objUserRegistrationBO.MobileNumber = objDataSet.Tables[0].Rows[0][7].ToString();
objUserRegistrationBO.AlternateMobileNumber = objDataSet.Tables[0].Rows[0][8].ToString();
objUserRegistrationBO.EmailAddress = objDataSet.Tables[0].Rows[0][9].ToString();
objUserRegistrationBO.Language = objDataSet.Tables[0].Rows[0][10].ToString();
objUserRegistrationBO.Qualification = objDataSet.Tables[0].Rows[0][11].ToString();
objUserRegistrationBO.College = objDataSet.Tables[0].Rows[0][12].ToString();
objUserRegistrationBO.University = objDataSet.Tables[0].Rows[0][13].ToString();
objUserRegistrationBO.AggregatePercentage = objDataSet.Tables[0].Rows[0][14].ToString();
objUserRegistrationBO.JoiningDate = objDataSet.Tables[0].Rows[0][15].ToString();
objUserRegistrationBO.CountryId = Convert.ToInt32(objDataSet.Tables[0].Rows[0][16].ToString());
objUserRegistrationBO.StateId = Convert.ToInt32(objDataSet.Tables[0].Rows[0][17].ToString());
objUserRegistrationBO.City = objDataSet.Tables[0].Rows[0][18].ToString();
objUserRegistrationBO.UserType = objDataSet.Tables[0].Rows[0][19].ToString();
objUserRegistrationBO.UserRole = objDataSet.Tables[0].Rows[0][20].ToString();
objUserRegistrationBO.DonorProgram = objDataSet.Tables[0].Rows[0][21].ToString();
objUserRegistrationBO.Department = objDataSet.Tables[0].Rows[0][22].ToString();
objUserRegistrationBO.Address = objDataSet.Tables[0].Rows[0][23].ToString();
objUserRegistrationBO.IsActive = Convert.ToBoolean(objDataSet.Tables[0].Rows[0][24].ToString());
objUserRegistrationBO.DateOfBirth = objDataSet.Tables[0].Rows[0][25].ToString();
objUserRegistrationBO.FileSavedName = objDataSet.Tables[0].Rows[0][26].ToString();
objUserRegistrationBO.LocationId = Convert.ToInt32(objDataSet.Tables[0].Rows[0][27].ToString());
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "EditUserDetails");
throw ex;
}
return(objUserRegistrationBO);
}
public string SaveJobMarketing(JobMarketingBO objJobMarketingBO, int iUserId)
{
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
ProcParameterBO objDBparameter = null;
string strResult = "";
try
{
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@iJobPostingId";
objDBparameter.dbType = DbType.Int32;
objDBparameter.ParameterValue = objJobMarketingBO.JobPostingId;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strMarket_Comments";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objJobMarketingBO.MarketingComments;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@iUserId";
objDBparameter.dbType = DbType.Int32;
objDBparameter.ParameterValue = iUserId;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Output;
objDBparameter.ParameterName = "@strResult";
objDBparameter.dbType = DbType.String;
objDBparameter.Size = 100;
objProcParameterBOList.Add(objDBparameter);
objDBAccess.executeNonQuery(ProcsaveJobMarketing, ref objProcParameterBOList);
for (int i = 0; i < objProcParameterBOList.Count; i++)
{
if (objProcParameterBOList[i].Direction == ParameterDirection.Output)
{
strResult = objProcParameterBOList[i].ParameterValue.ToString();
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "SaveJobMarketing");
strResult = "FAILED";
throw ex;
}
return(strResult);
}
public string SaveorUpdateApplicantRegisterEmail(EmailAddressBO objEmailAddressBO, string strPassword, int iUserId)
{
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
ProcParameterBO objDBparameter = null;
string strResult = "";
try
{
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strPassword";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = strPassword;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@iApplicantId";
objDBparameter.dbType = DbType.Int32;
objDBparameter.ParameterValue = objEmailAddressBO.ApplicantId;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strEmailAddress";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objEmailAddressBO.EmailAddress;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Output;
objDBparameter.ParameterName = "@strResult";
objDBparameter.dbType = DbType.String;
objDBparameter.Size = 100;
objProcParameterBOList.Add(objDBparameter);
objDBAccess.executeNonQuery(ProcSaveApplicantRegisterEmail, ref objProcParameterBOList);
for (int i = 0; i < objProcParameterBOList.Count; i++)
{
if (objProcParameterBOList[i].Direction == ParameterDirection.Output)
{
strResult = objProcParameterBOList[i].ParameterValue.ToString();
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "SaveorUpdateApplicantRegisterEmail");
strResult = "FAILED";
throw ex;
}
return(strResult);
}
public List <MainMenuBO> getUserMenuList(int iUserId)
{
DataSet objDataset = null;
MainMenuBO objMainMenuBO = null;
List <ProcParameterBO> objListProcParameterBO = new List <ProcParameterBO>();
List <MainMenuBO> objMainMenuListBo = new List <MainMenuBO>();
try
{
ProcParameterBO objProcParameterBo = new ProcParameterBO();
objProcParameterBo.Direction = ParameterDirection.Input;
objProcParameterBo.ParameterName = "@iUserId";
objProcParameterBo.dbType = DbType.Int32;
objProcParameterBo.ParameterValue = iUserId;
objListProcParameterBO.Add(objProcParameterBo);
objDataset = objDBAccess.execuitDataSet(ProcGetMenuDetails, ref objListProcParameterBO);
if (objDataset != null && objDataset.Tables.Count > 0)
{
for (int i = 0; i < objDataset.Tables[0].Rows.Count; i++)
{
objMainMenuBO = new MainMenuBO();
objMainMenuBO.MenuId = Convert.ToInt32(objDataset.Tables[0].Rows[i][0].ToString());
objMainMenuBO.MenuName = objDataset.Tables[0].Rows[i][1].ToString();
objMainMenuBO.ParentMenuId = Convert.ToInt32(objDataset.Tables[0].Rows[i][2].ToString());
objMainMenuBO.DisplayOrder = Convert.ToInt32(objDataset.Tables[0].Rows[i][3].ToString());
objMainMenuBO.faIcon = objDataset.Tables[0].Rows[i][4].ToString();
objMainMenuBO.ImageURL = objDataset.Tables[0].Rows[i][5].ToString();
objMainMenuBO.HelpURL = objDataset.Tables[0].Rows[i][6].ToString();
objMainMenuBO.HelpDocURL = objDataset.Tables[0].Rows[i][7].ToString();
objMainMenuBO.MenuGroupId = Convert.ToInt32(objDataset.Tables[0].Rows[i][8].ToString());
objMainMenuBO.LocalDocument = objDataset.Tables[0].Rows[i][9].ToString();
objMainMenuBO.LocalVideo = objDataset.Tables[0].Rows[i][10].ToString();
objMainMenuBO.MenuKey = objDataset.Tables[0].Rows[i][11].ToString();
objMainMenuBO.PageURL = objDataset.Tables[0].Rows[i][12].ToString();
objMainMenuListBo.Add(objMainMenuBO);
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "getUserMenuList");
throw ex;
}
return(objMainMenuListBo);
}
public AllJobsBO EditPMGrid(int iJobPostingId)
{
DataSet objDataSet = null;
AllJobsBO objAllJobsBO = null;
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
ProcParameterBO objDbParameter = new ProcParameterBO();
objDbParameter.Direction = ParameterDirection.Input;
objDbParameter.ParameterName = "@iJobPostingId";
objDbParameter.dbType = DbType.Int32;
objDbParameter.ParameterValue = iJobPostingId;
objProcParameterBOList.Add(objDbParameter);
objDataSet = objDBAccess.execuitDataSet(ProcEditPMJob, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables[0].Rows.Count > 0)
{
objAllJobsBO = new AllJobsBO();
objAllJobsBO.JobPostingId = Convert.ToInt32(objDataSet.Tables[0].Rows[0][0].ToString());
objAllJobsBO.JobName = objDataSet.Tables[0].Rows[0][1].ToString();
objAllJobsBO.JobCode = objDataSet.Tables[0].Rows[0][2].ToString();
objAllJobsBO.JobDescription = objDataSet.Tables[0].Rows[0][3].ToString();
objAllJobsBO.NoOfPositions = objDataSet.Tables[0].Rows[0][4].ToString();
objAllJobsBO.JobLocation = objDataSet.Tables[0].Rows[0][5].ToString();
objAllJobsBO.JobTimings = objDataSet.Tables[0].Rows[0][6].ToString();
objAllJobsBO.JobDuration = objDataSet.Tables[0].Rows[0][7].ToString();
objAllJobsBO.Qualification = objDataSet.Tables[0].Rows[0][8].ToString();
objAllJobsBO.Experience = objDataSet.Tables[0].Rows[0][9].ToString();
objAllJobsBO.Skills = objDataSet.Tables[0].Rows[0][10].ToString();
objAllJobsBO.Status = objDataSet.Tables[0].Rows[0][11].ToString();
objAllJobsBO.ApprovedById = objDataSet.Tables[0].Rows[0][12].ToString();
objAllJobsBO.ApprovedDate = objDataSet.Tables[0].Rows[0][13].ToString();
objAllJobsBO.RejectedById = objDataSet.Tables[0].Rows[0][14].ToString();
objAllJobsBO.RejectedDate = objDataSet.Tables[0].Rows[0][15].ToString();
objAllJobsBO.MarketedBy = objDataSet.Tables[0].Rows[0][16].ToString();
objAllJobsBO.MarketedDate = objDataSet.Tables[0].Rows[0][17].ToString();
objAllJobsBO.HROffice_Comments = objDataSet.Tables[0].Rows[0][18].ToString();
objAllJobsBO.HOP_Comments = objDataSet.Tables[0].Rows[0][19].ToString();
objAllJobsBO.PM_Comments = objDataSet.Tables[0].Rows[0][20].ToString();
objAllJobsBO.IsActive = Convert.ToBoolean(objDataSet.Tables[0].Rows[0][21].ToString());
objAllJobsBO.DonorProgramId = Convert.ToInt32(objDataSet.Tables[0].Rows[0][22].ToString());
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "EditPMGrid");
throw ex;
}
return(objAllJobsBO);
}
public ApplyJobsBO DisplayApplyJob(int iJobPostingId, int iApplicantId)
{
DataSet objDataSet = null;
ApplyJobsBO objApplyJobsBO = null;
List <ProcParameterBO> ObjProcParameterBOList = new List <ProcParameterBO>();
try
{
ProcParameterBO objDbParameter = new ProcParameterBO();
objDbParameter.Direction = ParameterDirection.Input;
objDbParameter.ParameterName = "@iJobPostingId";
objDbParameter.dbType = DbType.Int32;
objDbParameter.ParameterValue = iJobPostingId;
ObjProcParameterBOList.Add(objDbParameter);
objDbParameter = new ProcParameterBO();
objDbParameter.Direction = ParameterDirection.Input;
objDbParameter.ParameterName = "@iApplicantId";
objDbParameter.dbType = DbType.Int32;
objDbParameter.ParameterValue = iApplicantId;
ObjProcParameterBOList.Add(objDbParameter);
objDataSet = objDBAccess.execuitDataSet(ProcViewApplyJob, ref ObjProcParameterBOList);
if (objDataSet != null && objDataSet.Tables[0].Rows.Count > 0)
{
objApplyJobsBO = new ApplyJobsBO();
objApplyJobsBO.JobPostingId = Convert.ToInt32(objDataSet.Tables[0].Rows[0][0].ToString());
objApplyJobsBO.JobName = objDataSet.Tables[0].Rows[0][1].ToString();
objApplyJobsBO.JobDescription = objDataSet.Tables[0].Rows[0][2].ToString();
objApplyJobsBO.NoOfPositions = objDataSet.Tables[0].Rows[0][3].ToString();
objApplyJobsBO.JobLocation = objDataSet.Tables[0].Rows[0][4].ToString();
objApplyJobsBO.JobTimings = objDataSet.Tables[0].Rows[0][5].ToString();
objApplyJobsBO.JobDuration = objDataSet.Tables[0].Rows[0][6].ToString();
objApplyJobsBO.DonorProgramName = objDataSet.Tables[0].Rows[0][7].ToString();
objApplyJobsBO.Qualification = objDataSet.Tables[0].Rows[0][8].ToString();
objApplyJobsBO.Experience = objDataSet.Tables[0].Rows[0][9].ToString();
objApplyJobsBO.Skills = objDataSet.Tables[0].Rows[0][10].ToString();
objApplyJobsBO.Comments = objDataSet.Tables[0].Rows[0][11].ToString();
objApplyJobsBO.JobDescriptionFile = objDataSet.Tables[0].Rows[0][12].ToString();
objApplyJobsBO.JobDescriptionFileSavedName = objDataSet.Tables[0].Rows[0][13].ToString();
objApplyJobsBO.AppliedStatus = objDataSet.Tables[0].Rows[0][14].ToString();
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "DisplayApplyJob");
throw ex;
}
return(objApplyJobsBO);
}
public List <ApplicantsListBO> getApplicantsList(int iJobId)
{
DataSet objDataSet = null;
ApplicantsListBO objApplicantsListBO = null;
List <ApplicantsListBO> objApplicantsBOList = new List <ApplicantsListBO>();
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
ProcParameterBO objDbParameter = new ProcParameterBO();
objDbParameter.Direction = ParameterDirection.Input;
objDbParameter.ParameterName = "@iJobId";
objDbParameter.dbType = DbType.Int32;
objDbParameter.ParameterValue = iJobId;
objProcParameterBOList.Add(objDbParameter);
objDataSet = objDBAccess.execuitDataSet(ProcGetApplicantsList, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables.Count > 0)
{
for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
{
objApplicantsListBO = new ApplicantsListBO();
objApplicantsListBO.ApplicantId = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString());
objApplicantsListBO.FullName = objDataSet.Tables[0].Rows[i][1].ToString();
objApplicantsListBO.AcademicQualification = objDataSet.Tables[0].Rows[i][2].ToString();
objApplicantsListBO.PhoneNumber = objDataSet.Tables[0].Rows[i][3].ToString();
objApplicantsListBO.EmailAddress = objDataSet.Tables[0].Rows[i][4].ToString();
objApplicantsListBO.MotherTongue = objDataSet.Tables[0].Rows[i][5].ToString();
objApplicantsListBO.DateOfBirth = objDataSet.Tables[0].Rows[i][6].ToString();
objApplicantsListBO.Gender = objDataSet.Tables[0].Rows[i][7].ToString();
objApplicantsListBO.DonorProgram = objDataSet.Tables[0].Rows[i][8].ToString();
objApplicantsListBO.ProfessionalBodyName = objDataSet.Tables[0].Rows[i][9].ToString();
objApplicantsListBO.MembershipNumber = objDataSet.Tables[0].Rows[i][10].ToString();
objApplicantsListBO.Validity = objDataSet.Tables[0].Rows[i][11].ToString();
objApplicantsListBO.Subject = objDataSet.Tables[0].Rows[i][12].ToString();
objApplicantsListBO.Status = objDataSet.Tables[0].Rows[i][13].ToString();
objApplicantsBOList.Add(objApplicantsListBO);
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "getApplicantsList");
throw ex;
}
return(objApplicantsBOList);
}
public string getUpdatePassword(string strEmailAddress, string strNewPassword)
{
string strResult = "";
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
ProcParameterBO objDBparameter = null;
try
{
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strEmailAddress";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = strEmailAddress;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strPassword";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = strNewPassword;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Output;
objDBparameter.ParameterName = "@strResult";
objDBparameter.dbType = DbType.String;
objDBparameter.Size = 100;
objProcParameterBOList.Add(objDBparameter);
objDBAccess.executeScalar("usp_SCH_updatePassword", ref objProcParameterBOList);
for (int i = 0; i < objProcParameterBOList.Count; i++)
{
if (objProcParameterBOList[i].Direction == ParameterDirection.Output)
{
strResult = objProcParameterBOList[i].ParameterValue.ToString();
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "getUpdatePassword");
throw ex;
}
return(strResult);
}
public ProfileBO DisplayUser(int iUserId)
{
DataSet objDataSet = null;
ProfileBO objProfileBO = null;
List <ProcParameterBO> ObjProcParameterBOList = new List <ProcParameterBO>();
try
{
ProcParameterBO objDbParameter = new ProcParameterBO();
objDbParameter.Direction = ParameterDirection.Input;
objDbParameter.ParameterName = "@iUserId";
objDbParameter.dbType = DbType.Int32;
objDbParameter.ParameterValue = iUserId;
ObjProcParameterBOList.Add(objDbParameter);
objDataSet = objDBAccess.execuitDataSet(ProcViewUser, ref ObjProcParameterBOList);
if (objDataSet != null && objDataSet.Tables[0].Rows.Count > 0)
{
objProfileBO = new ProfileBO();
objProfileBO.UserId = Convert.ToInt32(objDataSet.Tables[0].Rows[0][0].ToString());
objProfileBO.FirstName = objDataSet.Tables[0].Rows[0][1].ToString();
objProfileBO.MiddleName = objDataSet.Tables[0].Rows[0][2].ToString();
objProfileBO.LastName = objDataSet.Tables[0].Rows[0][3].ToString();
objProfileBO.Gender = objDataSet.Tables[0].Rows[0][4].ToString();
objProfileBO.MobileNumber = objDataSet.Tables[0].Rows[0][5].ToString();
objProfileBO.AlternateMobileNumber = objDataSet.Tables[0].Rows[0][6].ToString();
objProfileBO.EmailAddress = objDataSet.Tables[0].Rows[0][7].ToString();
objProfileBO.Language = objDataSet.Tables[0].Rows[0][8].ToString();
objProfileBO.Qualification = objDataSet.Tables[0].Rows[0][9].ToString();
objProfileBO.Country = objDataSet.Tables[0].Rows[0][10].ToString();
objProfileBO.City = objDataSet.Tables[0].Rows[0][11].ToString();
objProfileBO.RoleName = objDataSet.Tables[0].Rows[0][12].ToString();
objProfileBO.Department = objDataSet.Tables[0].Rows[0][13].ToString();
objProfileBO.Address = objDataSet.Tables[0].Rows[0][14].ToString();
objProfileBO.Photo = objDataSet.Tables[0].Rows[0][15].ToString();
objProfileBO.ActualFileName = objDataSet.Tables[0].Rows[0][16].ToString();
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "DisplayUser");
throw ex;
}
return(objProfileBO);
}
public List <PostJobBO> getJobsList(int iUserId)
{
DataSet objDataSet = null;
PostJobBO objJobPostingsBO = null;
List <PostJobBO> objJobPostingsBOList = new List <PostJobBO>();
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
ProcParameterBO objDBparameter = null;
try
{
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@iUserId";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = iUserId;
objProcParameterBOList.Add(objDBparameter);
objDataSet = objDBAccess.execuitDataSet(ProcGetJobsList, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables.Count > 0)
{
for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
{
objJobPostingsBO = new PostJobBO();
objJobPostingsBO.JobPostingId = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString());
objJobPostingsBO.JobName = objDataSet.Tables[0].Rows[i][1].ToString();
objJobPostingsBO.JobDescription = objDataSet.Tables[0].Rows[i][2].ToString();
objJobPostingsBO.JobLocation = objDataSet.Tables[0].Rows[i][3].ToString();
objJobPostingsBO.NoOfPositions = objDataSet.Tables[0].Rows[i][4].ToString();
objJobPostingsBO.Status = objDataSet.Tables[0].Rows[i][5].ToString();
objJobPostingsBO.Skills = objDataSet.Tables[0].Rows[i][6].ToString();
objJobPostingsBO.Qualification = objDataSet.Tables[0].Rows[i][7].ToString();
objJobPostingsBO.Experience = objDataSet.Tables[0].Rows[i][8].ToString();
objJobPostingsBO.DonorProgram = objDataSet.Tables[0].Rows[i][9].ToString();
objJobPostingsBOList.Add(objJobPostingsBO);
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "getJobsList");
throw ex;
}
return(objJobPostingsBOList);
}
public MenuMasterBO ViewMenuMaster(int iMenuId)
{
DataSet objDataSet = null;
MenuMasterBO objMenuMasterBO = null;
List <ProcParameterBO> ObjProcParameterBOList = new List <ProcParameterBO>();
try
{
ProcParameterBO objDbParameter = new ProcParameterBO();
objDbParameter.Direction = ParameterDirection.Input;
objDbParameter.ParameterName = "@iMenuId";
objDbParameter.dbType = DbType.Int32;
objDbParameter.ParameterValue = iMenuId;
ObjProcParameterBOList.Add(objDbParameter);
objDataSet = objDbAcess.execuitDataSet(ProcViewMenuMaster, ref ObjProcParameterBOList);
if (objDataSet != null && objDataSet.Tables[0].Rows.Count > 0)
{
objMenuMasterBO = new MenuMasterBO();
objMenuMasterBO.MenuId = Convert.ToInt32(objDataSet.Tables[0].Rows[0][0].ToString());
objMenuMasterBO.MenuName = objDataSet.Tables[0].Rows[0][1].ToString();
objMenuMasterBO.ParentMenuId = objDataSet.Tables[0].Rows[0][2].ToString();
objMenuMasterBO.DisplayOrder = Convert.ToInt32(objDataSet.Tables[0].Rows[0][3].ToString());
objMenuMasterBO.PageURL = objDataSet.Tables[0].Rows[0][4].ToString();
objMenuMasterBO.ImageURL = objDataSet.Tables[0].Rows[0][5].ToString();
objMenuMasterBO.MenuGroupId = objDataSet.Tables[0].Rows[0][6].ToString();
objMenuMasterBO.MenuKey = objDataSet.Tables[0].Rows[0][7].ToString();
objMenuMasterBO.faIcon = objDataSet.Tables[0].Rows[0][8].ToString();
objMenuMasterBO.HelpURL = objDataSet.Tables[0].Rows[0][9].ToString();
objMenuMasterBO.HelpDocURL = objDataSet.Tables[0].Rows[0][10].ToString();
objMenuMasterBO.LocalVideo = objDataSet.Tables[0].Rows[0][11].ToString();
objMenuMasterBO.LocalDocument = objDataSet.Tables[0].Rows[0][12].ToString();
objMenuMasterBO.IsActive = Convert.ToBoolean(objDataSet.Tables[0].Rows[0][13].ToString());
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "ViewMenuMaster");
throw ex;
}
return(objMenuMasterBO);
}
public List <ApplyJobsBO> getAppliedJobsList(int iApplicantId)
{
DataSet objDataSet = null;
ApplyJobsBO objApplyJobsBO = null;
List <ApplyJobsBO> objobjApplyJobsBOList = new List <ApplyJobsBO>();
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
ProcParameterBO objProcParameterBo = new ProcParameterBO();
objProcParameterBo.Direction = ParameterDirection.Input;
objProcParameterBo.ParameterName = "@iApplicantId";
objProcParameterBo.dbType = DbType.Int32;
objProcParameterBo.ParameterValue = iApplicantId;
objProcParameterBOList.Add(objProcParameterBo);
objDataSet = objDBAccess.execuitDataSet(ProcGetJobsList, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables.Count > 0)
{
for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
{
objApplyJobsBO = new ApplyJobsBO();
objApplyJobsBO.JobPostingId = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString());
objApplyJobsBO.JobName = objDataSet.Tables[0].Rows[i][1].ToString();
objApplyJobsBO.JobDescription = objDataSet.Tables[0].Rows[i][2].ToString();
objApplyJobsBO.JobLocation = objDataSet.Tables[0].Rows[i][3].ToString();
objApplyJobsBO.NoOfPositions = objDataSet.Tables[0].Rows[i][4].ToString();
objApplyJobsBO.ApplicantComments = objDataSet.Tables[0].Rows[i][5].ToString();
objApplyJobsBO.AppliedStatus = objDataSet.Tables[0].Rows[i][6].ToString();
objobjApplyJobsBOList.Add(objApplyJobsBO);
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "getAppliedJobsList");
throw ex;
}
return(objobjApplyJobsBOList);
}
public List <SelectedListBO> getSelectedList(int iJobId)
{
DataSet objDataSet = null;
SelectedListBO objSelectedListBO = null;
List <SelectedListBO> objSelectedListBOList = new List <SelectedListBO>();
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
ProcParameterBO objDbParameter = new ProcParameterBO();
objDbParameter.Direction = ParameterDirection.Input;
objDbParameter.ParameterName = "@iJobId";
objDbParameter.dbType = DbType.Int32;
objDbParameter.ParameterValue = iJobId;
objProcParameterBOList.Add(objDbParameter);
objDataSet = objDBAccess.execuitDataSet(ProcgetSelectedList, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables.Count > 0)
{
for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
{
objSelectedListBO = new SelectedListBO();
objSelectedListBO.ApplicantId = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString());
objSelectedListBO.ApplicantName = objDataSet.Tables[0].Rows[i][1].ToString();
objSelectedListBO.PhoneNumber = objDataSet.Tables[0].Rows[i][2].ToString();
objSelectedListBO.EmailAddress = objDataSet.Tables[0].Rows[i][3].ToString();
objSelectedListBO.Address = objDataSet.Tables[0].Rows[i][4].ToString();
objSelectedListBO.Status = objDataSet.Tables[0].Rows[i][5].ToString();
// objSelectedListBO.Comments = objDataSet.Tables[0].Rows[i][6].ToString();
objSelectedListBO.JobId = Convert.ToInt32(objDataSet.Tables[0].Rows[i][6].ToString());
objSelectedListBOList.Add(objSelectedListBO);
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "getSelectedList");
throw ex;
}
return(objSelectedListBOList);
}