public void Update(VisitBindingModel model)
{
using (var context = new BeautySaloonDatabase())
{
using (var transaction = context.Database.BeginTransaction())
{
try
{
var element = context.Visits.FirstOrDefault(rec => rec.Id == model.Id);
if (element == null)
{
throw new Exception("Элемент не найден");
}
CreateModel(model, element, context);
context.SaveChanges();
transaction.Commit();
}
catch
{
transaction.Rollback();
throw;
}
}
}
}
public ClientViewModel GetElement(ClientBindingModel model)
{
if (model == null)
{
return(null);
}
using (var context = new BeautySaloonDatabase())
{
var client = context.Clients
//.Include(x => x.Procedure).Include(x => x.Purchase).Include(x => x.Visit)
.FirstOrDefault(rec => rec.Login == model.Login ||
rec.Id == model.Id);
return(client != null ?
new ClientViewModel
{
Id = client.Id,
ClientName = client.ClientName,
ClientSurame = client.ClientSurame,
Login = client.Login,
Password = client.Password,
Mail = client.Mail,
Tel = client.Tel
} :
null);
}
}
public List <VisitViewModel> GetFilteredList(VisitBindingModel model)
{
if (model == null)
{
return(null);
}
using (var context = new BeautySaloonDatabase())
{
return(context.Visits
.Include(rec => rec.Client)
.Include(rec => rec.ProcedureVisit)
.ThenInclude(rec => rec.Procedure)
.Where(rec => (!model.DateFrom.HasValue && !model.DateTo.HasValue && rec.ClientId == model.ClientId || rec.Date == model.Date) ||
(model.DateFrom.HasValue && model.DateTo.HasValue && (rec.ClientId == model.ClientId &&
rec.Date.Date >= model.DateFrom.Value.Date && rec.Date.Date <= model.DateTo.Value.Date)))
.ToList()
.Select(rec => new VisitViewModel
{
Id = rec.Id,
ClientId = rec.ClientId,
Date = rec.Date,
VisitProcedures = rec.ProcedureVisit.ToDictionary(recPP => recPP.ProcedureId, recPP => (recPP.Procedure?.ProcedureName))
}).ToList());
}
}
public void Insert(ClientBindingModel model)
{
using (var context = new BeautySaloonDatabase())
{
context.Clients.Add(CreateModel(model, new Client(), context));
context.SaveChanges();
}
}
public void Insert(ProcedureBindingModel model)
{
using (var context = new BeautySaloonDatabase())
{
context.Procedures.Add(CreateModel(model, new Procedure()));
context.SaveChanges();
}
}
public void Insert(CosmeticBindingModel model)
{
using (var context = new BeautySaloonDatabase())
{
context.Cosmetics.Add(CreateModel(model, new Cosmetic()));
context.SaveChanges();
}
}
public void Insert(EmployeeBindingModel model)
{
using (var context = new BeautySaloonDatabase())
{
context.Employees.Add(CreateModel(model, new Employee()));
context.SaveChanges();
}
}
public List <ProcedureViewModel> GetFullList()
{
using (var context = new BeautySaloonDatabase())
{
return(context.Procedures
.Select(CreateModel)
.ToList());
}
}
private Client CreateModel(ClientBindingModel model, Client client, BeautySaloonDatabase database)
{
client.ClientName = model.ClientName;
client.ClientSurame = model.ClientSurname;
client.Login = model.Login;
client.Password = model.Password;
client.Mail = model.Login;
client.Tel = model.Tel;
return(client);
}
public void Update(CosmeticBindingModel model)
{
using (var context = new BeautySaloonDatabase())
{
var element = context.Cosmetics.FirstOrDefault(rec => rec.Id == model.Id);
if (element == null)
{
throw new Exception("Элемент не найден");
}
CreateModel(model, element);
context.SaveChanges();
}
}
public List <ProcedureViewModel> GetFilteredList(ProcedureBindingModel model)
{
if (model == null)
{
return(null);
}
using (var context = new BeautySaloonDatabase())
{
return(context.Procedures
.Where(rec => rec.ClientId == model.ClientId || rec.ProcedureName.Contains(model.ProcedureName))
.Select(CreateModel)
.ToList());
}
}
public ProcedureViewModel GetElement(ProcedureBindingModel model)
{
if (model == null)
{
return(null);
}
using (var context = new BeautySaloonDatabase())
{
var procedure = context.Procedures
.FirstOrDefault(rec => rec.ProcedureName == model.ProcedureName || rec.Id == model.Id);
return(procedure != null?
CreateModel(procedure) :
null);
}
}
public List <CosmeticViewModel> GetFullList()
{
using (var context = new BeautySaloonDatabase())
{
return(context.Cosmetics
.Include(rec => rec.Employee)
.Select(rec => new CosmeticViewModel
{
Id = rec.Id,
CosmeticName = rec.CosmeticName,
Price = rec.Price,
EmployeeId = rec.EmployeeId
})
.ToList());
}
}
public void Delete(CosmeticBindingModel model)
{
using (var context = new BeautySaloonDatabase())
{
Cosmetic element = context.Cosmetics.FirstOrDefault(rec => rec.Id == model.Id);
if (element != null)
{
context.Cosmetics.Remove(element);
context.SaveChanges();
}
else
{
throw new Exception("Элемент не найден");
}
}
}
public List <ClientViewModel> GetFullList()
{
using (var context = new BeautySaloonDatabase())
{
return(context.Clients.Select(rec => new ClientViewModel
{
Id = rec.Id,
ClientName = rec.ClientName,
ClientSurame = rec.ClientSurame,
Login = rec.Login,
Password = rec.Password,
Mail = rec.Mail,
Tel = rec.Tel
})
.ToList());
}
}
public List <ReceiptViewModel> GetFullList()
{
using (var context = new BeautySaloonDatabase())
{
return(context.Receipts
.Include(rec => rec.Employee)
.Include(rec => rec.ReceiptCosmetics)
.ThenInclude(rec => rec.Cosmetic)
.ToList()
.Select(rec => new ReceiptViewModel
{
Id = rec.Id,
TotalCost = rec.TotalCost,
PurchaseDate = rec.PurchaseDate,
ReceiptCosmetics = rec.ReceiptCosmetics.ToDictionary(recRC => recRC.CosmeticId, recRC => (recRC.Cosmetic?.CosmeticName, recRC.Count)),
EmployeeId = rec.EmployeeId
})
public List <EmployeeViewModel> GetFullList()
{
using (var context = new BeautySaloonDatabase())
{
return(context.Employees
.Select(rec => new EmployeeViewModel
{
Id = rec.Id,
F_Name = rec.F_Name,
L_Name = rec.L_Name,
Login = rec.Login,
Password = rec.Password,
EMail = rec.EMail,
PhoneNumber = rec.PhoneNumber
})
.ToList());
}
}
public List <DistributionViewModel> GetFullList()
{
using (var context = new BeautySaloonDatabase())
{
return(context.Distributions
.Include(rec => rec.Employee)
.Include(rec => rec.Visit)
.Include(rec => rec.DistributionCosmetics)
.ThenInclude(rec => rec.Cosmetic)
.ToList()
.Select(rec => new DistributionViewModel
{
Id = rec.Id,
IssueDate = rec.IssueDate,
DistributionCosmetics = rec.DistributionCosmetics.ToDictionary(recDC => recDC.CosmeticId, recDC => (recDC.Cosmetic?.CosmeticName, recDC.Count)),
EmployeeId = rec.EmployeeId,
VisitId = rec.VisitId
})
public List <PurchaseViewModel> GetFullList()
{
using (var context = new BeautySaloonDatabase())
{
return(context.Purchases
.Include(rec => rec.Client)
.Include(rec => rec.Receipt)
.Include(rec => rec.ProcedurePurchase)
.ThenInclude(rec => rec.Procedure)
.ToList()
.Select(rec => new PurchaseViewModel
{
Id = rec.Id,
ClientId = rec.ClientId,
Date = rec.Date,
Price = rec.Price,
PurchaseProcedures = rec.ProcedurePurchase.ToDictionary(recPP => recPP.ProcedureId, recPP => (recPP.Procedure?.ProcedureName, recPP.Procedure.Price)),
ReceiptId = rec.ReceiptId
})
public List <VisitViewModel> GetFullList()
{
using (var context = new BeautySaloonDatabase())
{
return(context.Visits
.Include(rec => rec.Client)
.Include(rec => rec.ProcedureVisit)
.ThenInclude(rec => rec.Procedure)
.ToList()
.Select(rec => new VisitViewModel
{
Id = rec.Id,
ClientId = rec.ClientId,
Date = rec.Date,
VisitProcedures = rec.ProcedureVisit.ToDictionary(recPP => recPP.ProcedureId, recPP => (recPP.Procedure?.ProcedureName))
})
.ToList());
}
}
public List <ReportCosmeticsViewModel> GetDistributionsForAll(ReportBindingModelEmployee model)
{
using (var context = new BeautySaloonDatabase())
{
return((
from c in context.Cosmetics
join dc in context.DistributionCosmetics on c.Id equals dc.CosmeticId
join d in context.Distributions on dc.DistributionId equals d.Id
where d.IssueDate >= model.DateFrom
where d.IssueDate <= model.DateTo
select new ReportCosmeticsViewModel
{
TypeOfService = "Выдача",
DateOfService = d.IssueDate,
CosmeticName = c.CosmeticName,
Count = dc.Count
})
.ToList());
}
}
public void Insert(VisitBindingModel model)
{
using (var context = new BeautySaloonDatabase())
{
using (var transaction = context.Database.BeginTransaction())
{
try
{
CreateModel(model, new Visit(), context);
context.SaveChanges();
transaction.Commit();
}
catch
{
transaction.Rollback();
throw;
}
}
}
}
public List <ReportCosmeticsViewModel> GetReceiptsForAll(ReportBindingModelEmployee model)
{
using (var context = new BeautySaloonDatabase())
{
return((
from c in context.Cosmetics
join rc in context.ReceiptCosmetics on c.Id equals rc.CosmeticId
join r in context.Receipts on rc.ReceiptId equals r.Id
where r.PurchaseDate >= model.DateFrom
where r.PurchaseDate <= model.DateTo
select new ReportCosmeticsViewModel
{
TypeOfService = "Чек",
DateOfService = r.PurchaseDate,
CosmeticName = c.CosmeticName,
Count = rc.Count
})
.ToList());
}
}
public List <ReportPurchaseCosmeticViewModel> GetPurchaseList(int cosmeticId)
{
using (var context = new BeautySaloonDatabase())
{
return((
from c in context.Cosmetics
where c.Id == cosmeticId
join rc in context.ReceiptCosmetics on c.Id equals rc.CosmeticId
join r in context.Receipts on rc.ReceiptId equals r.Id
join p in context.Purchases on r.Id equals p.ReceiptId
select new ReportPurchaseCosmeticViewModel
{
CosmeticName = c.CosmeticName,
Price = c.Price,
Date = p.Date,
Count = rc.Count,
ClientId = p.ClientId,
})
.ToList());
}
}
public List <CosmeticViewModel> GetFilteredList(CosmeticBindingModel model)
{
if (model == null)
{
return(null);
}
using (var context = new BeautySaloonDatabase())
{
return(context.Cosmetics
.Include(rec => rec.Employee)
.Where(rec => rec.EmployeeId == model.EmployeeId || rec.CosmeticName.Contains(model.CosmeticName))
.Select(rec => new CosmeticViewModel
{
Id = rec.Id,
CosmeticName = rec.CosmeticName,
Price = rec.Price,
EmployeeId = rec.EmployeeId
})
.ToList());
}
}
public CosmeticViewModel GetElement(CosmeticBindingModel model)
{
if (model == null)
{
return(null);
}
using (var context = new BeautySaloonDatabase())
{
var tmp = model.EmployeeId;
var cosmetic = context.Cosmetics
.Include(rec => rec.Employee)
.FirstOrDefault(rec => rec.CosmeticName == model.CosmeticName || rec.Id == model.Id);
return(cosmetic != null ?
new CosmeticViewModel
{
Id = cosmetic.Id,
CosmeticName = cosmetic.CosmeticName,
Price = cosmetic.Price,
EmployeeId = cosmetic.EmployeeId
} :
null);
}
}
public List <EmployeeViewModel> GetFilteredList(EmployeeBindingModel model)
{
if (model == null)
{
return(null);
}
using (var context = new BeautySaloonDatabase())
{
return(context.Employees
.Where(rec => rec.Login == model.Login && rec.Password == model.Password)
.Select(rec => new EmployeeViewModel
{
Id = rec.Id,
F_Name = rec.F_Name,
L_Name = rec.L_Name,
Login = rec.Login,
Password = rec.Password,
EMail = rec.EMail,
PhoneNumber = rec.PhoneNumber
})
.ToList());
}
}
private Visit CreateModel(VisitBindingModel model, Visit visit, BeautySaloonDatabase context)
{
visit.Date = model.Date;
visit.ClientId = (int)model.ClientId;
if (visit.Id == 0)
{
context.Visits.Add(visit);
context.SaveChanges();
}
if (model.Id.HasValue)
{
var VisitComponents = context.ProcedureVisits.Where(rec =>
rec.VisitId == model.Id.Value).ToList();
context.ProcedureVisits.RemoveRange(VisitComponents.Where(rec =>
!model.VisitProcedures.ContainsKey(rec.ProcedureId)).ToList());
foreach (var updateProcedure in VisitComponents)
{
model.VisitProcedures.Remove(updateProcedure.ProcedureId);
}
context.SaveChanges();
}
// добавили новые
foreach (var vp in model.VisitProcedures)
{
context.ProcedureVisits.Add(new ProcedureVisit
{
VisitId = visit.Id,
ProcedureId = vp.Key,
});
context.SaveChanges();
}
return(visit);
}
public List <ReportCosmeticsViewModel> GetCosmetics(ReportBindingModelEmployee model)
{
using (var context = new BeautySaloonDatabase())
{
return((
from c in context.Cosmetics
join rc in context.ReceiptCosmetics on c.Id equals rc.CosmeticId
join r in context.Receipts on rc.ReceiptId equals r.Id
where r.EmployeeId == model.EmployeeId
where r.PurchaseDate >= model.DateFrom
where r.PurchaseDate <= model.DateTo
select new ReportCosmeticsViewModel
{
TypeOfService = "Чек",
DateOfService = r.PurchaseDate,
CosmeticName = c.CosmeticName,
Count = rc.Count
})
.Union(
from c in context.Cosmetics
join dc in context.DistributionCosmetics on c.Id equals dc.CosmeticId
join d in context.Distributions on dc.DistributionId equals d.Id
where d.EmployeeId == model.EmployeeId
where d.IssueDate >= model.DateFrom
where d.IssueDate <= model.DateTo
select new ReportCosmeticsViewModel
{
TypeOfService = "Выдача",
DateOfService = d.IssueDate,
CosmeticName = c.CosmeticName,
Count = dc.Count
})
.OrderBy(x => x.DateOfService)
.ToList());
}
}
public EmployeeViewModel GetElement(EmployeeBindingModel model)
{
if (model == null)
{
return(null);
}
using (var context = new BeautySaloonDatabase())
{
var employee = context.Employees
.FirstOrDefault(rec => rec.Login == model.Login || rec.Id == model.Id);
return(employee != null ?
new EmployeeViewModel
{
Id = employee.Id,
F_Name = employee.F_Name,
L_Name = employee.L_Name,
Login = employee.Login,
Password = employee.Password,
EMail = employee.EMail,
PhoneNumber = employee.PhoneNumber
} :
null);
}
}
