public void PostProduct(ProductDTO productDTO) { using (LcwDBEntities db = new LcwDBEntities()) { var Data = (from d in db.Product where d.ProductId == productDTO.ProductId select d).FirstOrDefault(); if (Data != null) { Data.Barcode = productDTO.Barcode; Data.Description = productDTO.Description; Data.Quantity = productDTO.Quantity; Data.Price = productDTO.Price; } else { db.Product.Add(new Product() { Barcode = productDTO.Barcode, Description = productDTO.Description, Price = productDTO.Price, Quantity = productDTO.Quantity }); } db.SaveChanges(); } }
public void PostCustomer(CustomerDTO customerDTO) { using (LcwDBEntities db = new LcwDBEntities()) { var Data = (from d in db.Customer where d.CustomerId == customerDTO.CustomerId select d).FirstOrDefault(); if (Data != null) { Data.CustomerAdress = customerDTO.CustomerAdress; Data.CustomerName = customerDTO.CustomerName; } else { db.Customer.Add(new Customer() { CustomerAdress = customerDTO.CustomerAdress, CustomerName = customerDTO.CustomerName }); } db.SaveChanges(); } }
public CustomerOrderHeaderDTO GetOrder(int OrderId) { using (LcwDBEntities db = new LcwDBEntities()) { var order = (from c in db.CustomerOrderHeader where c.OrderId == OrderId select new CustomerOrderHeaderDTO { CustomerId = c.CustomerId, OrderId = c.OrderId, OrderAdress = c.OrderAdress, CustomerOrder = (from k in db.CustomerOrder where k.OrderId == OrderId select new CustomerOrderDTO { Amount = k.Amount, Description = k.Description, Barcode = k.Barcode, Price = k.Price, ProductId = k.ProductId, OrderId = k.OrderId, CustomerOrderId = k.CustomerOrderId, Guid = k.Guid, ProductName = (from p in db.Product where p.ProductId == k.ProductId select p).FirstOrDefault().Description }).ToList() }).FirstOrDefault(); return(order); } }
public void DeleteCustomer(int id) { using (LcwDBEntities db = new LcwDBEntities()) { var data = db.Customer.Where(a => a.CustomerId == id).FirstOrDefault(); if (data != null) { db.Customer.Remove(data); db.SaveChanges(); } } }
public void DeleteProduct(int id) { using (LcwDBEntities db = new LcwDBEntities()) { var data = db.Product.Where(a => a.ProductId == id).FirstOrDefault(); if (data != null) { db.Product.Remove(data); db.SaveChanges(); } } }
public List <CustomerDTO> GetAllCustomers() { using (LcwDBEntities db = new LcwDBEntities()) { return((from d in db.Customer select new CustomerDTO { CustomerAdress = d.CustomerAdress, CustomerId = d.CustomerId, CustomerName = d.CustomerName }).ToList()); } }
public CustomerDTO GetCustomer(int id) { using (LcwDBEntities db = new LcwDBEntities()) { return((from c in db.Customer where c.CustomerId == id select new CustomerDTO { CustomerAdress = c.CustomerAdress, CustomerId = c.CustomerId, CustomerName = c.CustomerName }).FirstOrDefault()); } }
public List <CustomerOrderHeaderDTO> GetAllOrders() { using (LcwDBEntities db = new LcwDBEntities()) { return((from c in db.CustomerOrderHeader select new CustomerOrderHeaderDTO { OrderId = c.OrderId, Date_ = c.Date_, OrderAdress = c.OrderAdress, OrderPrice = c.OrderPrice, CustomerName = c.Customer.CustomerName }).ToList()); } }
public List <ProductDTO> GetProductList() { using (LcwDBEntities db = new LcwDBEntities()) { return((from d in db.Product select new ProductDTO() { Barcode = d.Barcode, Description = d.Description, Price = d.Price, ProductId = d.ProductId, Quantity = d.Quantity }).ToList()); } }
public ProductDTO GetProductById(int id) { using (LcwDBEntities db = new LcwDBEntities()) { return((from d in db.Product where d.ProductId == id select new ProductDTO() { Barcode = d.Barcode, Description = d.Description, Price = d.Price, ProductId = d.ProductId, Quantity = d.Quantity }).FirstOrDefault()); } }
public void DeleteOrder(int OrderId) { using (LcwDBEntities db = new LcwDBEntities()) { var Rows = db.CustomerOrder.Where(a => a.OrderId == OrderId).ToList(); db.CustomerOrder.RemoveRange(Rows); db.SaveChanges(); var data = db.CustomerOrderHeader.Where(a => a.OrderId == OrderId).FirstOrDefault(); if (data != null) { db.CustomerOrderHeader.Remove(data); db.SaveChanges(); } } }
public void PostOrder(CustomerOrderHeaderDTO customerOrderDTO) { CustomerOrderHeader Order = null; using (LcwDBEntities db = new LcwDBEntities()) { var Data = (from d in db.CustomerOrderHeader where d.OrderId == customerOrderDTO.OrderId select d).FirstOrDefault(); int OrderId = 0; if (Data != null) { Data.OrderAdress = customerOrderDTO.OrderAdress; Data.Date_ = customerOrderDTO.Date_; Data.OrderPrice = customerOrderDTO.OrderPrice; Data.CustomerId = customerOrderDTO.CustomerId; OrderId = customerOrderDTO.OrderId; db.SaveChanges(); } else { Order = new CustomerOrderHeader() { CustomerId = customerOrderDTO.CustomerId, OrderAdress = customerOrderDTO.OrderAdress, OrderPrice = customerOrderDTO.OrderPrice, Date_ = customerOrderDTO.Date_ }; db.CustomerOrderHeader.Add(Order); db.SaveChanges(); OrderId = Order.OrderId; } var DBList = (from r in db.CustomerOrder where r.OrderId == customerOrderDTO.OrderId select r).ToList(); var newRows = customerOrderDTO.CustomerOrder; foreach (var iRow in newRows) { iRow.OrderId = OrderId; } // Güncelleme varmı ? foreach (var iNewRow in newRows) { var data = DBList.Where(a => a.CustomerOrderId == iNewRow.CustomerOrderId).FirstOrDefault(); if (data != null) { data.Amount = iNewRow.Amount; data.ProductId = iNewRow.ProductId; data.Price = iNewRow.Price; data.Description = iNewRow.Description; data.Barcode = iNewRow.Barcode; db.SaveChanges(); } } // Eklenen var mı ? foreach (var iNewRow in newRows) { var data = DBList.Where(a => a.CustomerOrderId == iNewRow.CustomerOrderId).FirstOrDefault(); if (data == null) { db.CustomerOrder.Add(new CustomerOrder() { Amount = iNewRow.Amount, Price = iNewRow.Price, ProductId = iNewRow.ProductId, OrderId = iNewRow.OrderId, Description = iNewRow.Description, Barcode = iNewRow.Barcode, Guid = iNewRow.Guid }); db.SaveChanges(); } } // Silinen var mı ? foreach (var iDBRow in DBList) { var data = newRows.Where(a => a.CustomerOrderId == iDBRow.CustomerOrderId).FirstOrDefault(); if (data == null) { db.CustomerOrder.Remove(iDBRow); db.SaveChanges(); } } } }