public int AddStockOut(StockOutDTO dto)
{
using (session.BeginTransaction())
{
session.Save(dto);
session.Transaction.Commit();
return(dto.StockOutId);
}
}
public int DeleteStockOut(StockOutDTO dto)
{
using (session.BeginTransaction())
{
StockOutDTO old = session.Get <StockOutDTO>(dto.StockOutId);
session.Delete(old);
session.Transaction.Commit();
return(1);
}
}
//StockOut Functions
public int AddStockOut(StockOutDTO obj)
{
StockOutProvider provider = new StockOutProvider();
if (provider.GetStockOutById(obj.StockOutId) == null)
{
provider.AddStockOut(obj);
return(1);
}
return(-1);
}
public StockOutDTO GetStockOutById(int id)
{
StockOutDTO obj = null;
using (session.BeginTransaction())
{
obj = session.Get <StockOutDTO>(id);
}
return(obj);
}
public int UpdateStockOut(StockOutDTO dto)
{
using (session.BeginTransaction())
{
StockOutDTO old = session.Get <StockOutDTO>(dto.StockOutId);
old.Date = dto.Date;
old.Description = dto.Description;
old.OrderDetail = dto.OrderDetail;
old.Quantity = dto.Quantity;
old.Price = dto.Price;
old.Product = dto.Product;
session.SaveOrUpdate(old);
session.Transaction.Commit();
return(1);
}
}
public JsonResult Edit(int id, BigModelDTO obj)
{
MyRepository repository = new MyRepository();
OrderDTO orderObj = repository.GetOrder(id);
if (obj.customer.CustomerId == 0)
{
orderObj.Customer.CustomerId = repository.AddCustomer(obj.customer);
}
orderObj.Customer.CustomerId = obj.customer.CustomerId;
repository.UpdateOrder(orderObj);
foreach (var orderDetail in orderObj.OrderDetails)
{
foreach (var stockOut in orderDetail.StockOuts)
{
repository.DeleteStockOut(stockOut.StockOutId);
}
repository.DeleteOrderDetail(orderDetail.OrderDetailId);
}
int orderId = orderObj.OrderId;
foreach (var orderDetail in obj.orderDetail)
{
orderDetail.Order = new OrderDTO();
orderDetail.Order.OrderId = orderId;
repository.AddOrderDetail(orderDetail);
int orderDetailId = orderDetail.OrderDetailId;
StockOutDTO stockOut = new StockOutDTO();
stockOut.Date = obj.order.Date;
stockOut.Description = "Simple Order";
stockOut.Price = orderDetail.Amount;
stockOut.Product = new ProductDTO();
stockOut.Product.ProductId = orderDetail.Product.ProductId;
stockOut.Quantity = orderDetail.Quantity;
stockOut.OrderDetail = new OrderDetailDTO();
stockOut.OrderDetail.OrderDetailId = orderDetailId;
repository.AddStockOut(stockOut);
}
return(Json("Successfully updated", JsonRequestBehavior.AllowGet));
}
public JsonResult Create(BigModelDTO obj)
{
try
{
MyRepository repository = new MyRepository();
obj.order.Customer = new CustomerDTO();
if (obj.customer.CustomerId == 0)
{
obj.order.Customer.CustomerId = repository.AddCustomer(obj.customer);
}
obj.order.Customer.CustomerId = obj.customer.CustomerId;
repository.AddOrder(obj.order);
int orderId = obj.order.OrderId;
foreach (var orderDetail in obj.orderDetail)
{
orderDetail.Order = new OrderDTO();
orderDetail.Order.OrderId = orderId;
repository.AddOrderDetail(orderDetail);
int orderDetailId = orderDetail.OrderDetailId;
StockOutDTO stockOut = new StockOutDTO();
stockOut.Date = obj.order.Date;
stockOut.Description = "Simple Order";
stockOut.Price = orderDetail.Amount;
stockOut.Product = new ProductDTO();
stockOut.Product.ProductId = orderDetail.Product.ProductId;
stockOut.Quantity = orderDetail.Quantity;
stockOut.OrderDetail = new OrderDetailDTO();
stockOut.OrderDetail.OrderDetailId = orderDetailId;
repository.AddStockOut(stockOut);
}
return(Json("Successfully added", JsonRequestBehavior.AllowGet));
}
catch
{
return(Json("Error while adding", JsonRequestBehavior.AllowGet));
}
}
public int UpdateStockOut(StockOutDTO obj)
{
StockOutProvider provider = new StockOutProvider();
return(provider.UpdateStockOut(obj));
}
