public OrderReport GetReport(int id)
{
OrderReport Report = new OrderReport();
List <ZakazInfo> InfoList = new List <ZakazInfo>();
using (LD_kursEntities db = new LD_kursEntities())
{
var zakaz = db.zakaz.SingleOrDefault(c => c.id == id);
Report.OrderId = zakaz.id.ToString();
Report.start_time = zakaz.start_time;
Report.end_time = zakaz.end_time;
Report.price = zakaz.price;
Report.DesignerName = zakaz.designer.name;
Report.DesignerSurname = zakaz.designer.surname;
Report.LandName = zakaz.land.name;
Report.LandAddress = zakaz.land.addres;
Report.LandSize = zakaz.land.size.ToString();
Report.CustomerName = zakaz.land.customer.name;
Report.CustomerSurname = zakaz.land.customer.surname;
Report.WorkList = Mapper.Map <List <Work> >(zakaz.work);
Report.DifficultiesList = Mapper.Map <List <Difficulties> >(zakaz.difficulties);
}
return(Report);
}
public OrderCommonDate GetOrderReport(string time)
{
var Order = new OrderCommonDate();
using (LD_kursEntities db = new LD_kursEntities())
{
if (time == "3")
{
Order = db.Database.SqlQuery <OrderCommonDate>("OrderReportMonth").SingleOrDefault();
Order.Period = "Month";
}
else
if (time == "2")
{
Order = db.Database.SqlQuery <OrderCommonDate>("OrderReportYear").SingleOrDefault();
Order.Period = "Year";
}
else
{
Order = db.Database.SqlQuery <OrderCommonDate>("OrderReportAllTime").SingleOrDefault();
Order.Period = "All period";
}
}
return(Order);
}
public IEnumerable <Customer> GetList(string name, string surname, string dateOfB)
{
List <customer> customer;
List <Customer> Customer;
using (LD_kursEntities db = new LD_kursEntities())
{
DateTime result = new DateTime();
if (DateTime.TryParse(dateOfB, out result))
{
customer = db.customer
.Where(item => item.name.Contains(name))
.Where(item => item.surname.Contains(surname))
.Where(item => item.dateOfBirth == result)
.ToList();
}
else
{
customer = db.customer
.Where(item => item.name.Contains(name))
.Where(item => item.surname.Contains(surname))
.ToList();
}
Customer = Mapper.Map <List <Customer> >(customer.OrderByDescending(x => x.id));
}
return(Customer);
}
public ZakazInfo Delete(int id)
{
ZakazInfo Info = GetbyId(id);
using (LD_kursEntities db = new LD_kursEntities())
{
var zakaz = db.zakaz.SingleOrDefault(c => c.id == id);
if (zakaz == null)
{
return(null);
}
using (var transaction = db.Database.BeginTransaction())
{
try
{
foreach (var item in zakaz.work.ToList())
{
db.Entry(item).State = EntityState.Deleted;
}
db.Entry(zakaz).State = EntityState.Deleted;
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
}
}
}
return(Info);
}
public Designer Delete(int id)
{
var user = GetbyIduser(id);
if (user != null)
{
using (LD_kursEntities db = new LD_kursEntities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
var orders = db.zakaz.Where(x => x.designer_id == id).ToList();
foreach (var zakaz in orders)
{
var wk = db.work.Where(x => x.zakazId == zakaz.id).ToList();
foreach (var it in wk)
{
db.Entry(it).State = EntityState.Deleted;
}
db.Entry(zakaz).State = EntityState.Deleted;
}
db.Entry(user).State = EntityState.Deleted;
db.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
}
}
}
}
return(Mapper.Map <Designer>(user));
}
public ZakazExelModel GetList()
{
ZakazExelModel Model = new ZakazExelModel();
using (LD_kursEntities db = new LD_kursEntities())
{
var orders = db.zakaz;
Model.Customers = Mapper.Map <List <Customer> >(db.customer.ToList <customer>());
Model.Designers = Mapper.Map <List <Designer> >(db.designer.ToList <designer>());
Model.Lands = Mapper.Map <List <Land> >(db.land.ToList <land>());
Model.Works = Mapper.Map <List <Work> >(db.work.ToList <work>());
Model.Difficults = Mapper.Map <List <Difficulties> >(db.difficulties.ToList <difficulties>());
Model.Orders = Mapper.Map <List <Zakaz> >(db.zakaz.ToList <zakaz>());
var OrdersInfo = new List <OrderInfo>();
foreach (var item in orders)
{
foreach (var diff in item.difficulties)
{
OrdersInfo.Add(new OrderInfo()
{
DifficultiesId = diff.id,
OrderId = item.id
});
}
}
Model.OrdersInfo = OrdersInfo;
}
return(Model);
}
public Customer GetbyId(int id)
{
using (LD_kursEntities db = new LD_kursEntities())
{
var user = db.customer.SingleOrDefault(c => c.id == id);
return(Mapper.Map <Customer>(user));
}
}
private designer GetbyIduser(int id)
{
using (LD_kursEntities db = new LD_kursEntities())
{
var user = db.designer.SingleOrDefault(c => c.id == id);
return(user);
}
}
public Land GetbyId(int id)
{
using (LD_kursEntities db = new LD_kursEntities())
{
var user = db.land.SingleOrDefault(c => c.id == id);
return(Mapper.Map <Land>(user));
}
}
public customer GetcustomerById(int id)
{
customer user;
using (LD_kursEntities db = new LD_kursEntities())
{
user = db.customer.SingleOrDefault(c => c.id == id);
user.land = user.land.ToList();
}
return(user);
}
public Zakaz Get(int id)
{
Zakaz returnZakaz;
using (LD_kursEntities db = new LD_kursEntities())
{
var zakaz = db.zakaz.SingleOrDefault(c => c.id == id);
returnZakaz = Mapper.Map <Zakaz>(zakaz);
}
return(returnZakaz);
}
public IEnumerable <Zakaz> GetList()
{
List <zakaz> zakaz;
List <Zakaz> Zakaz;
using (LD_kursEntities db = new LD_kursEntities())
{
zakaz = db.zakaz.ToList <zakaz>();
Zakaz = Mapper.Map <List <Zakaz> >(zakaz.OrderByDescending(x => x.id));
}
return(Zakaz);
}
public IEnumerable <Land> GetList()
{
List <land> Lands;
List <Land> List;
using (LD_kursEntities db = new LD_kursEntities())
{
Lands = db.land.ToList <land>();
List = Mapper.Map <List <Land> >(Lands.OrderByDescending(x => x.id));
}
return(List);
}
public IEnumerable <Designer> GetList()
{
List <designer> user;
List <Designer> List;
using (LD_kursEntities db = new LD_kursEntities())
{
user = db.designer.ToList <designer>();
List = Mapper.Map <List <Designer> >(user.OrderByDescending(x => x.id));
}
return(List);
}
public IEnumerable <Land> GetListForUser(int customerId)
{
List <land> Lands;
using (LD_kursEntities db = new LD_kursEntities())
{
Lands = db.land
.Where(f => f.customer_id == customerId)
.ToList <land>();
}
return(Mapper.Map <List <Land> >(Lands.OrderByDescending(x => x.id)));
}
public IEnumerable <Customer> GetList()
{
List <customer> customer;
List <Customer> Customer;
using (LD_kursEntities db = new LD_kursEntities())
{
customer = db.customer.ToList <customer>();
Customer = Mapper.Map <List <Customer> >(customer.OrderByDescending(x => x.id));
}
return(Customer);
}
public Land Delete(int id)
{
var land = GetbyId(id);
if (land != null)
{
using (LD_kursEntities db = new LD_kursEntities())
{
db.Entry(Mapper.Map <land>(land)).State = EntityState.Deleted;
db.SaveChanges();
}
}
return(land);
}
public void Save(Land _land)
{
if (_land != null)
{
using (LD_kursEntities db = new LD_kursEntities())
{
db.land.Add(Mapper.Map <land>(_land));
db.SaveChanges();
}
}
else
{
throw new Exception("Couldn't save null instance");
}
}
public int Edit(Land _land)
{
if (_land != null)
{
using (LD_kursEntities db = new LD_kursEntities())
{
db.Entry(Mapper.Map <land>(_land)).State = EntityState.Modified;
return(db.SaveChanges());
}
}
else
{
throw new Exception("Couldn't save null instance");
}
}
public void Save(Designer user)
{
if (user != null)
{
using (LD_kursEntities db = new LD_kursEntities())
{
db.designer.Add(Mapper.Map <designer>(user));
db.SaveChanges();
}
}
else
{
throw new Exception("Couldn't save null instance");
}
}
public int Save(int orderId, int DifficultsId)
{
using (LD_kursEntities db = new LD_kursEntities())
{
var order = db.zakaz.SingleOrDefault(c => c.id == orderId);
var diff = db.difficulties.SingleOrDefault(c => c.id == DifficultsId);
if (order == null || diff == null)
{
return(-1);
}
order.difficulties.Add(diff);
db.SaveChanges();
}
return(DifficultsId);
}
public int Edit(Designer user)
{
if (user != null)
{
using (LD_kursEntities db = new LD_kursEntities())
{
db.Entry(Mapper.Map <designer>(user)).State = EntityState.Modified;
return(db.SaveChanges());
}
}
else
{
throw new Exception("Couldn't save null instance");
}
}
public void Save(Customer _customer)
{
if (_customer != null)
{
using (LD_kursEntities db = new LD_kursEntities())
{
db.customer.Add(Mapper.Map <customer>(_customer));
db.SaveChanges();
}
}
else
{
throw new Exception("Couldn't save null instance");
}
}
public int Save(int orderId, Work Work)
{
int result = -1;
using (LD_kursEntities db = new LD_kursEntities())
{
var order = db.zakaz.SingleOrDefault(m => m.id == orderId);
var work = Mapper.Map <work>(Work);
if (order != null && work != null)
{
order.work.Add(work);
db.SaveChanges();
result = work.id;
}
}
return(result);
}
public Difficulties Remove(int orderId, int DifficultsId)
{
Difficulties difficults = new Difficulties();
using (LD_kursEntities db = new LD_kursEntities())
{
var order = db.zakaz.SingleOrDefault(c => c.id == orderId);
var diff = db.difficulties.SingleOrDefault(c => c.id == DifficultsId);
if (order == null || diff == null)
{
return(null);
}
order.difficulties.Remove(diff);
db.SaveChanges();
difficults = Mapper.Map <Difficulties>(diff);
}
return(difficults);
}
public Work Remove(int orderId, int WorkId)
{
Work Work = new Work();
using (LD_kursEntities db = new LD_kursEntities())
{
var order = db.zakaz.SingleOrDefault(c => c.id == orderId);
var work = db.work.SingleOrDefault(c => c.id == WorkId);
if (order == null || work == null)
{
return(null);
}
order.work.Remove(work);
db.SaveChanges();
Work = Mapper.Map <Work>(work);
}
return(Work);
}
//test
public Customer Del(int id)
{
var user = GetcustomerById(id);
using (LD_kursEntities db = new LD_kursEntities())
{
if (user != null)
{
foreach (var land in user.land.ToList())
{
db.Entry(land).State = EntityState.Deleted;
}
db.Entry(user).State = EntityState.Deleted;
db.SaveChanges();
}
}
return(Mapper.Map <Customer>(user));
}
public ZakazInfo GetbyId(int id)
{
ZakazInfo ZkazInfo = new ZakazInfo();
using (LD_kursEntities db = new LD_kursEntities())
{
var zakaz = db.zakaz.SingleOrDefault(c => c.id == id);
ZkazInfo = new ZakazInfo()
{
zakaz = Mapper.Map <Zakaz>(zakaz),
land = Mapper.Map <Land>(zakaz.land),
customer = Mapper.Map <Customer>(zakaz.land.customer),
designer = Mapper.Map <Designer>(zakaz.designer),
difficults = Mapper.Map <List <Difficulties> >(zakaz.difficulties),
work = Mapper.Map <List <Work> >(zakaz.work)
};
}
return(ZkazInfo);
}
public Zakaz Save(Zakaz _zakaz)
{
Zakaz returnZakaz;
if (_zakaz != null)
{
using (LD_kursEntities db = new LD_kursEntities())
{
var zakaz = Mapper.Map <zakaz>(_zakaz);
db.zakaz.Add(zakaz);
db.SaveChanges();
returnZakaz = Mapper.Map <Zakaz>(zakaz);
}
}
else
{
throw new Exception("Couldn't save null instance");
}
return(returnZakaz);
}
public Zakaz Edit(Zakaz _zakaz)
{
Zakaz returnZakaz;
if (_zakaz != null)
{
using (LD_kursEntities db = new LD_kursEntities())
{
var zakaz = Mapper.Map <zakaz>(_zakaz);
db.Entry(zakaz).State = EntityState.Modified;
db.SaveChanges();
returnZakaz = Mapper.Map <Zakaz>(zakaz);
}
}
else
{
throw new Exception("Couldn't edit null instance");
}
return(returnZakaz);
}