public ActionResult EditAllJobs(int iJobPostingId)
        {
            ApprovedJobsBAL objApprovedJobsBAL = new ApprovedJobsBAL();
            AllJobsBAL      objAllJobsBAL      = new AllJobsBAL();
            ApprovedJobsBO  objJobsBO          = objApprovedJobsBAL.DisplayApprovedJob(iJobPostingId);

            objJobsBO.DonorProgramList = objAllJobsBAL.DonorProgramList(Convert.ToInt32(ViewData["LoginUserId"]));
            return(PartialView("EditJob", objJobsBO));
        }
예제 #2
0
        public ApprovedJobsBO DisplayApprovedJob(int iJobPostingId)
        {
            DataSet                objDataSet             = null;
            ApprovedJobsBO         objApprovedJobsBO      = 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(ProcViewApprovedJob, ref ObjProcParameterBOList);
                if (objDataSet != null && objDataSet.Tables[0].Rows.Count > 0)
                {
                    objApprovedJobsBO                             = new ApprovedJobsBO();
                    objApprovedJobsBO.JobName                     = objDataSet.Tables[0].Rows[0][0].ToString();
                    objApprovedJobsBO.JobCode                     = objDataSet.Tables[0].Rows[0][1].ToString();
                    objApprovedJobsBO.JobDescription              = objDataSet.Tables[0].Rows[0][2].ToString();
                    objApprovedJobsBO.NoOfPositions               = objDataSet.Tables[0].Rows[0][3].ToString();
                    objApprovedJobsBO.JobLocation                 = objDataSet.Tables[0].Rows[0][4].ToString();
                    objApprovedJobsBO.JobTimings                  = objDataSet.Tables[0].Rows[0][5].ToString();
                    objApprovedJobsBO.JobDuration                 = objDataSet.Tables[0].Rows[0][6].ToString();
                    objApprovedJobsBO.Qualification               = objDataSet.Tables[0].Rows[0][7].ToString();
                    objApprovedJobsBO.Experience                  = objDataSet.Tables[0].Rows[0][8].ToString();
                    objApprovedJobsBO.Skills                      = objDataSet.Tables[0].Rows[0][9].ToString();
                    objApprovedJobsBO.Status                      = objDataSet.Tables[0].Rows[0][10].ToString();
                    objApprovedJobsBO.DonorProgramId              = Convert.ToInt32(objDataSet.Tables[0].Rows[0][11].ToString());
                    objApprovedJobsBO.DonorProgram                = objDataSet.Tables[0].Rows[0][12].ToString();
                    objApprovedJobsBO.Comments                    = objDataSet.Tables[0].Rows[0][13].ToString();
                    objApprovedJobsBO.ApprovedBy                  = objDataSet.Tables[0].Rows[0][14].ToString();
                    objApprovedJobsBO.ApprovedDate                = objDataSet.Tables[0].Rows[0][15].ToString();
                    objApprovedJobsBO.ApproverComments            = objDataSet.Tables[0].Rows[0][16].ToString();
                    objApprovedJobsBO.RejectedBy                  = objDataSet.Tables[0].Rows[0][17].ToString();
                    objApprovedJobsBO.RejectedDate                = objDataSet.Tables[0].Rows[0][18].ToString();
                    objApprovedJobsBO.RejectedComments            = objDataSet.Tables[0].Rows[0][19].ToString();
                    objApprovedJobsBO.MarketedBy                  = objDataSet.Tables[0].Rows[0][20].ToString();
                    objApprovedJobsBO.MarketedDate                = objDataSet.Tables[0].Rows[0][21].ToString();
                    objApprovedJobsBO.MarketingComments           = objDataSet.Tables[0].Rows[0][22].ToString();
                    objApprovedJobsBO.MarketingStatus             = objDataSet.Tables[0].Rows[0][23].ToString();
                    objApprovedJobsBO.HROfficeBy                  = objDataSet.Tables[0].Rows[0][24].ToString();
                    objApprovedJobsBO.HROffice_Date               = objDataSet.Tables[0].Rows[0][25].ToString();
                    objApprovedJobsBO.HROffice_Comments           = objDataSet.Tables[0].Rows[0][26].ToString();
                    objApprovedJobsBO.HOPBy                       = objDataSet.Tables[0].Rows[0][27].ToString();
                    objApprovedJobsBO.HOP_Comments                = objDataSet.Tables[0].Rows[0][28].ToString();
                    objApprovedJobsBO.HOP_Date                    = objDataSet.Tables[0].Rows[0][29].ToString();
                    objApprovedJobsBO.PMBy                        = objDataSet.Tables[0].Rows[0][30].ToString();
                    objApprovedJobsBO.PM_Comments                 = objDataSet.Tables[0].Rows[0][31].ToString();
                    objApprovedJobsBO.PM_Date                     = objDataSet.Tables[0].Rows[0][32].ToString();
                    objApprovedJobsBO.AdminBy                     = objDataSet.Tables[0].Rows[0][33].ToString();
                    objApprovedJobsBO.Admin_Date                  = objDataSet.Tables[0].Rows[0][34].ToString();
                    objApprovedJobsBO.Admin_Comments              = objDataSet.Tables[0].Rows[0][35].ToString();
                    objApprovedJobsBO.AdminStatus                 = objDataSet.Tables[0].Rows[0][36].ToString();
                    objApprovedJobsBO.HAFBy                       = objDataSet.Tables[0].Rows[0][37].ToString();
                    objApprovedJobsBO.HAF_Date                    = objDataSet.Tables[0].Rows[0][38].ToString();
                    objApprovedJobsBO.HAF_Comments                = objDataSet.Tables[0].Rows[0][39].ToString();
                    objApprovedJobsBO.HAF_Status                  = objDataSet.Tables[0].Rows[0][40].ToString();
                    objApprovedJobsBO.HRBy                        = objDataSet.Tables[0].Rows[0][41].ToString();
                    objApprovedJobsBO.HRComments                  = objDataSet.Tables[0].Rows[0][42].ToString();
                    objApprovedJobsBO.HRStatus                    = objDataSet.Tables[0].Rows[0][43].ToString();
                    objApprovedJobsBO.IsActive                    = objDataSet.Tables[0].Rows[0][44].ToString();
                    objApprovedJobsBO.CreatedBy                   = objDataSet.Tables[0].Rows[0][45].ToString();
                    objApprovedJobsBO.CreatedOn                   = objDataSet.Tables[0].Rows[0][46].ToString();
                    objApprovedJobsBO.JobPostingId                = Convert.ToInt32(objDataSet.Tables[0].Rows[0][47].ToString());
                    objApprovedJobsBO.JobDescriptionFile          = objDataSet.Tables[0].Rows[0][48].ToString();
                    objApprovedJobsBO.JobDescriptionFileSavedName = objDataSet.Tables[0].Rows[0][49].ToString();
                    objApprovedJobsBO.HOD_Comments                = objDataSet.Tables[0].Rows[0][50].ToString();
                    objApprovedJobsBO.HOD_Date                    = objDataSet.Tables[0].Rows[0][51].ToString();
                    objApprovedJobsBO.RequiredStaffLevel          = objDataSet.Tables[0].Rows[0][52].ToString();
                    objApprovedJobsBO.CurrentStaffLevel           = objDataSet.Tables[0].Rows[0][53].ToString();
                    objApprovedJobsBO.Gaps                        = objDataSet.Tables[0].Rows[0][54].ToString();
                }
            }
            catch (Exception ex)
            {
                ExceptionError.Error_Log(ex, "DisplayApprovedJob");
                throw ex;
            }
            return(objApprovedJobsBO);
        }