/// <summary> /// Persons the education work achievements duplication check dal. /// </summary> /// <param name="_objPersonAchievements">The object person achievements.</param> /// <param name="pid">The pid.</param> /// <returns>System.Int32.</returns> public int PersonEducationWorkAchievements_DuplicationCheckDAL(PersonAchievements _objPersonAchievements, string pid) { return(ExecuteScalarSPInt32("TMS_PersonEducationAchievements_DuplicationCheck", ParamBuilder.Par("PersonID", pid), ParamBuilder.Par("Type", _objPersonAchievements.Type), ParamBuilder.Par("AnnouncedDate", _objPersonAchievements.AnnouncedDate))); }
/// <summary> /// Persons the education work achievements delete dal. /// </summary> /// <param name="_objPersonAchievements">The object person achievements.</param> /// <returns>System.Int32.</returns> public int PersonEducationWorkAchievements_DeleteDAL(PersonAchievements _objPersonAchievements) { return(ExecuteScalarInt32Sp("TMS_PersonEducationAchievements_Delete", ParamBuilder.Par("ID", _objPersonAchievements.ID), ParamBuilder.Par("UpdatedBy", _objPersonAchievements.UpdatedBy), ParamBuilder.Par("UpdatedDate", _objPersonAchievements.UpdatedDate))); }
/// <summary> /// Persons the education work achievements update dal. /// </summary> /// <param name="_objPersonAchievements">The object person achievements.</param> /// <returns>System.Int32.</returns> public int PersonEducationWorkAchievements_UpdateDAL(PersonAchievements _objPersonAchievements) { return(ExecuteScalarInt32Sp("TMS_PersonEducationAchievements_Update", ParamBuilder.Par("ID", _objPersonAchievements.ID), ParamBuilder.Par("P_Title", _objPersonAchievements.P_Title), ParamBuilder.Par("S_Title", _objPersonAchievements.S_Title), ParamBuilder.Par("Type", _objPersonAchievements.Type), ParamBuilder.Par("AnnouncedDate", _objPersonAchievements.AnnouncedDate), ParamBuilder.Par("Description", _objPersonAchievements.Description), ParamBuilder.Par("UpdatedBy", _objPersonAchievements.UpdatedBy), ParamBuilder.Par("UpdatedDate", _objPersonAchievements.UpdatedDate))); }
/// <summary> /// Persons the education work achievements create dal. /// </summary> /// <param name="_objPersonAchievements">The object person achievements.</param> /// <returns>System.Int64.</returns> public long PersonEducationWorkAchievements_CreateDAL(PersonAchievements _objPersonAchievements) { var parameters = new[] { ParamBuilder.Par("ID", 0) }; return(ExecuteInt64withOutPutparameterSp("TMS_PersonEducationAchievements_Create", parameters, ParamBuilder.Par("PersonID", _objPersonAchievements.PersonID), ParamBuilder.Par("P_Title", _objPersonAchievements.P_Title), ParamBuilder.Par("S_Title", _objPersonAchievements.S_Title), ParamBuilder.Par("Type", _objPersonAchievements.Type), ParamBuilder.Par("AnnouncedDate", _objPersonAchievements.AnnouncedDate), ParamBuilder.Par("Description", _objPersonAchievements.Description), ParamBuilder.Par("CreatedBy", _objPersonAchievements.CreatedBy), ParamBuilder.Par("CreatedDate", _objPersonAchievements.CreatedDate))); }
public ActionResult PersonAchievement_Destroy([DataSourceRequest] DataSourceRequest request, PersonAchievements _personPersonAchievements) { if (ModelState.IsValid) { _personPersonAchievements.UpdatedBy = CurrentUser.NameIdentifierInt64; _personPersonAchievements.UpdatedDate = DateTime.Now; var result = _PersonEducationBAL.PersonEducationWorkAchievements_DeleteBAL(_personPersonAchievements); if (result == -1) { ModelState.AddModelError(lr.ErrorServerError, lr.ResourceUpdateValidationError); } } var resultData = new[] { _personPersonAchievements }; return(Json(resultData.AsQueryable().ToDataSourceResult(request, ModelState))); }
public ActionResult PersonAchievement_Create([DataSourceRequest] DataSourceRequest request, string pid, PersonAchievements _personPersonAchievements) { if (ModelState.IsValid) { if (_PersonEducationBAL.PersonEducationWorkAchievements_DuplicationCheckBAL(_personPersonAchievements, pid) == 0) { _personPersonAchievements.CreatedBy = CurrentUser.NameIdentifierInt64; _personPersonAchievements.CreatedDate = DateTime.Now; _personPersonAchievements.PersonID = Convert.ToInt64(pid); var result = _PersonEducationBAL.PersonEducationWorkAchievements_CreateBAL(_personPersonAchievements); if (result == -1) { ModelState.AddModelError(lr.ErrorServerError, lr.PersonEducationCertificationsDuplicationMessage); } else { _personPersonAchievements.ID = result; } } else { ModelState.AddModelError(lr.PersonEducationWorkExperiencesTimePeriod, lr.PersonEducationAchievementDuplication); } } var resultData = new[] { _personPersonAchievements }; return(Json(resultData.ToDataSourceResult(request, ModelState))); }
/// <summary> /// Persons the education work achievements duplication check bal. /// </summary> /// <param name="_objPersonAchievements">The object person achievements.</param> /// <param name="pid">The pid.</param> /// <returns>System.Int32.</returns> public int PersonEducationWorkAchievements_DuplicationCheckBAL(PersonAchievements _objPersonAchievements, string pid) { return(DAL.PersonEducationWorkAchievements_DuplicationCheckDAL(_objPersonAchievements, pid)); }
/// <summary> /// Persons the education work achievements delete bal. /// </summary> /// <param name="_objPersonAchievements">The object person achievements.</param> /// <returns>System.Int32.</returns> public int PersonEducationWorkAchievements_DeleteBAL(PersonAchievements _objPersonAchievements) { return(DAL.PersonEducationWorkAchievements_DeleteDAL(_objPersonAchievements)); }
/// <summary> /// Persons the education work achievements create bal. /// </summary> /// <param name="_objPersonAchievements">The object person achievements.</param> /// <returns>System.Int64.</returns> public long PersonEducationWorkAchievements_CreateBAL(PersonAchievements _objPersonAchievements) { return(DAL.PersonEducationWorkAchievements_CreateDAL(_objPersonAchievements)); }