/// <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)
));
}
