public string SetManager() { ModelAW db = new ModelAW(); ModelAW db2 = new ModelAW(); ModelAW db3 = new ModelAW(); var Order = db.PurchaseOrderHeaders.Where(m => m.EmployeeID == 0); var Customer = db.Customers; foreach (var Ord in Order) { int PersonID = Ord.PersonID; int? Territory = db2.Customers.Find(PersonID).TerritoryID; decimal?MinSales = db2.SalesPersons .Where(M => M.TerritoryID == Territory) .Min(M => M.SalesQuota); int EmployeeID = db2.SalesPersons.Where(m => m.TerritoryID == Territory && m.SalesQuota == MinSales).First().BusinessEntityID; Ord.Status = 2; Ord.EmployeeID = EmployeeID; } string massege = "назначенно менеджеров :" + Order.Count(); db.SaveChanges(); db.Dispose(); return(massege); }
public void AddToCart(CurrentProductDTO prod, int UserID) { ModelAW db = new ModelAW(); ShoppingCartItem cart = new ShoppingCartItem() { ProductID = prod.ProductID, ShoppingCartID = UserID.ToString(), ModifiedDate = DateTime.Now, DateCreated = DateTime.Now, Quantity = prod.Count }; db.ShoppingCartItems.Add(cart); db.SaveChanges(); }
public string SendOeder() { ModelAW db = new ModelAW(); var Order = db.PurchaseOrderHeaders.Where(m => m.Status == 2 && m.PurchaseOrderID > 4020); foreach (var ord in Order) { ord.Status = 3; ord.ShipDate = DateTime.Now; SendMessage(ord.PersonID, ord.PurchaseOrderID); } string massege = "Отправленно заказов:" + Order.Count(); db.SaveChanges(); db.Dispose(); return(massege); }
public void CreateCustomer(RegisterViewModel model, int id) { ModelAW db = new ModelAW(); try { EmailAddress E = new EmailAddress() { rowguid = Guid.NewGuid(), BusinessEntityID = id, EmailAddress1 = model.Email, ModifiedDate = DateTime.Now }; Customer C = new Customer() { PersonID = id, TerritoryID = model.territoryID, rowguid = Guid.NewGuid(), ModifiedDate = DateTime.Now }; Person P = new Person() { rowguid = Guid.NewGuid(), FirstName = model.Name, LastName = model.LastName, BusinessEntityID = id, ModifiedDate = DateTime.Now, }; db.People.Add(P); db.Customers.Add(C); db.EmailAddresses.Add(E); db.SaveChanges(); } catch (DbUpdateException ex) { tryAgain += 1; ErrorLog.Error(ex.Source + " 43: " + ex.Message); if (tryAgain < 5) { CreateCustomer(model, id); } } }
public int GetNewID() { ModelAW db = new ModelAW(); int ID = 0; BusinessEntity b = new BusinessEntity() { rowguid = Guid.NewGuid(), ModifiedDate = DateTime.Now }; try { db.BusinessEntities.Add(b); //db.BusinessEntities.Reload(b); db.SaveChanges(); ID = b.BusinessEntityID; DataLog.Debug("Добавлена Сущьность BEntity: ID - " + ID); } catch (Exception ex) { ErrorLog.Error(ex.Source + " : " + ex.Message); } db.Dispose(); return(ID); }
public void CreateCustomer(RegisterViewModel model) { ModelAW db = new ModelAW(); int id = GetNewID(); try { EmailAddress E = new EmailAddress() { rowguid = Guid.NewGuid(), BusinessEntityID = id, EmailAddress1 = model.Email, ModifiedDate = DateTime.Now }; Customer C = new Customer() { PersonID = id, TerritoryID = model.territoryID, rowguid = Guid.NewGuid(), ModifiedDate = DateTime.Now }; Person P = new Person() { rowguid = Guid.NewGuid(), FirstName = model.Name, LastName = model.LastName, BusinessEntityID = id, ModifiedDate = DateTime.Now, }; db.People.Add(P); db.Customers.Add(C); db.EmailAddresses.Add(E); db.SaveChanges(); } catch (DbUpdateException ex) { tryAgain += 1; ErrorLog.Error(ex.Source + " 43: " + ex.Message + " " + ex.InnerException.Message); CreateCustomer(model, id); } DataLog.Info("Добавлен пользователь: " + db.EmailAddresses.Where(m => m.BusinessEntityID == id).First().EmailAddress1); }
public void Save() { db.SaveChanges(); }
public void CreateOrder(string Email) { ModelAW db = new ModelAW(); int UserID = db.EmailAddresses .Where(m => m.EmailAddress1 == Email) .First().BusinessEntityID; var orders = db.ShoppingCartItems .Include(m => m.Product.ProductInventories) .Where(m => m.Product.ProductInventories.Sum(c => c.Quantity) > 1 && UserID.ToString() == m.ShoppingCartID) .Select(m => new OrderDTO { ProductID = m.ProductID, Quantity = m.Quantity, CartID = m.ShoppingCartItemID }).ToArray(); //var orders = (from ShoppingCartItem Cart in db.ShoppingCartItems // where Cart.ShoppingCartID == UserID.ToString() // select new OrderDTO // { // ProductID = Cart.ProductID, // Quantity = Cart.Quantity, // CartID = Cart.ShoppingCartItemID // }).ToArray(); foreach (var order in orders) { GetVendor(order); GetPrice(order); } var ord = orders.GroupBy(m => m.Vendor); foreach (var O in ord) { PurchaseOrderHeader newOrder = new PurchaseOrderHeader() { PersonID = UserID, VendorID = O.Key, ModifiedDate = DateTime.Now, OrderDate = DateTime.Now, ShipMethodID = 1, Status = 1 }; db.PurchaseOrderHeaders.Add(newOrder); db.SaveChanges(); db.Entry(newOrder).Reload(); foreach (var i in O) { int id = newOrder.PurchaseOrderID; PurchaseOrderDetail Order = new PurchaseOrderDetail() { PurchaseOrderID = id, OrderQty = (short)i.Quantity, ProductID = i.ProductID, DueDate = DateTime.Now, ReceivedQty = 0, RejectedQty = 0, UnitPrice = i.UnitPrice, ModifiedDate = DateTime.Now }; db.PurchaseOrderDetails.Add(Order); ShoppingCartItemRep cartItemRep = new ShoppingCartItemRep(); cartItemRep.Delete(i.CartID); DataLog.Info("Добавлен Заказ: OrderID - " + id); } db.SaveChanges(); } }