public JsonResult RemoveReceiptDetail(int id)
{
var item = InventoryReceiptDetail.Find(id);
using (var scope = new TransactionScope()) {
item.DeleteAndFlush();
}
return(Json(new {
id = id,
result = true
}));
}
public JsonResult EditReceiptDetailQuantity(int id, decimal value)
{
var detail = InventoryReceiptDetail.Find(id);
if (value >= 0)
{
detail.Quantity = value;
using (var scope = new TransactionScope()) {
detail.UpdateAndFlush();
}
}
return(Json(new {
id = id,
value = detail.Quantity
}));
}
public JsonResult AddReceiptDetail(int movement, int product)
{
var p = Product.Find(product);
var item = new InventoryReceiptDetail {
Receipt = InventoryReceipt.Find(movement),
Product = p,
ProductCode = p.Code,
ProductName = p.Name,
Quantity = 1,
QuantityOrdered = 0
};
using (var scope = new TransactionScope()) {
item.CreateAndFlush();
}
return(Json(new {
id = item.Id
}));
}
public ActionResult Confirm(int id)
{
PurchaseOrder item = PurchaseOrder.Find(id);
var qry = from x in item.Details
group x by x.Warehouse into g
select new {
Warehouse = g.Key,
Details = g.ToList()
};
var dt = DateTime.Now;
var employee = CurrentUser.Employee;
using (var scope = new TransactionScope()) {
foreach (var x in qry)
{
var master = new InventoryReceipt {
Order = item,
Warehouse = x.Warehouse,
CreationTime = dt,
ModificationTime = dt,
Creator = employee,
Updater = employee,
Store = x.Warehouse.Store
};
master.Create();
foreach (var y in x.Details)
{
var detail = new InventoryReceiptDetail {
Receipt = master,
Product = y.Product,
QuantityOrdered = y.Quantity,
Quantity = y.Quantity,
ProductCode = y.ProductCode,
ProductName = y.ProductName
};
detail.Create();
InventoryHelpers.ChangeNotification(TransactionType.PurchaseOrder, item.Id,
item.ModificationTime, x.Warehouse, null, y.Product, y.Quantity);
}
}
foreach (var x in item.Details)
{
var price = x.Product.Prices.SingleOrDefault(t => t.List.Id == 0);
if (price == null)
{
price = new ProductPrice {
List = PriceList.Find(0),
Product = x.Product
};
}
price.Value = x.Price;
price.Save();
}
item.IsCompleted = true;
item.ModificationTime = DateTime.Now;
item.UpdateAndFlush();
}
return(RedirectToAction("Index"));
}
public ActionResult GetReceiptItem(int id)
{
return(PartialView("Receipts/_DetailEditView", InventoryReceiptDetail.Find(id)));
}
public JsonResult AddReceiptDetail(int movement, int product)
{
var p = Product.Find (product);
var item = new InventoryReceiptDetail {
Receipt = InventoryReceipt.Find (movement),
Product = p,
ProductCode = p.Code,
ProductName = p.Name,
Quantity = 1,
QuantityOrdered = 0
};
using (var scope = new TransactionScope ()) {
item.CreateAndFlush ();
}
return Json (new {
id = item.Id
});
}
public ActionResult Confirm(int id)
{
PurchaseOrder item = PurchaseOrder.Find (id);
var qry = from x in item.Details
group x by x.Warehouse into g
select new {
Warehouse = g.Key,
Details = g.ToList ()
};
var dt = DateTime.Now;
var employee = CurrentUser.Employee;
using (var scope = new TransactionScope ()) {
foreach (var x in qry) {
var master = new InventoryReceipt {
Order = item,
Warehouse = x.Warehouse,
CreationTime = dt,
ModificationTime = dt,
Creator = employee,
Updater = employee,
Store = x.Warehouse.Store
};
master.Create ();
foreach (var y in x.Details) {
var detail = new InventoryReceiptDetail {
Receipt = master,
Product = y.Product,
QuantityOrdered = y.Quantity,
Quantity = y.Quantity,
ProductCode = y.ProductCode,
ProductName = y.ProductName
};
detail.Create ();
InventoryHelpers.ChangeNotification (TransactionType.PurchaseOrder, item.Id,
item.ModificationTime, x.Warehouse, null, y.Product, y.Quantity);
}
}
foreach (var x in item.Details) {
var price = x.Product.Prices.SingleOrDefault (t => t.List.Id == 0);
if (price == null) {
price = new ProductPrice {
List = PriceList.Find (0),
Product = x.Product
};
}
price.Value = x.Price;
price.Save ();
}
item.IsCompleted = true;
item.ModificationTime = DateTime.Now;
item.UpdateAndFlush ();
}
return RedirectToAction ("Index");
}
