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 SaveNewCasePicture(CasePicture cp) { using (var context = new fyxmeContext()) { context.CasePictures.Add(cp); return context.SaveChanges(); } }
public int SaveUpdatedCasePicture(CasePicture cp) { using (var context = new fyxmeContext()) { 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 SaveNewCase(Case case1) { using (var context = new fyxmeContext()) { context.Cases.Add(case1); 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(); } }
/// <summary> /// AddTechnician /// </summary> /// <param name="tech"></param> /// <returns></returns> public long AddTechician(Technician tech) { using (var context = new fyxmeContext()) { context.Technicians.Add(tech); context.SaveChanges(); return tech.TechnicianId; } }
/// <summary> /// AddLead /// </summary> /// <param name="lead"></param> /// <returns></returns> public long AddLead(Lead lead) { using (var context = new fyxmeContext()) { context.Leads.Add(lead); context.SaveChanges(); return lead.Cases.ElementAt(0).CaseNo; } }