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