public async Task <ActionResult> Check(FormCollection form, TransferModels transfer)
{
try
{
int id = Convert.ToInt32(TempData["id"]);
string name = TempData["name"].ToString();
int quantity = Convert.ToInt32(TempData["number"]);
int storeID = Convert.ToInt32(form["ddlList"].ToString());
//Create new transfer
laptopRepository.createTransfer(transfer, id, name, quantity, storeID);
//set laptop quantity to zero
var laptop = await laptopRepository.laptopFind(id);
laptop.Quantity = 0;
//reduce QoP of store for quantity number
var store = await laptopRepository.storeFind(storeID);
store.QoP -= quantity;
_db.SaveChanges();
return(RedirectToAction("Index", "Transfer", new { }));
}
catch (Exception e)
{
Console.WriteLine("{0} Exception caught.", e);
}
return(View());
}
public async Task <ActionResult> Create(FormCollection form, TransferModels transfer)
{
try
{
int LaptopID = Convert.ToInt32(form["LaptopName"].ToString());
await transferRepository.createTransfer(form, transfer, transferRepository);
if (await transferRepository.possibleCount(LaptopID) == 0)
{
return(RedirectToAction("Index", "Laptop", new { }));
}
return(RedirectToAction("Index", "Transfer", new { }));
}
catch (Exception e)
{
Console.WriteLine("{0} Exception caught.", e);
}
return(View());
}
//Create new transfer
public async void createTransfer(TransferModels transfer, int id, string name, int quantity, int storeID)
{
//Create new Transfer
transfer.LaptopID = id;
transfer.LaptopName = name;
transfer.LaptopQuantity = quantity;
transfer.StoreID = storeID;
transfer.Date = DateTime.Now; // add if any field you want insert
_db.TransferModels.Add(transfer); // pass the table object
await _db.SaveChangesAsync();
}
//Search and Paging
public async Task <object> pageCount(int pageSize, TransferModels transfer)
{
int pageCount = transfer.Child.Count();
int pages = pageCount / pageSize;
//ViewBag.pageCount = pages;
int rest = pageCount % pageSize;
if (rest < 10)
{
pages = pages + 1;
ViewBag.pageCount = pages;
}
return(ViewBag.pageCount);
}
public HttpResponseMessage GetLaptopByID([FromUri] TransferModels transfer)
{
int?laptopid = transfer.LaptopID;
if (laptopid == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Not found"));
}
List <TransferModels> transfers = (from k in _db.TransferModels where k.LaptopID == laptopid select k).ToList();
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK, transfers);
return(response);
}
public HttpResponseMessage GetStoreByID([FromUri] TransferModels transfer)
{
int?store = transfer.StoreID;
if (store == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Not found"));
}
List <StoreModels> transfers = (from k in _db.StoreModels where k.ID == store select k).ToList();
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK, transfers);
return(response);
}
//Create transfer
public async Task <TransferModels> createTransfer(FormCollection form, TransferModels transfer, TransferRepository transferRepository)
{
int storeID = Convert.ToInt32(form["StoreName"].ToString());
int LaptopID = Convert.ToInt32(form["LaptopName"].ToString());
int LaptopQuantity = Convert.ToInt32(form["LaptopQuantity"].ToString());
if (await transferRepository.possibleCount(LaptopID) > 0)
{
transfer.StoreID = storeID;
transfer.LaptopID = LaptopID;
transfer.LaptopName = await transferRepository.laptop(LaptopID);
transfer.LaptopQuantity = LaptopQuantity;
transfer.Date = DateTime.Now;
_db.TransferModels.Add(transfer);
await _db.SaveChangesAsync();
//get Laptop
var laptop = await transferRepository.storeFind(storeID);
laptop.QoP -= LaptopQuantity; // reduce QoP for quantity number
// transferRepository.SaveData();
await _db.SaveChangesAsync();
var laptopFind = await transferRepository.laptopFind(transfer.LaptopID);
laptopFind.Quantity -= LaptopQuantity; // reduce LaptopQuantity from Quantity
// transferRepository.laptopFind(transfer.LaptopID).Quantity -= LaptopQuantity;
await _db.SaveChangesAsync();
LogModels log = new LogModels
{
Type = "2",
Description = "New transfer was inserted with transfer of laptop called " + transfer.LaptopName + " with quantity of " +
transfer.LaptopQuantity + " on date " + DateTime.Now + " with location to " + laptop.Name + ", " + laptop.Location + ".",
Date = DateTime.Now
};
_db.LogModels.Add(log);
await _db.SaveChangesAsync();
}
return(transfer);
}
private void AddTransferModel(TransferModel transferModel)
{
TransferModels.Add(transferModel);
}
