コード例 #1
0
        public ActionResult EditWorkExperience(int id)         //Get-Editing work experience details
        {
            WorkExperiences experiences = this.jobMediator.FetchSingleWorkExperience(id);
            var             map         = AutoMapper.Mapper.Map <WorkExperiences, WorkExperienceViewModel>(experiences);

            return(View(map));
        }
コード例 #2
0
 /// <summary>
 /// Persons the education work experiences delete dal.
 /// </summary>
 /// <param name="_objWorkExperiences">The object work experiences.</param>
 /// <returns>System.Int32.</returns>
 public int PersonEducationWorkExperiences_DeleteDAL(WorkExperiences _objWorkExperiences)
 {
     return(ExecuteScalarInt32Sp("TMS_PersonEducationWorkExperiences_Delete",
                                 ParamBuilder.Par("ID", _objWorkExperiences.ID),
                                 ParamBuilder.Par("UpdatedBy", _objWorkExperiences.UpdatedBy),
                                 ParamBuilder.Par("UpdatedDate", _objWorkExperiences.UpdatedDate)));
 }
コード例 #3
0
 /// <summary>
 /// Persons the education work experiences duplication check dal.
 /// </summary>
 /// <param name="_objWorkExperiences">The object work experiences.</param>
 /// <param name="pid">The pid.</param>
 /// <returns>System.Int32.</returns>
 public int PersonEducationWorkExperiences_DuplicationCheckDAL(WorkExperiences _objWorkExperiences, string pid)
 {
     return(ExecuteScalarSPInt32("TMS_PersonEducationWorkExperiences_DuplicationCheck",
                                 ParamBuilder.Par("PersonID", pid),
                                 ParamBuilder.Par("StartDate", _objWorkExperiences.StartTimePeriod),
                                 ParamBuilder.Par("EndDate", _objWorkExperiences.EndTimePeriod),
                                 ParamBuilder.Par("JobStatus", _objWorkExperiences.JobStatus)));
 }
コード例 #4
0
 public void AddExperience(WorkExperiences work)        //Add work experience
 {
     using (DBUtills dB = new DBUtills())
     {
         dB.WorkExperienceDb.Add(work);
         dB.SaveChanges();
     }
 }
コード例 #5
0
 public void RemoveExperience(int idValue)         //Delete experience
 {
     using (DBUtills dBUtills = new DBUtills())
     {
         WorkExperiences work = dBUtills.WorkExperienceDb.Find(idValue);
         dBUtills.WorkExperienceDb.Remove(work);
         dBUtills.SaveChanges();
     }
 }
コード例 #6
0
        public WorkExperiences FetchSingleWorkExperience(int log)        //Extract single work experience
        {
            WorkExperiences work = null;

            using (DBUtills dB = new DBUtills())
            {
                work = dB.WorkExperienceDb.Find(log);
                return(work);
            }
        }
コード例 #7
0
ファイル: Employee.cs プロジェクト: netopvh/ChaiEthERP
 public virtual void RemoveWorkExperience(int Id)
 {
     foreach (WorkExperience WE in WorkExperiences)
     {
         if (WE.Id == Id)
         {
             WorkExperiences.Remove(WE);
             break;
         }
     }
 }
コード例 #8
0
        public bool UpdateExperience(WorkExperiences experience)          //Update experience
        {
            bool status = false;

            using (DBUtills dBUtills = new DBUtills())
            {
                dBUtills.Entry(experience).State = EntityState.Modified;
                dBUtills.SaveChanges();
                status = true;
            }
            return(status);
        }
コード例 #9
0
 /// <summary>
 /// Persons the education work experiences update dal.
 /// </summary>
 /// <param name="_objWorkExperiences">The object work experiences.</param>
 /// <returns>System.Int32.</returns>
 public int PersonEducationWorkExperiences_UpdateDAL(WorkExperiences _objWorkExperiences)
 {
     return(ExecuteScalarInt32Sp("TMS_PersonEducationWorkExperiences_Update",
                                 ParamBuilder.Par("ID", _objWorkExperiences.ID),
                                 ParamBuilder.Par("OrganizationID", _objWorkExperiences.OrganizationID),
                                 ParamBuilder.Par("CompanyName", _objWorkExperiences.CompanyName),
                                 ParamBuilder.Par("RelationType", _objWorkExperiences.RelationType),
                                 ParamBuilder.Par("P_Title", _objWorkExperiences.P_Title),
                                 ParamBuilder.Par("S_Title", _objWorkExperiences.S_Title),
                                 ParamBuilder.Par("JobStatus", _objWorkExperiences.JobStatus),
                                 ParamBuilder.Par("Location", _objWorkExperiences.Location),
                                 ParamBuilder.Par("StartTimePeriod", _objWorkExperiences.StartTimePeriod),
                                 ParamBuilder.Par("EndTimePeriod", _objWorkExperiences.EndTimePeriod),
                                 ParamBuilder.Par("IsCurrent", _objWorkExperiences.IsCurrent),
                                 ParamBuilder.Par("ReferenceName", _objWorkExperiences.ReferenceName),
                                 ParamBuilder.Par("ReferenceEmail", _objWorkExperiences.ReferenceEmail),
                                 ParamBuilder.Par("ReferencePhone", _objWorkExperiences.ReferencePhone),
                                 ParamBuilder.Par("Description", _objWorkExperiences.Description),
                                 ParamBuilder.Par("UpdatedBy", _objWorkExperiences.UpdatedBy),
                                 ParamBuilder.Par("UpdatedDate", _objWorkExperiences.UpdatedDate)));
 }
コード例 #10
0
        /// <summary>
        /// Persons the education work experiences create dal.
        /// </summary>
        /// <param name="_objWorkExperiences">The object work experiences.</param>
        /// <returns>System.Int64.</returns>
        public long PersonEducationWorkExperiences_CreateDAL(WorkExperiences _objWorkExperiences)
        {
            var parameters = new[] { ParamBuilder.Par("ID", 0) };

            return(ExecuteInt64withOutPutparameterSp("TMS_PersonEducationWorkExperiences_Create", parameters,
                                                     ParamBuilder.Par("PersonID", _objWorkExperiences.PersonID),
                                                     ParamBuilder.Par("OrganizationID", _objWorkExperiences.OrganizationID),
                                                     ParamBuilder.Par("RelationType", _objWorkExperiences.RelationType),
                                                     ParamBuilder.Par("CompanyName", _objWorkExperiences.CompanyName),
                                                     ParamBuilder.Par("P_Title", _objWorkExperiences.P_Title),
                                                     ParamBuilder.Par("S_Title", _objWorkExperiences.S_Title),
                                                     ParamBuilder.Par("JobStatus", _objWorkExperiences.JobStatus),
                                                     ParamBuilder.Par("Location", _objWorkExperiences.Location),
                                                     ParamBuilder.Par("StartTimePeriod", _objWorkExperiences.StartTimePeriod),
                                                     ParamBuilder.Par("EndTimePeriod", _objWorkExperiences.EndTimePeriod),
                                                     ParamBuilder.Par("IsCurrent", _objWorkExperiences.IsCurrent),
                                                     ParamBuilder.Par("ReferenceName", _objWorkExperiences.ReferenceName),
                                                     ParamBuilder.Par("ReferenceEmail", _objWorkExperiences.ReferenceEmail),
                                                     ParamBuilder.Par("ReferencePhone", _objWorkExperiences.ReferencePhone),
                                                     ParamBuilder.Par("Description", _objWorkExperiences.Description),
                                                     ParamBuilder.Par("CreatedBy", _objWorkExperiences.CreatedBy),
                                                     ParamBuilder.Par("CreatedDate", _objWorkExperiences.CreatedDate)));
        }
コード例 #11
0
 public bool UpdateExperience(WorkExperiences experience)        //Update work experience of searcher
 {
     return(jobRepository.UpdateExperience(experience));
 }
コード例 #12
0
        public ActionResult PersonWorkExperience_Destroy([DataSourceRequest] DataSourceRequest request, WorkExperiences _personWorkExperiences)
        {
            if (ModelState.IsValid)
            {
                _personWorkExperiences.UpdatedBy   = CurrentUser.NameIdentifierInt64;
                _personWorkExperiences.UpdatedDate = DateTime.Now;
                var result = _PersonEducationBAL.PersonEducationWorkExperiences_DeleteDAL(_personWorkExperiences);
                if (result == -1)
                {
                    ModelState.AddModelError(lr.ErrorServerError, lr.ResourceUpdateValidationError);
                }
            }
            var resultData = new[] { _personWorkExperiences };

            return(Json(resultData.AsQueryable().ToDataSourceResult(request, ModelState)));
        }
コード例 #13
0
        public ActionResult PersonWorkExperience_Create([DataSourceRequest] DataSourceRequest request, string pid, WorkExperiences _personWorkExperiences)
        {
            var now          = DateTime.Now;
            var startOfMonth = new DateTime(now.Year, now.Month, 1);

            if (_personWorkExperiences.IsCurrent)
            {
                _personWorkExperiences.EndTimePeriod = startOfMonth;
            }
            if (ModelState.IsValid)
            {
                if (_personWorkExperiences.OrganizationID == -1)
                {
                    _personWorkExperiences.CreatedBy       = CurrentUser.NameIdentifierInt64;
                    _personWorkExperiences.CreatedDate     = DateTime.Now;
                    _personWorkExperiences.PersonID        = Convert.ToInt64(pid);
                    _personWorkExperiences.StartTimePeriod = new DateTime(_personWorkExperiences.StartTimePeriod.Year, _personWorkExperiences.StartTimePeriod.Month, 1);
                    if (_personWorkExperiences.OrganizationID == -1)
                    {
                        _personWorkExperiences.OrganizationID = 0;
                    }
                    var result = _PersonEducationBAL.PersonEducationWorkExperiences_CreateDAL(_personWorkExperiences);
                    if (result == -1)
                    {
                        ModelState.AddModelError(lr.ErrorServerError, lr.PersonEducationCertificationsDuplicationMessage);
                    }
                    else
                    {
                        _personWorkExperiences.ID = result;
                    }
                }
                else
                {
                    if (_PersonEducationBAL.PersonEducationWorkExperiences_DuplicationCheckBAL(_personWorkExperiences, pid) == 0)
                    {
                        _personWorkExperiences.CreatedBy       = CurrentUser.NameIdentifierInt64;
                        _personWorkExperiences.CreatedDate     = DateTime.Now;
                        _personWorkExperiences.PersonID        = Convert.ToInt64(pid);
                        _personWorkExperiences.StartTimePeriod = new DateTime(_personWorkExperiences.StartTimePeriod.Year, _personWorkExperiences.StartTimePeriod.Month, 1);
                        if (_personWorkExperiences.OrganizationID == -1)
                        {
                            _personWorkExperiences.OrganizationID = 0;
                        }
                        var result = _PersonEducationBAL.PersonEducationWorkExperiences_CreateDAL(_personWorkExperiences);
                        if (result == -1)
                        {
                            ModelState.AddModelError(lr.ErrorServerError, lr.PersonEducationCertificationsDuplicationMessage);
                        }
                        else
                        {
                            _personWorkExperiences.ID = result;
                        }
                    }
                    else
                    {
                        ModelState.AddModelError(lr.PersonEducationWorkExperiencesTimePeriod, lr.PersonEducationWorkExperiencesTwoJobCheck);
                    }
                }
            }
            var resultData = new[] { _personWorkExperiences };

            return(Json(resultData.ToDataSourceResult(request, ModelState)));
        }
コード例 #14
0
        public ActionResult PersonWorkExperience_Update([DataSourceRequest] DataSourceRequest request, WorkExperiences _personWorkExperiences)
        {
            if (_personWorkExperiences.IsCurrent)
            {
                _personWorkExperiences.EndTimePeriod = DateTime.Now;
            }
            if (ModelState.IsValid)
            {
                if (_personWorkExperiences.IsCurrent == false)
                {
                    int result1 = DateTime.Compare(_personWorkExperiences.StartTimePeriod, _personWorkExperiences.EndTimePeriod);
                    if (result1 == 1)
                    {
                        ModelState.AddModelError(lr.StartandEndDateConflict, lr.StartandEndDateConflict);
                    }
                }
                _personWorkExperiences.UpdatedBy   = CurrentUser.NameIdentifierInt64;
                _personWorkExperiences.UpdatedDate = DateTime.Now;
                if (_personWorkExperiences.OrganizationID == -1)
                {
                    _personWorkExperiences.OrganizationID = 0;
                }

                var result = _PersonEducationBAL.PersonEducationWorkExperiences_UpdateDAL(_personWorkExperiences);
                if (result == -1)
                {
                    ModelState.AddModelError(lr.ErrorServerError, lr.ResourceUpdateValidationError);
                }
            }
            var resultData = new[] { _personWorkExperiences };

            return(Json(resultData.AsQueryable().ToDataSourceResult(request, ModelState)));
        }
コード例 #15
0
 public void CompletedExperience(WorkExperiences work)        //Completed searcher experience
 {
     jobRepository.AddExperience(work);
 }
コード例 #16
0
 /// <summary>
 /// Persons the education work experiences create dal.
 /// </summary>
 /// <param name="_objWorkExperiences">The object work experiences.</param>
 /// <returns>System.Int64.</returns>
 public long PersonEducationWorkExperiences_CreateDAL(WorkExperiences _objWorkExperiences)
 {
     return(DAL.PersonEducationWorkExperiences_CreateDAL(_objWorkExperiences));
 }
コード例 #17
0
 /// <summary>
 /// Persons the education work experiences duplication check bal.
 /// </summary>
 /// <param name="_objWorkExperiences">The object work experiences.</param>
 /// <param name="pid">The pid.</param>
 /// <returns>System.Int32.</returns>
 public int  PersonEducationWorkExperiences_DuplicationCheckBAL(WorkExperiences _objWorkExperiences, string pid)
 {
     return(DAL.PersonEducationWorkExperiences_DuplicationCheckDAL(_objWorkExperiences, pid));
 }
コード例 #18
0
 /// <summary>
 /// Persons the education work experiences delete dal.
 /// </summary>
 /// <param name="_objWorkExperiences">The object work experiences.</param>
 /// <returns>System.Int32.</returns>
 public int PersonEducationWorkExperiences_DeleteDAL(WorkExperiences _objWorkExperiences)
 {
     return(DAL.PersonEducationWorkExperiences_DeleteDAL(_objWorkExperiences));
 }