コード例 #1
0
        public ActionResult getJobMarketing(JobMarketingBO Data)
        {
            ApprovedJobsBAL  objApprovedJobsBAL = new ApprovedJobsBAL();
            List <PostJobBO> objJobsBOList      = objApprovedJobsBAL.getApprovedJobsList(Convert.ToInt32(ViewData["LoginUserId"]), Convert.ToInt32(ViewData["LoginRoleId"]), 2);

            return(PartialView("GetJobMarketingList", objJobsBOList));
        }
コード例 #2
0
        public List <JobMarketingBO> getJobMarketingList()
        {
            DataSet                objDataSet             = null;
            JobMarketingBO         objJobMarketingBO      = null;
            List <JobMarketingBO>  objJobMarketingBOList  = new List <JobMarketingBO>();
            List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();

            try
            {
                objDataSet = objDBAccess.execuitDataSet(ProcJobMarketingList, ref objProcParameterBOList);
                if (objDataSet != null && objDataSet.Tables.Count > 0)
                {
                    for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
                    {
                        objJobMarketingBO = new JobMarketingBO();
                        objJobMarketingBO.JobPostingId      = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString());
                        objJobMarketingBO.JobName           = objDataSet.Tables[0].Rows[i][1].ToString();
                        objJobMarketingBO.JobDescription    = objDataSet.Tables[0].Rows[i][2].ToString();
                        objJobMarketingBO.JobLocation       = objDataSet.Tables[0].Rows[i][3].ToString();
                        objJobMarketingBO.NoOfPositions     = Convert.ToInt32(objDataSet.Tables[0].Rows[i][4].ToString());
                        objJobMarketingBO.Status            = objDataSet.Tables[0].Rows[i][5].ToString();
                        objJobMarketingBO.MarketingStatus   = objDataSet.Tables[0].Rows[i][6].ToString();
                        objJobMarketingBO.MarketingComments = objDataSet.Tables[0].Rows[i][7].ToString();
                        objJobMarketingBOList.Add(objJobMarketingBO);
                    }
                }
            }
            catch (Exception ex)
            {
                ExceptionError.Error_Log(ex, "getJobMarketingList");
                throw ex;
            }
            return(objJobMarketingBOList);
        }
コード例 #3
0
        public ActionResult EditJobMarketing(JobMarketingBO Data, 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("EditJobMarketing", objJobsBO));
        }
コード例 #4
0
        public ActionResult Index()
        {
            ViewBag.Title     = "Job";
            ViewBag.MainTitle = "Job Marketing";
            ViewBag.Icon      = "fa fa-graduation";
            JobMarketingBO objJobMarketingBO = new JobMarketingBO();

            return(View(objJobMarketingBO));
        }
コード例 #5
0
        public JsonResult SaveJobMarketing(JobMarketingBO Data)
        {
            JobMarketingBAL objJobMarketingBAL = new JobMarketingBAL();

            Data.MarketingStatus = "2";
            Data.IsActive        = true;
            string strResult = objJobMarketingBAL.SaveJobMarketing(Data, Convert.ToInt32(ViewData["LoginUserId"]));

            return(Json(strResult, JsonRequestBehavior.AllowGet));
        }
コード例 #6
0
        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);
        }
コード例 #7
0
        public JobMarketingBO EditJobMarketing(int iJobPostingId)
        {
            DataSet                objDataSet             = null;
            JobMarketingBO         objJobMarketingBO      = 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(ProcEditJobMarketing, ref objProcParameterBOList);
                if (objDataSet != null && objDataSet.Tables[0].Rows.Count > 0)
                {
                    objJobMarketingBO = new JobMarketingBO();
                    objJobMarketingBO.JobPostingId      = Convert.ToInt32(objDataSet.Tables[0].Rows[0][0].ToString());
                    objJobMarketingBO.JobName           = objDataSet.Tables[0].Rows[0][1].ToString();
                    objJobMarketingBO.JobCode           = objDataSet.Tables[0].Rows[0][2].ToString();
                    objJobMarketingBO.JobDescription    = objDataSet.Tables[0].Rows[0][3].ToString();
                    objJobMarketingBO.NoOfPositions     = Convert.ToInt32(objDataSet.Tables[0].Rows[0][4].ToString());
                    objJobMarketingBO.JobLocation       = objDataSet.Tables[0].Rows[0][5].ToString();
                    objJobMarketingBO.JobTimings        = objDataSet.Tables[0].Rows[0][6].ToString();
                    objJobMarketingBO.JobDuration       = objDataSet.Tables[0].Rows[0][7].ToString();
                    objJobMarketingBO.Qualification     = objDataSet.Tables[0].Rows[0][8].ToString();
                    objJobMarketingBO.Experience        = objDataSet.Tables[0].Rows[0][9].ToString();
                    objJobMarketingBO.Skills            = objDataSet.Tables[0].Rows[0][10].ToString();
                    objJobMarketingBO.StatusId          = Convert.ToInt32(objDataSet.Tables[0].Rows[0][11].ToString());
                    objJobMarketingBO.MarketingComments = objDataSet.Tables[0].Rows[0][12].ToString();
                    objJobMarketingBO.IsActive          = Convert.ToBoolean(objDataSet.Tables[0].Rows[0][13].ToString());
                    objJobMarketingBO.DonorProgramId    = Convert.ToInt32(objDataSet.Tables[0].Rows[0][14].ToString());
                }
            }
            catch (Exception ex)
            {
                ExceptionError.Error_Log(ex, "EditJobMarketing");
                throw ex;
            }
            return(objJobMarketingBO);
        }
コード例 #8
0
 public string SaveJobMarketing(JobMarketingBO objJobMarketingBO, int iUserId)
 {
     return(objJobMarketingDAL.SaveJobMarketing(objJobMarketingBO, iUserId));
 }