public int RemoveCasePictureById(int cpId) { using (var context = new fyxmeContext()) { var cp = context.Cases.Find(cpId); //cp.Active = 0; context.Entry(cp).State = EntityState.Modified; return context.SaveChanges(); } }
public int RemoveCaseById(long CaseId) { using (var context = new fyxmeContext()) { var case1 = context.Cases.Find(CaseId); // If a real delete then we change the state to deleted and the equivalent SQL in Delete from Case... //context.Entry(case1).State = EntityState.Deleted; case1.Active = false; context.Entry(case1).State = EntityState.Modified; return context.SaveChanges(); } }
public int SaveUpdatedCasePicture(CasePicture cp) { using (var context = new fyxmeContext()) { context.Entry(cp).State = EntityState.Modified; return context.SaveChanges(); } }
public int SaveUpdatedCase(Case case1) { using (var context = new fyxmeContext()) { //context.Database.Log = message => SqlLogger("SaveUpdatedCase", message); //context.Database.Log = message => File.WriteAllText(@"C:\fyxWebAppDev\fyxme.WebApp001\SqlLogging\ll.txt").WriteLine(message); //context.Database.Log = SqlLog.Write; context.Entry(case1).State = EntityState.Modified; return context.SaveChanges(); } }