public int Delete(int ID) { tblSection tb = _db.tblSections.Where(s => s.Section_Id == ID).FirstOrDefault(); _db.tblSections.Remove(tb); return(_db.SaveChanges()); }
public int Update(SectionViewModel svm) { tblSection tb = _db.tblSections.Where(s => s.Section_Id == svm.Id).FirstOrDefault(); var secName = tb.Sec_Name; tb.Sec_Name = svm.Sec_Name; _db.SaveChanges(); tblMainLog tml = new tblMainLog(); var principal = System.Security.Claims.ClaimsPrincipal.Current; string Name = principal.FindFirst(ClaimsIdentity.DefaultNameClaimType).Value; str = "Section Name Updated from '" + secName + "' " + "to '" + svm.Sec_Name + "' " + "by Admin"; tml.Description = str; tml.AdminName = Name; tml.Date = System.DateTime.Now; tml.EntityId = 8; tml.ItemId = tb.Section_Id; _db.tblMainLogs.Add(tml); return(_db.SaveChanges()); }
public int Add(SectionViewModel svm) { tblSection tb = new tblSection(); tb.Sec_Name = svm.Sec_Name; _db.tblSections.Add(tb); _db.SaveChanges(); tblMainLog tml = new tblMainLog(); var principal = System.Security.Claims.ClaimsPrincipal.Current; string Name = principal.FindFirst(ClaimsIdentity.DefaultNameClaimType).Value; str = "New Section '" + svm.Sec_Name + "' " + "Added by Admin"; tml.Description = str; tml.AdminName = Name; tml.Date = System.DateTime.Now; tml.EntityId = 8; tml.ItemId = tb.Section_Id; _db.tblMainLogs.Add(tml); return(_db.SaveChanges()); }