public logModel.logString getLastLog()
{
using (var db = new WarehouseEntities())
{
List <logModel.logDate> lastlog = (from l in db.logs
orderby l.historyID descending
join i in db.items on l.itemID equals i.itemID
select new logModel.logDate
{
historyID = l.historyID,
itemID = l.itemID,
itemName = i.itemName,
total = l.total,
description = l.description,
date = l.date,
invoicenumber = l.invoicenumber
}).ToList();
logModel.logString ll = (from l in lastlog
select new logModel.logString
{
historyID = l.historyID,
itemID = l.itemID,
itemName = l.itemName,
total = l.total,
description = l.description,
date = l.date.ToString("yyyyMMdd"),
invoicenumber = l.invoicenumber
}).First();
return(ll);
}
}
//
// GET: /log/getlastlog
//
public ActionResult getlastlog()
{
logModel.logString lm = _logRepository.getLastLog();
return(Json(new
{
lm
}, JsonRequestBehavior.AllowGet));
}
public ActionResult insertLog(int itemID, int totalnumber, int reasonID)
{
String description = _reasonRepository.getDescription(reasonID);
String itemName = _itemRepository.GetItemName(itemID);
log newlog = _logRepository.insertLog(itemID, totalnumber, description);
warehouse newwarehouse = _warehouseRepository.UpdateWarehouse(itemID, totalnumber, description);
logModel.logString lm = logModel.ToLogString(newlog, itemName);
warehouseModel wm = warehouseModel.ToWarehouseModel(newwarehouse, itemName);
return(Json(new
{
lm
}));
}
