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); }