/// <summary> /// Persons the education degrees delete dal. /// </summary> /// <param name="_Degrees">The degrees.</param> /// <returns>System.Int32.</returns> public int PersonEducationDegrees_DeleteDAL(PersonDegrees _Degrees) { return(ExecuteScalarInt32Sp("TMS_PersonEducationDegrees_Delete", ParamBuilder.Par("ID", _Degrees.ID), ParamBuilder.Par("UpdatedBy", _Degrees.UpdatedBy), ParamBuilder.Par("UpdatedDate", _Degrees.UpdatedDate))); }
/// <summary> /// Persons the education degrees update dal. /// </summary> /// <param name="_Degrees">The degrees.</param> /// <returns>System.Int32.</returns> public int PersonEducationDegrees_UpdateDAL(PersonDegrees _Degrees) { return(ExecuteScalarInt32Sp("TMS_PersonEducationDegrees_Update", ParamBuilder.Par("ID", _Degrees.ID), ParamBuilder.Par("P_Title", _Degrees.P_Title), ParamBuilder.Par("S_Title", _Degrees.S_Title), ParamBuilder.Par("University", _Degrees.University), ParamBuilder.Par("Result", _Degrees.Result), ParamBuilder.Par("ResultTypeID", _Degrees.ResultTypeID), ParamBuilder.Par("Session", _Degrees.Session), ParamBuilder.Par("Duration", _Degrees.Duration), ParamBuilder.Par("Major", _Degrees.Major), ParamBuilder.Par("DegreeStatus", _Degrees.DegreeStatus), ParamBuilder.Par("Description", _Degrees.Description), ParamBuilder.Par("UpdatedBy", _Degrees.UpdatedBy), ParamBuilder.Par("UpdatedDate", _Degrees.UpdatedDate))); }
/// <summary> /// Persons the education degrees create dal. /// </summary> /// <param name="_Degrees">The degrees.</param> /// <returns>System.Int64.</returns> public long PersonEducationDegrees_CreateDAL(PersonDegrees _Degrees) { var parameters = new[] { ParamBuilder.Par("ID", 0) }; return(ExecuteInt64withOutPutparameterSp("TMS_PersonEducationDegrees_Create", parameters, ParamBuilder.Par("PersonID", _Degrees.PersonID), ParamBuilder.Par("P_Title", _Degrees.P_Title), ParamBuilder.Par("S_Title", _Degrees.S_Title), ParamBuilder.Par("University", _Degrees.University), ParamBuilder.Par("Result", _Degrees.Result), ParamBuilder.Par("ResultTypeID", _Degrees.ResultTypeID), ParamBuilder.Par("Session", _Degrees.Session), ParamBuilder.Par("Duration", _Degrees.Duration), ParamBuilder.Par("Major", _Degrees.Major), ParamBuilder.Par("DegreeStatus", _Degrees.DegreeStatus), ParamBuilder.Par("Description", _Degrees.Description), ParamBuilder.Par("CreatedBy", _Degrees.CreatedBy), ParamBuilder.Par("CreatedDate", _Degrees.CreatedDate))); }
public ActionResult PersonDegree_Destroy([DataSourceRequest] DataSourceRequest request, PersonDegrees _personDegree) { if (ModelState.IsValid) { _personDegree.UpdatedBy = CurrentUser.NameIdentifierInt64; _personDegree.UpdatedDate = DateTime.Now; var result = _PersonEducationBAL.PersonEducationDegrees_DeleteBAL(_personDegree); if (result == -1) { ModelState.AddModelError(lr.ErrorServerError, lr.ResourceUpdateValidationError); } } var resultData = new[] { _personDegree }; return(Json(resultData.AsQueryable().ToDataSourceResult(request, ModelState))); }
public ActionResult PersonDegree_Create([DataSourceRequest] DataSourceRequest request, string pid, PersonDegrees _personDegree) { if (ModelState.IsValid) { if (this._PersonEducationBAL.Degree_DuplicationCheckBAL(_personDegree) > 0) { return(Json(lr.UserEmailAlreadyExist, JsonRequestBehavior.AllowGet)); } else { _personDegree.CreatedBy = CurrentUser.NameIdentifierInt64; _personDegree.CreatedDate = DateTime.Now; _personDegree.PersonID = Convert.ToInt64(pid); _personDegree.ID = _PersonEducationBAL.PersonEducationDegrees_CreateBAL(_personDegree); } } var resultData = new[] { _personDegree }; return(Json(resultData.ToDataSourceResult(request, ModelState))); }
public ActionResult PersonDegree_Update([DataSourceRequest] DataSourceRequest request, PersonDegrees _personDegree) { if (ModelState.IsValid) { if (this._PersonEducationBAL.Degree_DuplicationCheckBAL(_personDegree) > 0) { ModelState.AddModelError(lr.EducationEducationDublication, lr.EducationEducationDublication); // return Json(lr.DegreeCertificatesPrimaryNameDuplicate, JsonRequestBehavior.AllowGet); } else { _personDegree.UpdatedBy = CurrentUser.NameIdentifierInt64; _personDegree.UpdatedDate = DateTime.Now; var result = _PersonEducationBAL.PersonEducationDegrees_UpdateBAL(_personDegree); if (result == -1) { ModelState.AddModelError(lr.ErrorServerError, lr.ResourceUpdateValidationError); } } } var resultData = new[] { _personDegree }; return(Json(resultData.AsQueryable().ToDataSourceResult(request, ModelState))); }
/// <summary> /// Persons the education degrees delete bal. /// </summary> /// <param name="_Degrees">The degrees.</param> /// <returns>System.Int32.</returns> public int PersonEducationDegrees_DeleteBAL(PersonDegrees _Degrees) { return(DAL.PersonEducationDegrees_DeleteDAL(_Degrees)); }
/// <summary> /// Persons the education degrees create bal. /// </summary> /// <param name="_Degrees">The degrees.</param> /// <returns>System.Int64.</returns> public long PersonEducationDegrees_CreateBAL(PersonDegrees _Degrees) { return(DAL.PersonEducationDegrees_CreateDAL(_Degrees)); }
public int Degree_DuplicationCheckBAL(PersonDegrees _Degrees) { return(DAL.Degree_DuplicationCheckDAL(_Degrees)); }
public int Degree_DuplicationCheckDAL(PersonDegrees _Degrees) { return(ExecuteScalarSPInt32("TMS_Degree_DuplicationCheck", ParamBuilder.Par("P_Title", _Degrees.P_Title) )); }