public void OnGet() { var resList = DbConn.GetAllBorrows(); var parameter = Convert.ToInt32(Request.Query["status"]); StatusMessage = MainMethods.StatusHandler(parameter); if (resList[0].ToString() == "Success") { var paraList = (List <object>)resList[1]; if (paraList.Count > 0) { BorrowList = MainMethods.FillBorrowList(paraList); //Wenn alles bei den Verleihen geklappt hat werden nun die Items dazu aus der Datenbank geholt resList = DbConn.GetAllItems(); if (resList[0].ToString() == "Success") { paraList = (List <object>)resList[1]; if (paraList.Count > 0) { ItemList = MainMethods.FillItemList(paraList); } } } } else { StatusMessage = "Beim Laden der Daten aus der Datenbank geschah ein Fehler!"; } }
public void OnGet() { if (MainMethods.IsUserCreator(User.Identity.Name) == "J") { var resList = DbConn.GetAllItems(); var parameter = Convert.ToInt32(Request.Query["status"]); StatusMessage = MainMethods.StatusHandler(parameter); if (resList[0].ToString() == "Success") { var paraList = (List <object>)resList[1]; if (paraList.Count > 0) { ItemList = MainMethods.FillItemList(paraList); foreach (var item in ItemList) { var selectItem = new SelectListItem(item.Id + ". " + item.Description, item.Id.ToString()); Items.Add(selectItem); } } if (Request.Query["id"].Count > 0) { var paraId = Request.Query["id"][0]; foreach (var item in Items) { if (item.Value == paraId) { item.Selected = true; } } var res = DbConn.GetAllBorrowsWithThisItem(Convert.ToUInt32(paraId)); if (res[0].ToString() == "Success" && StatusMessage.Length > 0) { var lastDate = MainMethods.GetLastDate(Convert.ToUInt32(paraId)); StatusMessage += $" Item ist ab dem {lastDate:dd.MM.yyyy} wieder komplett verfügbar!"; } } } else { Response.Redirect("/Borrow/Index?status=3"); } } else { Response.Redirect("/Borrow/Index?status=2"); } }
public void OnGet() { if(Request.Query["search"].Count > 0) { SearchString = Request.Query["search"][0]; OnlyAvailable = Convert.ToBoolean(Request.Query["available"][0]); var resList = DbConn.GetAllSearchedItems(SearchString); if(resList[0].ToString() == "Success") { var paraList = (List<object>)resList[1]; ItemList = new List<ItemModel>(); if(OnlyAvailable == true) { var list = MainMethods.FillItemList(paraList); foreach (var item in list) { if (!IsItemBorrowed(item.Id)) { ItemList.Add(item); } } } else { ItemList = MainMethods.FillItemList(paraList); } } } else { var resList = DbConn.GetAllItems(); var parameter = Convert.ToInt32(Request.Query["status"]); StatusMessage = MainMethods.StatusHandler(parameter); if (resList[0].ToString() == "Success") { var paraList = (List<object>)resList[1]; if (paraList.Count > 0) { ItemList = MainMethods.FillItemList(paraList); } } else { StatusMessage = "Beim Laden der Daten aus der Datenbank geschah ein Fehler!"; } } }
public void OnGet() { if (MainMethods.IsUserCreator(User.Identity.Name) == "J") { var parameter = Request.Query["id"].Count > 0 ? Request.Query["id"][0] : string.Empty; if (uint.TryParse(parameter, out uint id)) { Borrow = MainMethods.GetBorrow(id); Item = MainMethods.GetItem(Borrow.ItemId); BorrowDate = Convert.ToDateTime(Borrow.BorrowDate).ToString("yyyy-MM-dd"); Availability = Convert.ToDateTime(Borrow.Availability).ToString("yyyy-MM-dd"); var res = DbConn.GetAllItems(); if (res[0].ToString() == "Success") { var paraList = (List <object>)res[1]; ItemList = MainMethods.FillItemList(paraList); foreach (var item in ItemList) { var selectItem = new SelectListItem(item.Id + ". " + item.Description, item.Id.ToString()); Items.Add(selectItem); } if (Request.Query["itemId"].Count > 0) { var paraId = Request.Query["itemId"][0]; foreach (var item in Items) { if (item.Value == paraId) { item.Selected = true; } } } } } else { Response.Redirect("/Borrow/Index?status=3"); } } else { Response.Redirect("/Borrow/Index?status=2"); } }
private void FillItemList() { var res = DbConn.GetAllItems(); if (res[0].ToString() == "Success") { var paraList = (List <object>)res[1]; ItemList = MainMethods.FillItemList(paraList); } else { StatusMessage = "Fehler in der Datenbank"; } }