public static void InitializeDropDowns(CashOrderViewModel model)
{
using (FreeMarketEntities db = new FreeMarketEntities())
{
model.Custodians = db.Custodians.Select
(c => new SelectListItem
{
Text = c.CustodianName,
Value = c.CustodianNumber.ToString()
}).ToList();
foreach (Product product in model.Products.Products)
{
string normalPrice = string.Format("{0:C}", product.PricePerUnit);
string specialPrice = string.Format("{0:C}", product.SpecialPricePerUnit);
product.Prices = new List <SelectListItem>();
product.Prices.Add(new SelectListItem
{
Text = normalPrice,
Value = product.PricePerUnit.ToString()
});
product.Prices.Add(new SelectListItem
{
Text = specialPrice,
Value = product.SpecialPricePerUnit.ToString(),
Selected = true
});
}
}
}
public static CashOrderViewModel CreateNewOrder(int id = 0)
{
CashOrderViewModel model = new CashOrderViewModel();
model.Order = new CashOrder();
using (FreeMarketEntities db = new FreeMarketEntities())
{
if (id != 0)
{
CashCustomer customer = db.CashCustomers.Find(id);
if (customer != null)
{
model.Order.CashCustomerId = customer.Id;
model.Order.CustomerDeliveryAddress = customer.DeliveryAddress;
model.Order.CustomerEmail = customer.Email;
model.Order.CustomerName = customer.Name;
model.Order.CustomerPhone = customer.PhoneNumber;
}
}
model.Products = ProductCollection.GetAllProducts();
model.Custodians = db.Custodians.Select
(c => new SelectListItem
{
Text = c.CustodianName,
Value = c.CustodianNumber.ToString()
}).ToList();
}
model.OrderDetails = new List <CashOrderDetail>();
return(model);
}
public static List <CashOrderViewModel> GetOrders(string searchCriteria)
{
List <CashOrderViewModel> model = new List <CashOrderViewModel>();
if (string.IsNullOrEmpty(searchCriteria))
{
return(model);
}
using (FreeMarketEntities db = new FreeMarketEntities())
{
List <FilterCashOrder_Result> orders = db.FilterCashOrder(searchCriteria).ToList();
if (orders == null)
{
return(model);
}
foreach (FilterCashOrder_Result result in orders)
{
CashOrderViewModel viewModel = new CashOrderViewModel();
viewModel.Order = new CashOrder
{
CashCustomerId = (int)result.CashCustomerId,
OrderId = (int)result.OrderId,
Total = (int)result.Total,
CustomerDeliveryAddress = result.DeliveryAddress,
CustomerEmail = result.Email,
CustomerName = result.Name,
CustomerPhone = result.PhoneNumber,
DatePlaced = result.DatePlaced
};
viewModel.OrderDetails = db.GetCashOrderDetails(viewModel.Order.OrderId)
.Select(c => new CashOrderDetail
{
CashOrderId = c.CashOrderId,
CashOrderItemId = c.CashOrderItemId,
CustodianNumber = c.CustodianNumber,
Price = c.Price,
ProductNumber = c.ProductNumber,
Quantity = c.Quantity,
SupplierNumber = c.SupplierNumber,
Description = c.Description,
SupplierName = c.SupplierName,
Weight = (int)c.Weight,
OrderItemTotal = c.OrderItemTotal
})
.ToList();
model.Add(viewModel);
}
}
return(model);
}
public static CashOrderViewModel GetOrder(int id)
{
CashOrderViewModel model = new CashOrderViewModel();
if (id == 0)
{
return(model);
}
using (FreeMarketEntities db = new FreeMarketEntities())
{
model.Order = db.CashOrders.Find(id);
CashCustomer customer = db.CashCustomers.Find(model.Order.CashCustomerId);
model.Order.CustomerDeliveryAddress = customer.DeliveryAddress;
model.Order.CustomerEmail = customer.Email;
model.Order.CustomerName = customer.Name;
model.Order.CustomerPhone = customer.PhoneNumber;
model.OrderDetails = db.GetCashOrderDetails(model.Order.OrderId)
.Select(c => new CashOrderDetail
{
CashOrderId = c.CashOrderId,
CashOrderItemId = c.CashOrderItemId,
CustodianNumber = c.CustodianNumber,
Price = c.Price,
ProductNumber = c.ProductNumber,
Quantity = c.Quantity,
SupplierNumber = c.SupplierNumber,
Description = c.Description,
SupplierName = c.SupplierName,
Weight = (int)c.Weight,
OrderItemTotal = c.OrderItemTotal
})
.ToList();
model.Products = ProductCollection.GetAllProducts();
for (int i = 0; i < model.Products.Products.Count; i++)
{
CashOrderDetail qty = model.OrderDetails
.Where(c => c.ProductNumber == model.Products.Products[i].ProductNumber && c.SupplierNumber == model.Products.Products[i].SupplierNumber)
.FirstOrDefault();
if (qty != null)
{
model.Products.Products[i].CashQuantity = qty.Quantity;
}
else
{
model.Products.Products[i].CashQuantity = 0;
}
}
model.Custodians = db.Custodians.Select
(c => new SelectListItem
{
Text = c.CustodianName,
Value = c.CustodianNumber.ToString()
}).ToList();
}
return(model);
}
public static FreeMarketObject CreateNewCashOrder(CashOrderViewModel model)
{
FreeMarketObject result = new FreeMarketObject {
Result = FreeMarketResult.NoResult, Argument = null, Message = null
};
using (FreeMarketEntities db = new FreeMarketEntities())
{
CashCustomer customer = db.CashCustomers.Find(model.Order.CashCustomerId);
if (customer == null)
{
customer = new CashCustomer
{
DeliveryAddress = model.Order.CustomerDeliveryAddress,
Email = model.Order.CustomerEmail,
Name = model.Order.CustomerName,
PhoneNumber = model.Order.CustomerPhone
};
db.CashCustomers.Add(customer);
db.SaveChanges();
}
else
{
customer.DeliveryAddress = model.Order.CustomerDeliveryAddress;
customer.Email = model.Order.CustomerEmail;
customer.Name = model.Order.CustomerName;
customer.PhoneNumber = model.Order.CustomerPhone;
db.Entry(customer).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
CashOrder order = new CashOrder
{
CashCustomerId = customer.Id,
DatePlaced = DateTime.Now,
Status = "Completed",
Total = 0
};
db.CashOrders.Add(order);
db.SaveChanges();
foreach (Product p in model.Products.Products)
{
if (p.CashQuantity > 0)
{
decimal price = decimal.Parse(p.SelectedPrice);
CashOrderDetail detail = new CashOrderDetail
{
CashOrderId = order.OrderId,
ProductNumber = p.ProductNumber,
SupplierNumber = p.SupplierNumber,
Quantity = p.CashQuantity,
Price = price,
OrderItemTotal = price * p.CashQuantity,
CustodianNumber = model.SelectedCustodian
};
db.CashOrderDetails.Add(detail);
db.SaveChanges();
order.Total += detail.OrderItemTotal;
db.Entry(order).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
ProductCustodian custodian = db.ProductCustodians
.Where(c => c.CustodianNumber == model.SelectedCustodian &&
c.ProductNumber == p.ProductNumber &&
c.SupplierNumber == p.SupplierNumber)
.FirstOrDefault();
custodian.QuantityOnHand -= p.CashQuantity;
db.Entry(custodian).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
db.SaveChanges();
if (customer != null && order != null && db.CashOrderDetails.Any(c => c.CashOrderId == order.OrderId))
{
result.Result = FreeMarketResult.Success;
}
else
{
result.Result = FreeMarketResult.Failure;
}
}
return(result);
}
public static FreeMarketObject ModifyOrder(CashOrderViewModel model)
{
FreeMarketObject result = new FreeMarketObject {
Result = FreeMarketResult.NoResult, Argument = null, Message = null
};
using (FreeMarketEntities db = new FreeMarketEntities())
{
CashCustomer customer = db.CashCustomers.Find(model.Order.CashCustomerId);
customer.DeliveryAddress = model.Order.CustomerDeliveryAddress;
customer.Email = model.Order.CustomerEmail;
customer.Name = model.Order.CustomerName;
customer.PhoneNumber = model.Order.CustomerPhone;
db.Entry(customer).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
CashOrder order = db.CashOrders.Find(model.Order.OrderId);
List <GetCashOrderDetails_Result> orderDetails = db.GetCashOrderDetails(order.OrderId).ToList();
foreach (Product p in model.Products.Products)
{
if (p.CashQuantity > 0)
{
decimal price = decimal.Parse(p.SelectedPrice);
if (orderDetails.Any(c => c.ProductNumber == p.ProductNumber && c.SupplierNumber == p.SupplierNumber))
{
CashOrderDetail existingDetail = db.CashOrderDetails
.Where(c => c.CashOrderId == order.OrderId && c.ProductNumber == p.ProductNumber && c.SupplierNumber == p.SupplierNumber)
.FirstOrDefault();
existingDetail.Price = price;
existingDetail.OrderItemTotal = price * p.CashQuantity;
if (existingDetail.Quantity > p.CashQuantity)
{
int stock = existingDetail.Quantity - p.CashQuantity;
AddStockToCustodian(order.OrderId, p.ProductNumber, p.SupplierNumber, model.SelectedCustodian, stock);
}
else
{
int stock = p.CashQuantity - existingDetail.Quantity;
RemoveStockFromCustodian(order.OrderId, p.ProductNumber, p.SupplierNumber, model.SelectedCustodian, stock);
}
existingDetail.Quantity = p.CashQuantity;
db.Entry(existingDetail).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
else
{
CashOrderDetail detail = new CashOrderDetail
{
CashOrderId = order.OrderId,
ProductNumber = p.ProductNumber,
SupplierNumber = p.SupplierNumber,
Quantity = p.CashQuantity,
Price = price,
OrderItemTotal = price * p.CashQuantity,
CustodianNumber = model.SelectedCustodian
};
db.CashOrderDetails.Add(detail);
db.SaveChanges();
RemoveStockFromCustodian(order.OrderId, p.ProductNumber, p.SupplierNumber, model.SelectedCustodian, p.CashQuantity);
}
}
else
{
CashOrderDetail toRemove = db.CashOrderDetails
.Where(c => c.CashOrderId == order.OrderId && c.ProductNumber == p.ProductNumber && c.SupplierNumber == p.SupplierNumber)
.FirstOrDefault();
if (toRemove != null)
{
db.CashOrderDetails.Remove(toRemove);
AddStockToCustodian(order.OrderId, p.ProductNumber, p.SupplierNumber, model.SelectedCustodian, toRemove.Quantity);
}
}
}
db.SaveChanges();
List <GetCashOrderDetails_Result> details = db.GetCashOrderDetails(order.OrderId).ToList();
order.Total = details.Sum(c => c.OrderItemTotal);
order.DatePlaced = DateTime.Now;
db.Entry(order).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
if (customer != null && order != null && db.CashOrderDetails.Any(c => c.CashOrderId == order.OrderId))
{
result.Result = FreeMarketResult.Success;
}
else
{
result.Result = FreeMarketResult.Failure;
}
}
return(result);
}
