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