/// <summary>
/// Persons the skills interest delete dal.
/// </summary>
/// <param name="_objPersonSkillsInterest">The object person skills interest.</param>
/// <returns>System.Int32.</returns>
public int PersonSkillsInterest_DeleteDAL(PersonSkillsInterest _objPersonSkillsInterest)
{
return(ExecuteScalarInt32Sp("TMS_PersonSkillInterest_Delete",
ParamBuilder.Par("ID", _objPersonSkillsInterest.ID),
ParamBuilder.Par("UpdatedBy", _objPersonSkillsInterest.UpdatedBy),
ParamBuilder.Par("UpdatedDate", _objPersonSkillsInterest.UpdatedDate)));
}
/// <summary>
/// Persons the skills interest duplication check dal.
/// </summary>
/// <param name="_objPersonSkillsInterest">The object person skills interest.</param>
/// <returns>System.Int32.</returns>
public int PersonSkillsInterest_DuplicationCheckDAL(PersonSkillsInterest _objPersonSkillsInterest)
{
return(ExecuteScalarSPInt32("TMS_PersonSkillInterest_DuplicationCheck",
ParamBuilder.Par("PersonID", _objPersonSkillsInterest.PersonID),
ParamBuilder.Par("Title", _objPersonSkillsInterest.Title),
ParamBuilder.Par("Type", _objPersonSkillsInterest.Type)));
}
public ActionResult PersonSkill_Update([DataSourceRequest] DataSourceRequest request, PersonSkill _objPersonSkill)
{
if (ModelState.IsValid)
{
PersonSkillsInterest _objSkillsInterest = new PersonSkillsInterest();
_objSkillsInterest.UpdatedBy = CurrentUser.NameIdentifierInt64;
_objSkillsInterest.UpdatedDate = DateTime.Now;
_objSkillsInterest.Title = _objPersonSkill.Title;
_objSkillsInterest.Description = "";
_objSkillsInterest.ID = _objPersonSkill.ID;
_objSkillsInterest.Type = PersonSKillInterest.PersonSKillInterest_Person_Skills;
if (_objISkillsInterestLevelBAL.PersonSkillsInterest_DuplicationCheckBAL(_objSkillsInterest) > 0)
{
ModelState.AddModelError(lr.PersonSkill, lr.PersonSkillDuplicationCheck);
}
else
{
var result = _objISkillsInterestLevelBAL.PersonSkillsInterest_UpdateBAL(_objSkillsInterest);
if (result == -1)
{
ModelState.AddModelError(lr.ErrorServerError, lr.ResourceUpdateValidationError);
}
}
}
var resultData = new[] { _objPersonSkill };
return(Json(resultData.AsQueryable().ToDataSourceResult(request, ModelState)));
}
public ActionResult PersonInterest_Create([DataSourceRequest] DataSourceRequest request, string pid, PersonInterest _objPersonInterest)
{
if (ModelState.IsValid)
{
PersonSkillsInterest _objSkillsInterest = new PersonSkillsInterest();
_objSkillsInterest.CreatedBy = CurrentUser.NameIdentifierInt64;
_objSkillsInterest.PersonID = Convert.ToInt64(pid);
_objSkillsInterest.OrganizationID = CurrentUser.CompanyID;
_objSkillsInterest.CreatedDate = DateTime.Now;
_objSkillsInterest.Title = _objPersonInterest.Title;
_objSkillsInterest.Description = "";
_objSkillsInterest.Type = PersonSKillInterest.PersonSKillInterest_Field_Of_Interest;
if (_objISkillsInterestLevelBAL.PersonSkillsInterest_DuplicationCheckBAL(_objSkillsInterest) > 0)
{
ModelState.AddModelError(lr.PersonFieldofInterest, lr.PersonFieldofInterestDuplicationCheck);
}
else
{
_objPersonInterest.ID = _objISkillsInterestLevelBAL.PersonSkillsInterest_CreateBAL(_objSkillsInterest);
}
}
var resultData = new[] { _objPersonInterest };
return(Json(resultData.ToDataSourceResult(request, ModelState)));
}
/// <summary>
/// Persons the skills interest update dal.
/// </summary>
/// <param name="_objPersonSkillsInterest">The object person skills interest.</param>
/// <returns>System.Int32.</returns>
public int PersonSkillsInterest_UpdateDAL(PersonSkillsInterest _objPersonSkillsInterest)
{
return(ExecuteScalarInt32Sp("TMS_PersonSkillInterest_Update",
ParamBuilder.Par("ID", _objPersonSkillsInterest.ID),
ParamBuilder.Par("Title", _objPersonSkillsInterest.Title),
ParamBuilder.Par("Description", _objPersonSkillsInterest.Description),
ParamBuilder.Par("UpdatedBy", _objPersonSkillsInterest.UpdatedBy),
ParamBuilder.Par("UpdatedDate", _objPersonSkillsInterest.UpdatedDate)));
}
/// <summary>
/// Persons the skills interest create dal.
/// </summary>
/// <param name="_objPersonSkillsInterest">The object person skills interest.</param>
/// <returns>System.Int64.</returns>
public long PersonSkillsInterest_CreateDAL(PersonSkillsInterest _objPersonSkillsInterest)
{
var parameters = new[] { ParamBuilder.Par("ID", 0) };
return(ExecuteInt64withOutPutparameterSp("TMS_PersonSkillInterest_Create", parameters,
ParamBuilder.Par("OrganizationID", _objPersonSkillsInterest.OrganizationID),
ParamBuilder.Par("PersonID", _objPersonSkillsInterest.PersonID),
ParamBuilder.Par("Title", _objPersonSkillsInterest.Title),
ParamBuilder.Par("Type", _objPersonSkillsInterest.Type),
ParamBuilder.Par("Description", _objPersonSkillsInterest.Description),
ParamBuilder.Par("CreatedBy", _objPersonSkillsInterest.CreatedBy),
ParamBuilder.Par("CreatedDate", _objPersonSkillsInterest.CreatedDate)));
}
public ActionResult PersonSkill_Destroy([DataSourceRequest] DataSourceRequest request, PersonSkill _objPersonSkill)
{
if (ModelState.IsValid)
{
PersonSkillsInterest _objSkillsInterest = new PersonSkillsInterest();
_objSkillsInterest.UpdatedBy = CurrentUser.NameIdentifierInt64;
_objSkillsInterest.UpdatedDate = DateTime.Now;
_objSkillsInterest.ID = _objPersonSkill.ID;
var result = _objISkillsInterestLevelBAL.PersonSkillsInterest_DeleteBAL(_objSkillsInterest);
if (result == -1)
{
ModelState.AddModelError(lr.ErrorServerError, lr.ResourceUpdateValidationError);
}
}
var resultData = new[] { _objPersonSkill };
return(Json(resultData.AsQueryable().ToDataSourceResult(request, ModelState)));
}
/// <summary>
/// Persons the skills interest create bal.
/// </summary>
/// <param name="_objPersonSkillsInterest">The object person skills interest.</param>
/// <returns>System.Int64.</returns>
public long PersonSkillsInterest_CreateBAL(PersonSkillsInterest _objPersonSkillsInterest)
{
return(DAL.PersonSkillsInterest_CreateDAL(_objPersonSkillsInterest));
}
/// <summary>
/// Persons the skills interest duplication check bal.
/// </summary>
/// <param name="_objPersonSkillsInterest">The object person skills interest.</param>
/// <returns>System.Int32.</returns>
public int PersonSkillsInterest_DuplicationCheckBAL(PersonSkillsInterest _objPersonSkillsInterest)
{
return(DAL.PersonSkillsInterest_DuplicationCheckDAL(_objPersonSkillsInterest));
}
/// <summary>
/// Persons the skills interest delete bal.
/// </summary>
/// <param name="_objPersonSkillsInterest">The object person skills interest.</param>
/// <returns>System.Int32.</returns>
public int PersonSkillsInterest_DeleteBAL(PersonSkillsInterest _objPersonSkillsInterest)
{
return(DAL.PersonSkillsInterest_DeleteDAL(_objPersonSkillsInterest));
}
