public int DeleteSalaryBreakUpTemplate(int key)
{
TblSalaryBreakupTemplates tblSalaryBreakup = dbContext.TblSalaryBreakupTemplates.Where(x => x.SalarayTemplateId == key).FirstOrDefault();
tblSalaryBreakup.IsAcitve = false;
dbContext.TblSalaryBreakupTemplates.Update(tblSalaryBreakup);
return(dbContext.SaveChanges());
}
public int UpdateSalaryBreakUpTemplate(TblSalaryBreakupTemplates tblSalaryBreakup)
{
if (dbContext.TblSalaryBreakupTemplates.Where(r => r.TemplateName.ToUpper() == tblSalaryBreakup.TemplateName.ToUpper() && r.IsAcitve == true).Count() > 0)
{
return(-1);
}
tblSalaryBreakup.IsAcitve = true;
dbContext.Entry(tblSalaryBreakup).State = EntityState.Added;
dbContext.TblSalaryBreakupTemplates.Update(tblSalaryBreakup);
int result = dbContext.SaveChanges();
dbContext.Entry(tblSalaryBreakup).State = EntityState.Detached;
return(result);
}
public int UpdateSalaryBreakUpTemplate(string TemplateName, IFormFile formFile)
{
string FullFilePath = ImportFiletoFolder(formFile);
string[] ParsedResult = LoadSalarySheetFromPath(FullFilePath);
TblSalaryBreakupTemplates tblSalaryBreakup = new TblSalaryBreakupTemplates()
{
FormalsJson = ParsedResult[1],
IsAcitve = true,
TemplateName = TemplateName,
TemplateJson = ParsedResult[0]
};
return(MastersDAL.UpdateSalaryBreakUpTemplate(tblSalaryBreakup));
}
