public ActionResult Create([Bind(Include = "ShopAssistantName")] ShopAssistantDTO shopAssistantDTO)
{
IUnitOfWork database = new EFUnitOfWork();
var shopAssistant = new ShopAssistantDAL {
ShopAssistantName = shopAssistantDTO.ShopAssistantName, Id = shopAssistantDTO.Id
};
try
{
if (ModelState.IsValid)
{
database.ShopAssistants.Insert(shopAssistant);
database.ShopAssistants.Save();
return(RedirectToAction("Index"));
}
}
catch (DataException /* dex */)
{
//Log the error (uncomment dex variable name after DataException and add a line here to write a log.
ModelState.AddModelError(string.Empty, "Unable to save changes. Try again, and if the problem persists contact your system administrator.");
}
return(View(shopAssistantDTO));
}
public void AddOrder(OrderDTO orderDTO)
{
lock (_locker)
{
var ShopAssistant = new ShopAssistantDAL()
{
ShopAssistantName = orderDTO.ShopAssistant
};
var customer = new CustomerDAL()
{
CustomerName = orderDTO.Customer
};
var product = new ProductDAL()
{
ProductName = orderDTO.Product,
// if (orderDto.Amount == 0)
//{
// throw new DivideByZeroException();
//}
ProductPrice = orderDTO.Price / orderDTO.Amount
};
var ShopAssistantId = database.ShopAssistants.GetId(ShopAssistant);
if (ShopAssistantId == null)
{
database.ShopAssistants.Insert(ShopAssistant);
database.Save();
ShopAssistantId = database.ShopAssistants.GetId(ShopAssistant);
}
var CustomerId = database.Customers.GetId(customer);
if (CustomerId == null)
{
database.Customers.Insert(customer);
database.Save();
CustomerId = database.Customers.GetId(customer);
}
var productId = database.Products.GetId(product);
if (productId == null)
{
database.Products.Insert(product);
database.Save();
productId = database.Products.GetId(product);
}
OrderDAL order = new OrderDAL
{
OrderDate = orderDTO.OrderDate,
ShopAssistantId = ShopAssistant.Id,
CustomerId = customer.Id,
ProductId = product.Id,
Price = orderDTO.Price,
Amount = orderDTO.Amount
};
database.Orders.Insert(order);
database.Save();
}
}
public void AddOrder(OrderDTO orderDTO)
{
lock (_locker)
{
var ShopAssistant = new ShopAssistantDAL()
{
ShopAssistantName = orderDTO.ShopAssistant
};
var customer = new CustomerDAL()
{
CustomerName = orderDTO.Customer
};
//var orderDate = new OrderDAL() { OrderDate = orderDTO.OrderDate };
var product = new ProductDAL()
{
ProductName = orderDTO.Product,
// if (orderDto.Amount == 0)
//{
// throw new DivideByZeroException();
//}
ProductPrice = orderDTO.Price / orderDTO.Amount
};
var ShopAssistantId = database.ShopAssistants.GetId(ShopAssistant);
if (ShopAssistantId == null)
{
database.ShopAssistants.Insert(ShopAssistant);
database.Save();
ShopAssistantId = database.ShopAssistants.GetId(ShopAssistant);
}
var CustomerId = database.Customers.GetId(customer);
if (CustomerId == null)
{
database.Customers.Insert(customer);
database.Save();
CustomerId = database.Customers.GetId(customer);
}
var productId = database.Products.GetId(product);
if (productId == null)
{
database.Products.Insert(product);
database.Save();
productId = database.Products.GetId(product);
}
if (orderDTO.OrderDate.Year == 1)
{
orderDTO.OrderDate = DateTime.Now;
}
if (orderDTO.Id == 0)
{
var last = database.Orders.GetAll().Last();
orderDTO.Id = last.Id + 1;
}
OrderDAL order = new OrderDAL
{
Id = orderDTO.Id,
OrderDate = orderDTO.OrderDate,
ShopAssistantId = ShopAssistantId.Value,
CustomerId = CustomerId.Value,
ProductId = productId.Value,
Price = orderDTO.Price,
Amount = orderDTO.Amount
};
database.Orders.Insert(order);
database.Save();
}
}