/// <summary>
/// Persons the education certifications delete dal.
/// </summary>
/// <param name="_objEducation">The object education.</param>
/// <returns>System.Int32.</returns>
public int PersonEducationCertifications_DeleteDAL(PersonCertifications _objEducation)
{
return(ExecuteScalarInt32Sp("TMS_PersonEducationCertifications_Delete",
ParamBuilder.Par("ID", _objEducation.ID),
ParamBuilder.Par("UpdatedBy", _objEducation.UpdatedBy),
ParamBuilder.Par("UpdatedDate", _objEducation.UpdatedDate)));
}
/// <summary>
/// Persons the education certifications update dal.
/// </summary>
/// <param name="_objEducation">The object education.</param>
/// <returns>System.Int32.</returns>
public int PersonEducationCertifications_UpdateDAL(PersonCertifications _objEducation)
{
return(ExecuteScalarInt32Sp("TMS_PersonEducationCertifications_Update",
ParamBuilder.Par("ID", _objEducation.ID),
ParamBuilder.Par("CertificationP_Name", _objEducation.CertificationP_Name),
ParamBuilder.Par("CertificationS_Name", _objEducation.CertificationS_Name),
ParamBuilder.Par("CertificationDurationType", _objEducation.CertificationDurationType),
ParamBuilder.Par("CertificationDuration", _objEducation.CertificationDuration),
ParamBuilder.Par("CertificationReferenceNo", _objEducation.CertificationReferenceNo),
ParamBuilder.Par("CompletionYear", _objEducation.CompletionYear),
ParamBuilder.Par("AwardingBody", _objEducation.AwardingBody),
ParamBuilder.Par("Institute", _objEducation.Institute),
ParamBuilder.Par("ValidityDuration", _objEducation.ValidityDuration),
ParamBuilder.Par("UpdatedBy", _objEducation.UpdatedBy),
ParamBuilder.Par("UpdatedDate", _objEducation.UpdatedDate)));
}
/// <summary>
/// Persons the education certifications create dal.
/// </summary>
/// <param name="_objEducation">The object education.</param>
/// <returns>System.Int64.</returns>
public long PersonEducationCertifications_CreateDAL(PersonCertifications _objEducation)
{
var parameters = new[] { ParamBuilder.Par("ID", 0) };
return(ExecuteInt64withOutPutparameterSp("TMS_PersonEducationCertifications_Create", parameters,
ParamBuilder.Par("PersonID", _objEducation.PersonID),
ParamBuilder.Par("CertificationP_Name", _objEducation.CertificationP_Name),
ParamBuilder.Par("CertificationS_Name", _objEducation.CertificationS_Name),
ParamBuilder.Par("CertificationDurationType", _objEducation.CertificationDurationType),
ParamBuilder.Par("CertificationDuration", _objEducation.CertificationDuration),
ParamBuilder.Par("CertificationReferenceNo", _objEducation.CertificationReferenceNo),
ParamBuilder.Par("CompletionYear", _objEducation.CompletionYear),
ParamBuilder.Par("AwardingBody", _objEducation.AwardingBody),
ParamBuilder.Par("Institute", _objEducation.Institute),
ParamBuilder.Par("ValidityDuration", _objEducation.ValidityDuration),
ParamBuilder.Par("CreatedBy", _objEducation.CreatedBy),
ParamBuilder.Par("CreatedDate", _objEducation.CreatedDate)));
}
public ActionResult PersonCertifications_Destroy([DataSourceRequest] DataSourceRequest request, PersonCertifications _personCertifications)
{
if (ModelState.IsValid)
{
_personCertifications.UpdatedBy = CurrentUser.NameIdentifierInt64;
_personCertifications.UpdatedDate = DateTime.Now;
var result = _PersonEducationBAL.PersonEducationCertifications_DeleteBAL(_personCertifications);
if (result == -1)
{
ModelState.AddModelError(lr.ErrorServerError, lr.ResourceUpdateValidationError);
}
}
var resultData = new[] { _personCertifications };
return(Json(resultData.AsQueryable().ToDataSourceResult(request, ModelState)));
}
public ActionResult PersonCertifications_Create([DataSourceRequest] DataSourceRequest request, string pid, PersonCertifications _personCertifications)
{
if (ModelState.IsValid)
{
if (_PersonEducationBAL.PersonEducationCertifications_CheckDuplicationBAL(_personCertifications) == 0)
{
_personCertifications.CreatedBy = CurrentUser.NameIdentifierInt64;
_personCertifications.CreatedDate = DateTime.Now;
_personCertifications.PersonID = Convert.ToInt64(pid);
_personCertifications.ID = _PersonEducationBAL.PersonEducationCertifications_CreateBAL(_personCertifications);
}
else
{
ModelState.AddModelError(lr.ErrorServerError, lr.PersonEducationCertificationsDuplicationMessage);
}
}
var resultData = new[] { _personCertifications };
return(Json(resultData.ToDataSourceResult(request, ModelState)));
}
//certifications
/// <summary>
/// Persons the education certifications create bal.
/// </summary>
/// <param name="_objEducation">The object education.</param>
/// <returns>System.Int64.</returns>
public long PersonEducationCertifications_CreateBAL(PersonCertifications _objEducation)
{
return(DAL.PersonEducationCertifications_CreateDAL(_objEducation));
}
/// <summary>
/// Persons the education certifications check duplication bal.
/// </summary>
/// <param name="_objEducation">The object education.</param>
/// <returns>System.Int32.</returns>
public int PersonEducationCertifications_CheckDuplicationBAL(PersonCertifications _objEducation)
{
return(DAL.PersonEducationCertifications_CheckDuplicationDAL(_objEducation));
}
/// <summary>
/// Persons the education certifications delete bal.
/// </summary>
/// <param name="_objEducation">The object education.</param>
/// <returns>System.Int32.</returns>
public int PersonEducationCertifications_DeleteBAL(PersonCertifications _objEducation)
{
return(DAL.PersonEducationCertifications_DeleteDAL(_objEducation));
}
/// <summary>
/// Persons the education certifications check duplication dal.
/// </summary>
/// <param name="_objEducation">The object education.</param>
/// <returns>System.Int32.</returns>
public int PersonEducationCertifications_CheckDuplicationDAL(PersonCertifications _objEducation)
{
return(ExecuteScalarInt32(string.Format("SELECT count(*) FROM dbo.PersonEducationCertifications WHERE (CertificationReferenceNo='{0}' or CertificationP_Name='{1}' ) AND IsDeleted=0", _objEducation.CertificationReferenceNo, _objEducation.CertificationP_Name)));
}