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