//
        // 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());
        }
Beispiel #2
0
        //
        // 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());
        }
Beispiel #4
0
        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();
        }
Beispiel #5
0
        //[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()));
        }
Beispiel #6
0
        //
        // 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())));
        }
Beispiel #7
0
        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;
        }
Beispiel #8
0
        //
        // 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());
        }
Beispiel #9
0
        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);

        }
Beispiel #10
0
        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);
        }