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