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 Dispose(bool disposing) { if (!this.disposed) { if (disposing) { db.Dispose(); } } this.disposed = true; }
public List <TerritoryDTO> GetTerritories() { ModelAW db = new ModelAW(); List <TerritoryDTO> territories = db.SalesTerritories .Select(m => new TerritoryDTO { Territory = m.Name, TerritoryID = m.TerritoryID }).ToList(); db.Dispose(); return(territories); }
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 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); }