/// <summary>
/// GetCarYears
/// </summary>
/// <param name="carModel"></param>
/// <returns></returns>
public IEnumerable GetCarYears(string carModel)
{
using (var context = new fyxmeContext())
{
return context.CarMMYs.AsNoTracking()
.Where(c => c.Active == true && c.CarModel == carModel)
.Select(c => new { c.CarYear }).Distinct()
.OrderBy(c => c.CarYear)
.ToList();
}
}
/// <summary>
/// GetCarMakers
/// </summary>
/// <returns></returns>
public IEnumerable GetCarMakes()
{
using (var context = new fyxmeContext())
{
return context.CarMMYs.AsNoTracking()
.Where(c => c.Active == true)
.Select(c => new { c.CarMake }).Distinct()
.OrderBy(c => c.CarMake)
.ToList();
}
}
public int SaveUpdatedCasePicture(CasePicture cp)
{
using (var context = new fyxmeContext())
{
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 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>
/// 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;
}
}
public IEnumerable GetLeadList()
{
// Create an object of no particular type and returns it in a IEnumerable
// the object has some of the Lead properties
using (var context = new fyxmeContext())
{
return context.Leads.AsNoTracking()
.Where(l => l.Active == true)
.OrderByDescending(l => l.LeadId)
.Select(l => new { l.LeadId, l.FirstName })
.ToList();
}
}
public Case GetCaseWithPicturesAndLead(long CaseId)
{
// Returns a Case object containing all its Lead info and all the links for the multiple assoc case pictures
using (var context = new fyxmeContext())
{
return context.Cases.AsNoTracking()
.Include(c => c.Lead)
.Include(c => c.CasePictures)
.Include(c => c.CarMMY)
.Where(c => c.Active == true)
.FirstOrDefault(c => c.CaseId == CaseId);
}
}
public Case GetCaseWithPicture(long CaseId)
{
// Return a Case object containing all links to the pictures related to the Case
using (var context = new fyxmeContext())
{
return context.Cases.AsNoTracking().Include(c => c.CasePictures)
.FirstOrDefault(c => c.CaseId == CaseId);
}
}
public List<Case> GetCasesWithLead()
{
// Return All the Cases and their leads in a list
using (var context = new fyxmeContext())
{
return context.Cases.AsNoTracking().Include(c => c.Lead).ToList();
}
}
public List<Case> GetRecentCasesWithLead(int noCases)
{
using (var context = new fyxmeContext())
{
return context.Cases.AsNoTracking()
.Include(c => c.Lead)
.Include(c => c.CasePictures)
.Include(c => c.CarMMY)
.Where(c => c.Active == true)
.OrderByDescending(c => c.CreatedOn)
.Take(noCases)
.ToList();
}
}
public List<RecentCasesViewModel> GetRecentCasesWithLeadProjection(int noCases)
{
using (var context = new fyxmeContext())
{
return context.Cases.AsNoTracking()
.Include(c => c.Lead)
.Include(c => c.CasePictures)
.Include(c => c.CarMMY)
.OrderByDescending(c => c.CreatedOn)
.Take(noCases)
.Select(p => new RecentCasesViewModel()
{
CaseNo = p.CaseNo,
CarDec = p.CarMMY.CarYear.ToString() + " " + p.CarMMY.CarMake + " / " + p.CarMMY.CarModel,
LeadFullName = p.Lead.FirstName + " " + p.Lead.LastName,
CaseDesc = p.CaseDesc,
CaseStatus = p.StatusId,
PhotoUrl = p.CasePictures.Where(cp => cp.PictureRank == 1).FirstOrDefault().PictureLocation,
ReceivedDate = p.CreatedOn,
CaseId = p.CaseId
})
.ToList();
}
}
/// <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;
}
}
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 CasePicture GetCasePictureById(int cpId)
{
using (var context = new fyxmeContext())
{
return context.CasePictures.Find(cpId);
}
}
public Case GetCaseById(long CaseId)
{
using (var context = new fyxmeContext())
{
//return context.Cases.AsNoTracking()
// .SingleOrDefault(c => c.CaseId == CaseId)
return context.Cases.Find(CaseId);
}
}
/// <summary>
/// GetCarMMYId
/// </summary>
/// <param name="carModel"></param>
/// <param name="carYear"></param>
/// <returns></returns>
public int GetCarMMYId(string carModel, int carYear)
{
using (var context = new fyxmeContext())
{
return context.CarMMYs.AsNoTracking()
.Where(c => c.Active == true && c.CarModel == carModel && c.CarYear == carYear)
.Select(c => c.CarMMYId)
.SingleOrDefault();
}
}
public LeadManagementRepository(fyxmeContext context)
{
_context = context;
}
