// // GET: /Component/ public ActionResult Index(int?componentid) { var myComponentDataUtil = new ComponentDataUtil(); var myComponents = new Components(); var selectedComponent = new Component(); var sortedList = new List <Component>(); foreach (var component in myComponentDataUtil.GetAllComponents()) { myComponents._components.Add(component); } foreach (var component in myComponents._components) { if (component.ComponentID == componentid) { selectedComponent = component; } } foreach (var component in myComponents._components) { if (selectedComponent.ComponentName == component.ComponentName) { sortedList.Add(component); } } if (sortedList.Count > 0) { ViewData["AvailableQuantity"] = myComponents.GetAvailableQuantity(sortedList[0].ComponentName); return(View(sortedList[0])); } return(View()); }
// // GET: /Home/ public ActionResult Index(string searchString, string category) { var mySearcher = new Searcher(); var myComponentDataUtil = new ComponentDataUtil(); var myComponentList = new List <Component>(); var myComponents = new Components(); if (!String.IsNullOrEmpty(searchString)) { var SearchTags = mySearcher.SplitString(searchString); foreach (var component in myComponentDataUtil.GetComponents(SearchTags)) { myComponents._components.Add(component); } } else { if (!String.IsNullOrEmpty(category)) { foreach (var component in myComponentDataUtil.GetAllComponents()) { if (component.Category == category) { myComponents._components.Add(component); } } } else { foreach (var component in myComponentDataUtil.GetAllComponents()) { myComponents._components.Add(component); } } } var resultList = myComponents.GetAllCategories(); resultList.Sort(); var noneFound = new List <string>(); noneFound.Add("Ingen kategorier fundet"); if (resultList.Count != 0) { ViewData["Categories"] = resultList; } else { ViewData["Categories"] = noneFound; } return(View(myComponents._components.OrderBy(c => c.ComponentName).DistinctBy(c => c.SerieNr).ToList())); }
// // GET: /Reserve/ public ActionResult Index(string componentName) { var myDataUtil = new ComponentDataUtil(); if (myDataUtil.ComponentReservation(componentName, Session["User"].ToString())) { ViewBag.Message = "Du har reserveret " + componentName; return(View()); } ViewBag.Message = "Ikke muligt at reservere komponent, prøv igen"; return(View()); }
public MainViewModel() { //Initialization: selectedItemList_ = new ObservableCollection <Component>(); componentList_ = new ObservableCollection <Component>(); allComponentList_ = new ObservableCollection <Component>(); emailList_ = new ObservableCollection <Component>(); cdbUtil_ = new ComponentDataUtil(); ldbUtil_ = new LoanDataUtil(); //Get all components from database Refresh(); //Reset PW //Properties.Settings.Default.Reset(); }
//[AllowAnonymous] public ActionResult Reserve() { var mySearcher = new Searcher(); var myComponentDataUtil = new ComponentDataUtil(); var myComponents = new Components(); // Tjekker om der er indtastet en s�gning, hvis ja, hentes en komponentliste med de indtastede tags if (!String.IsNullOrEmpty(Session["User"].ToString())) { var studieNr = mySearcher.SplitString(Session["User"].ToString()); foreach (var component in myComponentDataUtil.GetComponents(studieNr)) { myComponents._components.Add(component); } } return(View(myComponents._components.OrderBy(c => c.ComponentName).ToList())); }
// // GET: /Home/ public ActionResult Index(string searchString, string category, int?page) { var componentsPerPage = new int?(); var mySearcher = new Searcher(); var myComponentDataUtil = new ComponentDataUtil(); var myComponents = new Components(); var emptyComponent = new Component(); var listOfQuantity = new List <int>(); emptyComponent.ComponentName = "Ingen Komponenter Fundet"; componentsPerPage = 20; // Tjekker om der er indtastet en søgning, hvis ja, hentes en komponentliste med de indtastede tags if (!String.IsNullOrEmpty(searchString)) { var SearchTags = mySearcher.SplitString(searchString); foreach (var component in myComponentDataUtil.GetComponents(SearchTags)) { myComponents._components.Add(component); } } else { //Tjekker om man har trykket på en kategori, hvis ja, hentes en komponentliste med den kategori if (!String.IsNullOrEmpty(category)) { foreach (var component in myComponentDataUtil.GetAllComponents()) { if (component.Category == category) { myComponents._components.Add(component); } } } else { foreach (var component in myComponentDataUtil.GetAllComponents()) { myComponents._components.Add(component); } } } //Opretter liste med alle kategorier var listOfCategories = myComponents.GetAllCategories(); //Sætter listen med kategorier i alfabetisk rækkefølge listOfCategories.Sort(); //Opretter liste til hvis der ikke eksisterer nogen kategorier var noneFound = new List <string> { "Ingen kategorier fundet" }; if (listOfCategories.Count != 0) { ViewData["Categories"] = listOfCategories; } else { ViewData["Categories"] = noneFound; } //Sorterer listen med komponenter, så den er i alfabetisk rækkefølge og komponenterne kun ankommer en gang. var sortedList = myComponents._components.OrderBy(c => c.ComponentName).DistinctBy(c => c.SerieNr).ToList(); //Udregner hvor mange sider, der skal være på hjemmesiden ViewData["NumberOfPages"] = (sortedList.Count + componentsPerPage - 1) / componentsPerPage; //Udregner hvor mange der er af hver komponent type(taget ud af serieNr), lægger det derefter over i en ny liste foreach (var component in sortedList) { listOfQuantity.Add(myComponents.GetAvailableQuantity(component.SerieNr)); } //Hvis dette tjek går igennem, er der ikke nok komponenter til at vise den ønskede side if (((componentsPerPage * page.GetValueOrDefault())) >= sortedList.Count || page < 0) { myComponents._components.Clear(); myComponents._components.Add(emptyComponent); listOfQuantity.Clear(); listOfQuantity.Add(0); return(View(myComponents._components)); } ViewData["AvailableQuantity"] = listOfQuantity; //Hvis dette tjek går igennem har man komponenter til overs, men ikke nok til at lave en "hel" side if (((componentsPerPage * page.GetValueOrDefault()) + componentsPerPage) > sortedList.Count) { return(View(sortedList.GetRange((page * componentsPerPage).GetValueOrDefault(), sortedList.Count - (componentsPerPage * page).GetValueOrDefault()))); } //Returnerer componentsPerPage, startende fra den side man er kommet til return(View(sortedList.GetRange(((page * componentsPerPage).GetValueOrDefault()), componentsPerPage.GetValueOrDefault()))); }
public List<Component> GetLoanedComponents() { var compUtil = new ComponentDataUtil(); var compList = new List<Component>(); foreach (var comp in compUtil.GetAllComponents()) { if (GetLoanInformation(comp).LoanDate != null && !(String.IsNullOrEmpty(GetLoanInformation(comp).OwnerID))) { compList.Add(comp); } } return compList; }
// // GET: /Component/ public ActionResult Index(int?componentid) { var myComponentDataUtil = new ComponentDataUtil(); var myComponents = new Components(); var selectedComponent = new Component(); var userCommentsList = new List <MvcHtmlString>(); var sortedList = new List <Component>(); var emptylist = new List <MvcHtmlString>(); LoanDataUtil ldu = new LoanDataUtil(); myComponents._LoanInformations = ldu.GetAllLoanInformation(); foreach (var component in myComponentDataUtil.GetAllComponents()) { myComponents._components.Add(component); } foreach (var component in myComponents._components) { if (component.ComponentID == componentid) { selectedComponent = component; } } foreach (var component in myComponents._components) { if (selectedComponent.ComponentName == component.ComponentName) { sortedList.Add(component); } } foreach (var component in sortedList) { if (!String.IsNullOrEmpty(component.UserComment)) { userCommentsList.Add(MvcHtmlString.Create(HttpUtility.HtmlEncode(component.UserComment + "\n\n Skrevet omkring komponent nummer: " + component.ComponentNumber).Replace("\n", "<br />"))); } } if (userCommentsList.Count < 1) { emptylist.Add(MvcHtmlString.Create(HttpUtility.HtmlEncode("Ingen kommentarer fundet"))); ViewData["UserComments"] = emptylist; } else { ViewData["UserComments"] = userCommentsList.Distinct().ToList(); } if (sortedList.Count > 0) { ViewData["AvailableQuantity"] = myComponents.GetAvailableQuantity(sortedList[0].ComponentName); return(View(sortedList[0])); } ViewData["AvailableQuantity"] = 0; return(View()); }
static void Main(string[] args) { /* Indsæt komponent */ //for (int i = 2; i < 5; i++) //{ // var comUtil = new ComponentDataUtil(); // var cp = new Component(); // cp.ComponentNumber = 22; // cp.SerieNr = "123FAQ"; // cp.ComponentName = "126 nF Kondensator"; // cp.ComponentInfo = "126 nF kondensator som bare virker pisse godt og som kan bruges til bluetooth"; // comUtil.CurrentComponent = cp; // comUtil.CreateComponent(cp); //} var CompDataUtil = new ComponentDataUtil(); CompDataUtil.CheckReservations(); //var cp = new Component(); //cp.ComponentNumber = 10; //cp.ComponentName = "Test2"; //cp.SerieNr = "123ADC"; //cp.Image = "hehehelol.jpg"; ////cp.Datasheet = "https://www.elfaelektronik.dk/elfa3~dk_da/elfa/init.do?item=10-389-16&toc=0&q=arduino"; //CompDataUtil.CurrentComponent = cp; //CompDataUtil.UpdateComponent(65, cp); //foreach (var comp in CompDataUtil.GetAllComponents()) //{ // Console.WriteLine(comp.ComponentID + " " + comp.ComponentName + " " + comp.ComponentNumber); //} //CompDataUtil.DeleteComponent(3); //var newlist = new List<string>(); //newlist.Add("Raspberry"); //newlist.Add("+"); //newlist.Add("Pi"); //foreach (var comp in CompDataUtil.GetComponents(newlist)) //{ // Console.WriteLine(comp.ComponentID + " "); //} //var u = new User(); //u.FirstName = "David"; //u.LastName = "Buhauer"; //u.Email = "*****@*****.**"; //userDataUtil.CurrentUser = u; //userDataUtil.CreateUser(u); //var u = new User(); //u.MobileNr = 76647283; //u.FirstName = "Carl"; //userDataUtil.UpdateUser(3, u); //userDataUtil.DeleteUser(1); //var cp = new Component(); //cp.ComponentNumber = 10; //cp.ComponentName = "Test2"; //cp.SerieNr = "123ADC"; //cp.Image = "hehehelol.jpg"; //cp.Datasheet = "https://www.elfaelektronik.dk/elfa3~dk_da/elfa/init.do?item=10-389-16&toc=0&q=arduino"; //var compDataUtil = new ComponentDataUtil(); //compDataUtil.UpdateComponent(108, cp); //List<string> list = new List<string>(); //list.Add("wifi"); //list.Add("+"); //list.Add("201270915"); //List<Component> cList = compDataUtil.GetComponents(list); //foreach (var comp in cList) //{ // Console.WriteLine(comp.ComponentID); //} //compDataUtil.CreateComponent(cp); //compDataUtil.DeleteComponent(143); //var loanDataUtil = new LoanDataUtil(); //LoanInformation loan = new LoanInformation(); //loan.ReservationDate = new SqlDateTime(2014, 3, 15); //loanDataUtil.UpdateLoanInformation(160, loan); //var loan = new LoanInformation(); //loan.AdminComment = "sut mig"; //loan.UserComment = "HEHEHE"; //loan.LoanDate = new SqlDateTime(); //loan.ReturnDate = new SqlDateTime(); //loanDataUtil.UpdateLoanInformation(1, loan); //if (compDataUtil.LoanTimeExceeded().Count > 0) //{ // foreach (var comp in compDataUtil.LoanTimeExceeded()) // { // Console.WriteLine(comp.ComponentID + " " + comp.ComponentName); // } //} //List<Component> comps = compDataUtil.GetAllComponents(); //loan = loanDataUtil.GetLoanInformation(comps[0]); //Console.WriteLine(loan.LoanID + " " + loan.Component); //loanDataUtil.UpdateLoanInformation(14, loan); //for (int i = 1; i < compDataUtil.GetAllComponents().Count; i++) //{ // loanDataUtil.UpdateLoanInformation(i, loan); //} ////compDataUtil.DeleteComponent(180); //compDataUtil.LoanTimeExceeded(); //compDataUtil.ComponentReservation("Raspberry Pi Model B 120", 1); //foreach (var comp in loanDataUtil.GetLoanedComponents()) //{ // Console.WriteLine(comp.ComponentID + " " + comp.ComponentName); //} /* Test af udlånt/reserveret komponenter for student ID med X nummer */ //Component newcomp = new Component(); //newcomp.OwnerID = 9; //compDataUtil.UpdateComponent(1, newcomp); //Console.WriteLine("------LÅNT-----"); //foreach (var comp in loanDataUtil.GetLoanedComponentFromStudentId("201270749")) //{ // Console.WriteLine("---------------"); // Console.WriteLine(comp.ComponentID + " " + comp.ComponentNumber + " " + comp.SerieNr + " " // + comp.ComponentName + " " + comp.ComponentInfo + " " + comp.Category // + " " + comp.Datasheet + " " + comp.Image); // Console.WriteLine("---------------"); //} //Console.WriteLine("---------------"); //Console.WriteLine(); //Console.WriteLine("----RESERVERET----"); //foreach (var comp in loanDataUtil.GetReservedComponentFromStudentId("201270749")) //{ // Console.WriteLine("---------------"); // Console.WriteLine(comp.ComponentID + " " + comp.ComponentNumber + " " + comp.SerieNr + " " // + comp.ComponentName + " " + comp.ComponentInfo + " " + comp.Category // + " " + comp.Datasheet + " " + comp.Image); // Console.WriteLine("---------------"); //} //Console.WriteLine("------------------"); //Console.WriteLine("----RESERVERING SLETTET----"); //loanDataUtil.RemoveReservation(1); /* Test af udlånt/reserveret komponenter for student ID med X nummer */ //var loan = new LoanInformation(); //loan.LoanDate = DateTime.Now; //loan.ReturnDate = new SqlDateTime(2014, 05, 02); //for (int i = 1; i <= 3; i++) // loanDataUtil.UpdateLoanInformation(i, loan); }