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);
}
