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