public async Task Insert(ProbationView entity)
{
try
{
//Insert New Probation
var vList = new Probation
{
Prob_Id = entity.Prob_Id,
Company_Id = entity.Company_Id,
Prob_Code = entity.Prob_Code,
Prob_Name = entity.Prob_Name,
Prob_Description = entity.Prob_Description,
Prob_DurationUnit = entity.Prob_DurationUnit,
Prob_Duration = entity.Prob_Duration,
Notes = entity.Notes,
isActive = entity.isActive,
AddedBy = entity.AddedBy,
AddedOn = DateTime.Now
};
adbContext.probation.Add(vList);
await Task.FromResult(adbContext.SaveChanges());
}
catch (Exception ex)
{
throw ex;
}
}
public async Task Update(ProbationView entity)
{
var lstProb = adbContext.probation.Where(x => x.Prob_Id == entity.Prob_Id).FirstOrDefault();
if (lstProb != null)
{
try
{
//lstProb.Prob_Id = entity.Prob_Id;
lstProb.Company_Id = entity.Company_Id;
lstProb.Prob_Code = entity.Prob_Code;
lstProb.Prob_Name = entity.Prob_Name;
lstProb.Prob_Description = entity.Prob_Description;
lstProb.Prob_DurationUnit = entity.Prob_DurationUnit;
lstProb.Prob_Duration = entity.Prob_Duration;
lstProb.isActive = entity.isActive;
lstProb.UpdatedBy = entity.UpdatedBy;
lstProb.UpdatedOn = DateTime.Now;
adbContext.probation.Update(lstProb);
await Task.FromResult(adbContext.SaveChanges());
}
catch (Exception ex)
{
throw ex;
}
}
}
public async Task <IActionResult> Edit(ProbationView probation)
{
ResponseHelper objHelper = new ResponseHelper();
if (!ModelState.IsValid)
{
objHelper.Status = StatusCodes.Status424FailedDependency;
objHelper.Message = "Invalid Model State";
return(BadRequest(objHelper));
}
try
{
if (probationRepository.Exists(probation))
{
objHelper.Status = StatusCodes.Status200OK;
objHelper.Message = "Data already available";
return(Ok(objHelper));
}
await probationRepository.Update(probation);
objHelper.Status = StatusCodes.Status200OK;
objHelper.Message = "Saved Successfully";
return(Ok(objHelper));
}
catch
{
objHelper.Status = StatusCodes.Status500InternalServerError;
objHelper.Message = "Save Unsuccessful";
return(StatusCode(StatusCodes.Status500InternalServerError, objHelper));
}
}
public bool Exists(ProbationView entity)
{
try
{
int intCount = 0;
if (entity.Prob_Id > 0)
{
intCount = adbContext.probation.Where(w => w.Prob_Id != entity.Prob_Id && (w.Prob_Code == entity.Prob_Code || w.Prob_Name == entity.Prob_Name)).Count();
}
else
{
intCount = adbContext.probation.Where(w => w.Prob_Code == entity.Prob_Code || w.Prob_Name == entity.Prob_Name).Count();
}
return(intCount > 0 ? true : false);
}
catch (Exception ex)
{
throw ex;
}
}
