public IEnumerable<ModelViewModel> RetrieveModelByItemByBrand(ModelViewModel item) { var records = from models in db.Models join brands in db.Brands on models.BrandId equals brands.BrandId where models.BrandId == item.BrandId && models.ItemId == item.ItemId select models; return records; }
public ModelViewModel Create(ModelViewModel item) { var newRecord = new ModelViewModel { BrandId = item.BrandId, ModelNumber = item.ModelNumber, ItemId = item.ItemId, }; db.Models.Add(newRecord); db.SaveChanges(); return newRecord; }
public ModelViewModel Update(int id, ModelViewModel item) { var currentrecord = db.Models .Where(x => x.ModelId == id) .FirstOrDefault(); if (!(String.IsNullOrWhiteSpace(item.ModelNumber))) { currentrecord.ModelNumber = item.ModelNumber; currentrecord.Price = item.Price; db.SaveChanges(); return currentrecord; } return currentrecord; }
public ActionResult RevertArchive(ModelViewModel item) { try { string userId = User.Identity.GetUserId(); if (userId == null) { return RedirectToAction("Login", "Account"); } //Check if the "Admin" role exists if not it returns a null value var role = db.Roles.SingleOrDefault(m => m.Name == "Admin"); if (User.IsInRole("Admin")) { //Runs a query to determine if the user is actually an "Admin" if not it returns a null value //var userInRole = db.Users.Where(m => m.Roles.Any(r => r.UserId == userId)).FirstOrDefault(); //if (userInRole != null) //{ var specId = item.ModelId; if (specId < 1) { RedirectToAction("RetrieveArchives"); } if (item == null) { RedirectToAction("RetrieveArchives", new { message = ManageMessageId.Error }); } _repo.RevertArchive(specId); // return RedirectToAction("Retrieve"); return RedirectToAction("RetrieveArchives", new { message = ManageMessageId.RestoreSuccess }); } return RedirectToAction("Login", "Account"); } catch (Exception ex) { return new HttpStatusCodeResult(HttpStatusCode.InternalServerError, ex.ToString()); } }
public ActionResult Create(ModelViewModel item) { try { string userId = User.Identity.GetUserId(); if (userId == null) { return RedirectToAction("Login", "Account"); } //Check if the "Admin" role exists if not it returns a null value //var role = db.roles.singleordefault(m => m.name == "admin"); if (User.IsInRole("Admin")) { if (item == null) { return RedirectToAction("Retrieve", new { message = ManageMessageId.Error }); } // var newItem = _repository.Create(item); if (ModelState.IsValid) { ViewBag.BrandId = new SelectList(db.Brands.Where(x => x.Status == "Active"), "BrandId", "Name", item.BrandId); ViewBag.ItemId = new SelectList(db.Items.Where(x => x.AdminStatus == "Active"), "ItemId", "Description", item.ItemId); item.Status = "Active"; db.Models.Add(item); db.SaveChanges(); return RedirectToAction("Retrieve", new { message = ManageMessageId.AddSuccess }); } return RedirectToAction("Retrieve", new { message = ManageMessageId.Error }); } return RedirectToAction("Login", "Account"); } catch (Exception ex) { return new HttpStatusCodeResult(HttpStatusCode.InternalServerError, ex.ToString()); } }
// GET: Model/Create public ActionResult Create() { try { string userId = User.Identity.GetUserId(); if (userId == null) { return RedirectToAction("Login", "Account"); } //Check if the "Admin" role exists if not it returns a null value //var role = db.roles.singleordefault(m => m.name == "admin"); if (User.IsInRole("Admin")) { var newItem = new ModelViewModel(); ViewBag.BrandId = new SelectList(db.Brands.Where(x => x.Status == "Active"), "BrandId", "Name"); ViewBag.ItemId = new SelectList(db.Items.Where(x => x.AdminStatus == "Active"), "ItemId", "Description"); GetNewSupplierActivation(); GetNewModelsActivation(); return View(newItem); } return RedirectToAction("Login", "Account"); } catch (Exception ex) { return new HttpStatusCodeResult(HttpStatusCode.InternalServerError, ex.ToString()); } }
public ActionResult ModelCreation(SpecProductViewModel item, HttpPostedFileBase modelPhoto) { try { string userId = User.Identity.GetUserId(); if (userId == null) { return RedirectToAction("Login", "Account"); } //Check if the "Supplier" role exists if not it returns a null value var role = db.Roles.SingleOrDefault(m => m.Name == "Supplier"); if (User.IsInRole("Supplier")) { var photo = UploadPhoto(modelPhoto, item); if (photo != null) { SpecProductViewModel specProd = Session["SpecProd"] as SpecProductViewModel; int brandId = 0; //This object will allow us to use the convert to ConvertToTitleCase method var helper = new Helper(); //Convert to Title Case item.BrandName = helper.ConvertToTitleCase(item.BrandName); //Check if brand name exists var brand = (from b in db.Brands where b.Name == item.BrandName select b).FirstOrDefault(); //If the brand does not exist create a new one if (brand == null) { var newBrand = new BrandViewModel() { Name = item.BrandName }; db.Brands.Add(newBrand); db.SaveChanges(); brandId = newBrand.BrandId; } //if the brand does exist assign the existing brandId to the brandId of the new model if (brand != null) { brandId = brand.BrandId; } //Create a new instance of ModelViewModel and assign it to the model variable var model = new ModelViewModel(); model.Price = item.Price; model.Status = specProd.Status; model.UserId = userId; model.SupplierId = specProd.SupplierId; model.ItemId = specProd.ItemId; model.BrandId = brandId; model.ModelNumber = item.ModelNumber; model.DtCreated = DateTime.UtcNow; model.NumberDaysToAdvert = item.NumberDaysToAdvert; model.DeliveryInDays = item.DeliveryInDays; //Add a new model to the table model and save changes into the database db.Models.Add(model); db.SaveChanges(); var modelCommission = new ModelCommissionViewModel() { ModelId = model.ModelId }; string commissionName = "Tier1"; if (model.NumberDaysToAdvert >= 1 && model.NumberDaysToAdvert < 6) commissionName = "Tier1"; if (model.NumberDaysToAdvert >= 6 && model.NumberDaysToAdvert < 20) commissionName = "Tier2"; if (model.NumberDaysToAdvert >= 20) commissionName = "Tier3"; int commissionId = (from c in db.Commissions where c.Name == commissionName select c.CommissionId).FirstOrDefault(); modelCommission.CommissionId = commissionId; db.ModelCommissions.Add(modelCommission); db.SaveChanges(); var photoModel = new PhotoModelViewModel() { PhotoId = photo.PhotoId, ModelId = model.ModelId }; db.PhotoModels.Add(photoModel); db.SaveChanges(); Session["ModelSpecData"] = model; GetSupplierNotification(); return RedirectToAction("ModelSpecCreation"); //return RedirectToAction("ModelSpecCreation");on("ModelSpecCreation"); } } return RedirectToAction("Login", "Account"); } catch (Exception ex) { return new HttpStatusCodeResult(HttpStatusCode.InternalServerError, ex.ToString()); } }
public ActionResult ItemSelection(ItemViewModel item) { try { string userId = User.Identity.GetUserId(); if (userId == null) { return RedirectToAction("Login", "Account"); } //Check if the "Supplier" role exists if not it returns a null value var role = db.Roles.SingleOrDefault(m => m.Name == "Supplier"); if (User.IsInRole("Supplier")) { //Runs a query to determine if the user is actually an "Supplier" if not it returns a null value //var userInRole = db.Users.Where(m => m.Roles.Any(r => r.UserId == userId)).FirstOrDefault(); //if (userInRole != null) //{ if (item == null) { return HttpNotFound(); } records = _repository.RetrieveItemByProduct(item); ViewBag.ItemId = new SelectList(records, "ItemId", "Description", item.ItemId); TempData["ModelData"] = new ModelViewModel() { ItemId = item.ItemId }; GetSupplierNotification(); return RedirectToAction("ModelCreation"); } return RedirectToAction("Login", "Account"); } catch (Exception ex) { return new HttpStatusCodeResult(HttpStatusCode.InternalServerError, ex.ToString()); } }