/// <summary> /// Persons the skills interest delete dal. /// </summary> /// <param name="_objPersonSkillsInterest">The object person skills interest.</param> /// <returns>System.Int32.</returns> public int PersonSkillsInterest_DeleteDAL(PersonSkillsInterest _objPersonSkillsInterest) { return(ExecuteScalarInt32Sp("TMS_PersonSkillInterest_Delete", ParamBuilder.Par("ID", _objPersonSkillsInterest.ID), ParamBuilder.Par("UpdatedBy", _objPersonSkillsInterest.UpdatedBy), ParamBuilder.Par("UpdatedDate", _objPersonSkillsInterest.UpdatedDate))); }
/// <summary> /// Persons the skills interest duplication check dal. /// </summary> /// <param name="_objPersonSkillsInterest">The object person skills interest.</param> /// <returns>System.Int32.</returns> public int PersonSkillsInterest_DuplicationCheckDAL(PersonSkillsInterest _objPersonSkillsInterest) { return(ExecuteScalarSPInt32("TMS_PersonSkillInterest_DuplicationCheck", ParamBuilder.Par("PersonID", _objPersonSkillsInterest.PersonID), ParamBuilder.Par("Title", _objPersonSkillsInterest.Title), ParamBuilder.Par("Type", _objPersonSkillsInterest.Type))); }
public ActionResult PersonSkill_Update([DataSourceRequest] DataSourceRequest request, PersonSkill _objPersonSkill) { if (ModelState.IsValid) { PersonSkillsInterest _objSkillsInterest = new PersonSkillsInterest(); _objSkillsInterest.UpdatedBy = CurrentUser.NameIdentifierInt64; _objSkillsInterest.UpdatedDate = DateTime.Now; _objSkillsInterest.Title = _objPersonSkill.Title; _objSkillsInterest.Description = ""; _objSkillsInterest.ID = _objPersonSkill.ID; _objSkillsInterest.Type = PersonSKillInterest.PersonSKillInterest_Person_Skills; if (_objISkillsInterestLevelBAL.PersonSkillsInterest_DuplicationCheckBAL(_objSkillsInterest) > 0) { ModelState.AddModelError(lr.PersonSkill, lr.PersonSkillDuplicationCheck); } else { var result = _objISkillsInterestLevelBAL.PersonSkillsInterest_UpdateBAL(_objSkillsInterest); if (result == -1) { ModelState.AddModelError(lr.ErrorServerError, lr.ResourceUpdateValidationError); } } } var resultData = new[] { _objPersonSkill }; return(Json(resultData.AsQueryable().ToDataSourceResult(request, ModelState))); }
public ActionResult PersonInterest_Create([DataSourceRequest] DataSourceRequest request, string pid, PersonInterest _objPersonInterest) { if (ModelState.IsValid) { PersonSkillsInterest _objSkillsInterest = new PersonSkillsInterest(); _objSkillsInterest.CreatedBy = CurrentUser.NameIdentifierInt64; _objSkillsInterest.PersonID = Convert.ToInt64(pid); _objSkillsInterest.OrganizationID = CurrentUser.CompanyID; _objSkillsInterest.CreatedDate = DateTime.Now; _objSkillsInterest.Title = _objPersonInterest.Title; _objSkillsInterest.Description = ""; _objSkillsInterest.Type = PersonSKillInterest.PersonSKillInterest_Field_Of_Interest; if (_objISkillsInterestLevelBAL.PersonSkillsInterest_DuplicationCheckBAL(_objSkillsInterest) > 0) { ModelState.AddModelError(lr.PersonFieldofInterest, lr.PersonFieldofInterestDuplicationCheck); } else { _objPersonInterest.ID = _objISkillsInterestLevelBAL.PersonSkillsInterest_CreateBAL(_objSkillsInterest); } } var resultData = new[] { _objPersonInterest }; return(Json(resultData.ToDataSourceResult(request, ModelState))); }
/// <summary> /// Persons the skills interest update dal. /// </summary> /// <param name="_objPersonSkillsInterest">The object person skills interest.</param> /// <returns>System.Int32.</returns> public int PersonSkillsInterest_UpdateDAL(PersonSkillsInterest _objPersonSkillsInterest) { return(ExecuteScalarInt32Sp("TMS_PersonSkillInterest_Update", ParamBuilder.Par("ID", _objPersonSkillsInterest.ID), ParamBuilder.Par("Title", _objPersonSkillsInterest.Title), ParamBuilder.Par("Description", _objPersonSkillsInterest.Description), ParamBuilder.Par("UpdatedBy", _objPersonSkillsInterest.UpdatedBy), ParamBuilder.Par("UpdatedDate", _objPersonSkillsInterest.UpdatedDate))); }
/// <summary> /// Persons the skills interest create dal. /// </summary> /// <param name="_objPersonSkillsInterest">The object person skills interest.</param> /// <returns>System.Int64.</returns> public long PersonSkillsInterest_CreateDAL(PersonSkillsInterest _objPersonSkillsInterest) { var parameters = new[] { ParamBuilder.Par("ID", 0) }; return(ExecuteInt64withOutPutparameterSp("TMS_PersonSkillInterest_Create", parameters, ParamBuilder.Par("OrganizationID", _objPersonSkillsInterest.OrganizationID), ParamBuilder.Par("PersonID", _objPersonSkillsInterest.PersonID), ParamBuilder.Par("Title", _objPersonSkillsInterest.Title), ParamBuilder.Par("Type", _objPersonSkillsInterest.Type), ParamBuilder.Par("Description", _objPersonSkillsInterest.Description), ParamBuilder.Par("CreatedBy", _objPersonSkillsInterest.CreatedBy), ParamBuilder.Par("CreatedDate", _objPersonSkillsInterest.CreatedDate))); }
public ActionResult PersonSkill_Destroy([DataSourceRequest] DataSourceRequest request, PersonSkill _objPersonSkill) { if (ModelState.IsValid) { PersonSkillsInterest _objSkillsInterest = new PersonSkillsInterest(); _objSkillsInterest.UpdatedBy = CurrentUser.NameIdentifierInt64; _objSkillsInterest.UpdatedDate = DateTime.Now; _objSkillsInterest.ID = _objPersonSkill.ID; var result = _objISkillsInterestLevelBAL.PersonSkillsInterest_DeleteBAL(_objSkillsInterest); if (result == -1) { ModelState.AddModelError(lr.ErrorServerError, lr.ResourceUpdateValidationError); } } var resultData = new[] { _objPersonSkill }; return(Json(resultData.AsQueryable().ToDataSourceResult(request, ModelState))); }
/// <summary> /// Persons the skills interest create bal. /// </summary> /// <param name="_objPersonSkillsInterest">The object person skills interest.</param> /// <returns>System.Int64.</returns> public long PersonSkillsInterest_CreateBAL(PersonSkillsInterest _objPersonSkillsInterest) { return(DAL.PersonSkillsInterest_CreateDAL(_objPersonSkillsInterest)); }
/// <summary> /// Persons the skills interest duplication check bal. /// </summary> /// <param name="_objPersonSkillsInterest">The object person skills interest.</param> /// <returns>System.Int32.</returns> public int PersonSkillsInterest_DuplicationCheckBAL(PersonSkillsInterest _objPersonSkillsInterest) { return(DAL.PersonSkillsInterest_DuplicationCheckDAL(_objPersonSkillsInterest)); }
/// <summary> /// Persons the skills interest delete bal. /// </summary> /// <param name="_objPersonSkillsInterest">The object person skills interest.</param> /// <returns>System.Int32.</returns> public int PersonSkillsInterest_DeleteBAL(PersonSkillsInterest _objPersonSkillsInterest) { return(DAL.PersonSkillsInterest_DeleteDAL(_objPersonSkillsInterest)); }