public ActionResult Create(FormCollection collection, HttpPostedFileBase file1, HttpPostedFileBase file2, HttpPostedFileBase file3)
        {
            try
            {

                myHandler = new BusinessLogicHandler();
                gadget = new Technology();
                Company c = new Company();
                gadget.DateAdded = DateTime.Now;
                gadget.ModelName = collection.GetValue("techs.ModelName").AttemptedValue.ToString();
                gadget.Specs = collection.GetValue("techs.Specs").AttemptedValue.ToString();
                gadget.ModelNumber = collection.GetValue("techs.ModelNumber").AttemptedValue.ToString();
                gadget.ManufacturerID = Convert.ToInt32(collection.GetValue("Manufacturer").AttemptedValue);
                gadget.TechCategoryID = Convert.ToInt32(collection.GetValue("CategoryName").AttemptedValue);
                gadget.SupplierID = Convert.ToInt32(collection.GetValue("Name").AttemptedValue);
                gadget.CostPrice = Convert.ToDouble(collection.GetValue("techs.CostPrice").AttemptedValue);
                gadget.SellingPrice = Convert.ToDouble(collection.GetValue("techs.SellingPrice").AttemptedValue);
                gadget.IsBook = false;

                if (ModelState.IsValid)
                {
                    if (file1 != null)
                    {
                        file1.SaveAs(HttpContext.Server.MapPath("~/Uploads/Tech/") + file1.FileName);
                        gadget.ImageFront = file1.FileName;
                    }
                    if (file2 != null)
                    {
                        file2.SaveAs(HttpContext.Server.MapPath("~/Uploads/Tech/") + file2.FileName);
                        gadget.ImageTop = file2.FileName;
                    }
                    if (file3 != null)
                    {
                        file3.SaveAs(HttpContext.Server.MapPath("~/Uploads/Tech/") + file3.FileName);
                        gadget.ImageSide = file3.FileName;
                    }
                    Technology ta = new Technology();
                    ta = myHandler.AddExperimentTech(gadget);
                    ta.ModelName = gadget.ModelName;
                    ta.ModelNumber = gadget.ModelNumber;
                    ta.Specs = gadget.Specs;
                    ta.ManufacturerID = gadget.ManufacturerID;
                    ta.TechCategoryID = gadget.TechCategoryID;
                    ta.SupplierID = gadget.SupplierID;
                    //ta.CostPrice = gadget.CostPrice;
                    //ta.SellingPrice = gadget.SellingPrice;
                    //ta.IsBook = gadget.IsBook;
                    ta.ImageFront = gadget.ImageFront;
                    ta.ImageTop = gadget.ImageTop;
                    ta.ImageSide = gadget.ImageSide;
                    myHandler.AddTechnology(ta);

                    TempData["AlertMessage"] = "Device Successfully Added";
                }
                return RedirectToAction("Create", "Technology", gadget);
            }

            catch
            {
                AddNewTechViewModel techM = new AddNewTechViewModel();
                /*TEMP LIST*/
                //List<Supplier> nameList = new List<Supplier>();
                SupplierHandler supHandler = new SupplierHandler();
                IEnumerable<Supplier> nameList = (IEnumerable<Supplier>)supHandler.GetTechSupplierList();
                var disp = from nameAndId in nameList
                           select new { Value = nameAndId.SupplierID, Text = nameAndId.Name };

                ViewBag.SupplierList = new SelectList(disp.ToList());

                TechCategoryHandler typeHandler = new TechCategoryHandler();
                IEnumerable<TechCategory> typeList = (IEnumerable<TechCategory>)typeHandler.GetTechCategoryList();
                var dispTC = from name in typeList
                             select new { Value = name.TechCategoryID, Text = name.CategoryName };
                ViewBag.TechCategoryList = new SelectList(dispTC.ToList());

                ManufacturerHandler manHandler = new ManufacturerHandler();
                IEnumerable<Manufacturer> manList = (IEnumerable<Manufacturer>)manHandler.GetManufacturerList();
                var dispM = from mName in manList
                            select new { Value = mName.ManufacturerID, Text = mName.Name };
                ViewBag.ManufacturerList = new SelectList(dispM.ToList());

                List<SelectListItem> supplier = new List<SelectListItem>();
                //supplier.Add(new SelectListItem { Text = "Select Supplier", Value = "", Selected = true });
                foreach (var item in nameList)
                {
                    supplier.Add(new SelectListItem { Text = item.Name, Value = item.SupplierID.ToString() });
                }
                techM.suppliers = new List<SelectListItem>();
                techM.suppliers = supplier;
                ViewData["suppliers"] = supplier;

                List<SelectListItem> techCategory = new List<SelectListItem>();
                //techCategory.Add(new SelectListItem { Text = "Select Category", Value = "", Selected = true });
                foreach (var item in typeList)
                {
                    techCategory.Add(new SelectListItem { Text = item.CategoryName, Value = item.TechCategoryID.ToString(), Selected = true });
                }
                techM.techCategories = new List<SelectListItem>();
                techM.techCategories = techCategory;
                ViewData["techCategories"] = techCategory;

                List<SelectListItem> manufacturer = new List<SelectListItem>();
                //manufacturer.Add(new SelectListItem { Text = "Select Manufacturer", Value = "", Selected = true });
                foreach (var item in manList)
                {
                    manufacturer.Add(new SelectListItem { Text = item.Name, Value = item.ManufacturerID.ToString() });
                }
                techM.manufacturers = new List<SelectListItem>();
                techM.manufacturers = manufacturer;
                ViewData["manufacturers"] = manufacturer;

                return View(techM);
            }
        }
        public ActionResult Edit(int ProductID)
        {
            AddNewTechViewModel model = new AddNewTechViewModel();

            myHandler = new BusinessLogicHandler();
            gadget = new Technology();
            gadget = myHandler.GetTechnologyDetails(ProductID);

            model.techs = new Technology();
            model.techs = gadget;

            SupplierHandler supHandler = new SupplierHandler();
            /*TEMP LIST*/
            //List<Supplier> nameList = new List<Supplier>();
            IEnumerable<Supplier> nameList = (IEnumerable<Supplier>)supHandler.GetTechSupplierList();
            var disp = from nameAndId in nameList
                       select new { Value = nameAndId.SupplierID, Text = nameAndId.Name };

            ViewBag.SupplierList = new SelectList(disp.ToList());

            TechCategoryHandler typeHandler = new TechCategoryHandler();
            IEnumerable<TechCategory> typeList = (IEnumerable<TechCategory>)typeHandler.GetTechCategoryList();
            var dispTC = from name in typeList
                         select new { Value = name.TechCategoryID, Text = name.CategoryName };
            ViewBag.TechCategoryList = new SelectList(dispTC.ToList());

            ManufacturerHandler manHandler = new ManufacturerHandler();
            IEnumerable<Manufacturer> manList = (IEnumerable<Manufacturer>)manHandler.GetManufacturerList();
            var dispM = from mName in manList
                        select new { Value = mName.ManufacturerID, Text = mName.Name };
            ViewBag.ManufacturerList = new SelectList(dispM.ToList());

            model.techs = myHandler.GetTechnologyDetails(ProductID);
            Supplier sp = new Supplier();
            TechCategory tck = new TechCategory();
            Manufacturer mna = new Manufacturer();

            foreach (var item in manList)
            {
                if (item.ManufacturerID == model.techs.ManufacturerID)
                {
                    mna.ManufacturerID = item.ManufacturerID;
                    mna.Name = item.Name;
                }
            }
            foreach (var item in nameList)
            {
                if (item.SupplierID == model.techs.SupplierID)
                {
                    sp.SupplierID = item.SupplierID;
                    sp.Name = item.Name;
                }
            }
            foreach (var item in typeList)
            {
                if (item.TechCategoryID == model.techs.TechCategoryID)
                {
                    tck.TechCategoryID = item.TechCategoryID;
                    tck.CategoryName = item.CategoryName;
                }
            }

            List<SelectListItem> supplier = new List<SelectListItem>();
            supplier.Add(new SelectListItem { Value = sp.SupplierID.ToString(), Text = sp.Name, Selected = true });
            foreach (var item in nameList)
            {
                if (item.SupplierID != sp.SupplierID)
                    supplier.Add(new SelectListItem { Text = item.Name, Value = item.SupplierID.ToString() });
            }
            model.suppliers = new List<SelectListItem>();
            model.suppliers = supplier;
            ViewData["suppliers"] = supplier;

            List<SelectListItem> techCategory = new List<SelectListItem>();
            techCategory.Add(new SelectListItem { Value = tck.TechCategoryID.ToString(), Text = tck.CategoryName, Selected = true });
            foreach (var item in typeList)
            {
                if (item.TechCategoryID != tck.TechCategoryID)
                    techCategory.Add(new SelectListItem { Text = item.CategoryName, Value = item.TechCategoryID.ToString() });
            }
            model.techCategories = new List<SelectListItem>();
            model.techCategories = techCategory;
            ViewData["techCategories"] = techCategory;

            List<SelectListItem> manufacturer = new List<SelectListItem>();
            manufacturer.Add(new SelectListItem { Value = mna.ManufacturerID.ToString(), Text = mna.Name, Selected = true });
            foreach (var item in manList)
            {
                if (item.ManufacturerID != mna.ManufacturerID)
                    manufacturer.Add(new SelectListItem { Text = item.Name, Value = item.ManufacturerID.ToString() });
            }
            model.manufacturers = new List<SelectListItem>();
            model.manufacturers = manufacturer;
            ViewData["manufacturers"] = manufacturer;

            return View(model);
        }
        public ActionResult Create()
        {
            AddNewTechViewModel techM = new AddNewTechViewModel();
            /*TEMP LIST*/
            //List<Supplier> nameList = new List<Supplier>();
            SupplierHandler supHandler = new SupplierHandler();
            IEnumerable<Supplier> nameList = (IEnumerable<Supplier>)supHandler.GetTechSupplierList();
            var disp = from nameAndId in nameList
                       select new { Value = nameAndId.SupplierID, Text = nameAndId.Name };

            ViewBag.SupplierList = new SelectList(disp.ToList());

            TechCategoryHandler typeHandler = new TechCategoryHandler();
            IEnumerable<TechCategory> typeList = (IEnumerable<TechCategory>)typeHandler.GetTechCategoryList();
            var dispTC = from name in typeList
                         select new { Value = name.TechCategoryID, Text = name.CategoryName };
            ViewBag.TechCategoryList = new SelectList(dispTC.ToList());

            ManufacturerHandler manHandler = new ManufacturerHandler();
            IEnumerable<Manufacturer> manList = (IEnumerable<Manufacturer>)manHandler.GetManufacturerList();
            var dispM = from mName in manList
                        select new { Value = mName.ManufacturerID, Text = mName.Name };
            ViewBag.ManufacturerList = new SelectList(dispM.ToList());

            List<SelectListItem> supplier = new List<SelectListItem>();
            //supplier.Add(new SelectListItem { Text = "Select Supplier", Value = "", Selected = true });
            foreach (var item in nameList)
            {
                supplier.Add(new SelectListItem { Text = item.Name, Value = item.SupplierID.ToString() });
            }
            techM.suppliers = new List<SelectListItem>();
            techM.suppliers = supplier;
            ViewData["suppliers"] = supplier;

            List<SelectListItem> techCategory = new List<SelectListItem>();
            //techCategory.Add(new SelectListItem { Text = "Select Category", Value = "", Selected = true });
            foreach (var item in typeList)
            {
                techCategory.Add(new SelectListItem { Text = item.CategoryName, Value = item.TechCategoryID.ToString(), Selected = true });
            }
            techM.techCategories = new List<SelectListItem>();
            techM.techCategories = techCategory;
            ViewData["techCategories"] = techCategory;

            List<SelectListItem> manufacturer = new List<SelectListItem>();
            //manufacturer.Add(new SelectListItem { Text = "Select Manufacturer", Value = "", Selected = true });
            foreach (var item in manList)
            {
                manufacturer.Add(new SelectListItem { Text = item.Name, Value = item.ManufacturerID.ToString() });
            }
            techM.manufacturers = new List<SelectListItem>();
            techM.manufacturers = manufacturer;
            ViewData["manufacturers"] = manufacturer;

            return View(techM);
        }