public ActionResult Create(Part part) { if (ModelState.IsValid) { db.Parts.Add(part); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(part)); }
public ActionResult Create(Piece piece) { if (ModelState.IsValid) { db.Pieces.Add(piece); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(piece)); }
public ActionResult Create(Catalog catalog) { if (ModelState.IsValid) { db.Catalogs.Add(catalog); db.SaveChanges(); return(RedirectToAction("Index", new { catalogName = catalog.catalogName })); } ViewBag.parentCatalog = new SelectList(db.Catalogs.Where(c => c.catalogName != catalog.catalogName), "catalogId", "catalogValue", catalog.parentCatalog); return(View(catalog)); }
public ActionResult Create(Supplier supplier) { if (ModelState.IsValid) { db.Suppliers.Add(supplier); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.idRepresentative = new SelectList(db.Employees, "employeeId", "employeeName", supplier.idRepresentative); return(View(supplier)); }
public ActionResult Create(ReplacedPiece replacedpiece) { if (ModelState.IsValid) { db.ReplacedPieces.Add(replacedpiece); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.servicePartId = new SelectList(db.ServiceParts, "servicePartId", "servicePartDescription", replacedpiece.servicePartId); ViewBag.supplierPieceId = new SelectList(db.SupplierPieces, "supplierPieceId", "supplierPieceId", replacedpiece.supplierPieceId); ViewBag.statusId = new SelectList(db.Catalogs, "catalogId", "catalogValue", replacedpiece.statusId); return(View(replacedpiece)); }
public ActionResult Create([Bind(Exclude = "realPrice,estimatedPrice")] Service service) { if (ModelState.IsValid) { db.Services.Add(service); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.statusId = new SelectList(db.Catalogs.Where(cat => cat.catalogName == "Reconstruction Status"), "catalogId", "catalogValue", service.statusId); ViewBag.customerId = new SelectList(db.Customers, "customerId", "customerName", service.customerId); ViewBag.employeeId = new SelectList(db.Employees, "employeeId", "employeeName", service.employeeId); return(View(service)); }
public ActionResult Create(ServicePart servicepart) { if (ModelState.IsValid) { db.ServiceParts.Add(servicepart); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.partId = new SelectList(db.Parts, "partId", "partName", servicepart.partId); ViewBag.statusId = new SelectList(db.Catalogs, "catalogId", "catalogValue", servicepart.statusId); ViewBag.serviceId = new SelectList(db.Services, "serviceId", "serviceDescription", servicepart.serviceId); return(View(servicepart)); }
public ActionResult Create(ServiceCar servicecar) { if (ModelState.IsValid) { db.ServiceCars.Add(servicecar); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.carBrandId = new SelectList(db.Catalogs, "catalogId", "catalogValue", servicecar.carBrandId); ViewBag.carModelId = new SelectList(db.Catalogs, "catalogId", "catalogValue", servicecar.carModelId); ViewBag.statusId = new SelectList(db.Catalogs, "catalogId", "catalogValue", servicecar.statusId); ViewBag.serviceId = new SelectList(db.Services, "serviceId", "serviceDescription", servicecar.serviceId); return(View(servicecar)); }
public ActionResult Create(Customer customer) { if (ModelState.IsValid) { db.Customers.Add(customer); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.userLogin = new SelectList(db.UserProfiles. Where(us => !db.Employees.Any(em => em.userLogin == us.UserName) && !db.Customers.Any(cu => cu.userLogin == us.UserName)). Select(u => u.UserName).Distinct().OrderBy(name => name).ToList(), customer.userLogin); return(View(customer)); }
public ActionResult Create(Employee employee) { if (ModelState.IsValid) { db.Employees.Add(employee); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.positionId = new SelectList(db.Catalogs.Where(c => c.catalogName == "Employee Position"), "catalogId", "catalogValue", employee.positionId); ViewBag.userLogin = new SelectList(db.UserProfiles. Where(us => !db.Employees.Any(em => em.userLogin == us.UserName) && !db.Customers.Any(cu => cu.userLogin == us.UserName)). Select(u => u.UserName).Distinct().OrderBy(name => name).ToList(), employee.userLogin); return(View(employee)); }
public ActionResult Edit(UserProfile userprofile, string RoleName) { if (ModelState.IsValid) { webpages_Roles role; role = db.webpages_Roles.Where(ro => ro.RoleName == RoleName).FirstOrDefault(); if (role != null) { var user = db.UserProfiles.Where(u => u.UserId == userprofile.UserId).FirstOrDefault(); var roleInUser = user.webpages_Roles.Where(ro => ro.RoleId == role.RoleId).FirstOrDefault(); if (!user.webpages_Roles.Remove(roleInUser)) { user.webpages_Roles.Add(role); } db.SaveChanges(); } return(RedirectToAction("Index")); } return(View(userprofile)); }
public ActionResult Create(SupplierPart supplierpart) { if (ModelState.IsValid) { db.SupplierParts.Add(supplierpart); db.SaveChanges(); //Find the Part var part = db.Parts.Find(supplierpart.partId); //Obtain the average price var average = (decimal?)db.SupplierParts.Where(sp => sp.partId == supplierpart.partId && sp.supplierId != CarPartReconstructionId).Average(sp => (decimal?)sp.price); if (average != null) { //Verify if the difference between reference price and the average of the suppliers prices exceed the five percent var twoPercent = (decimal)(part.partPrice * 0.02m); if (Math.Abs((decimal)(part.partPrice - average)) > twoPercent) { var referencePrice = part.partPrice; part.partPrice = Math.Round((decimal)average, 2); return(RedirectToAction("UpdatePartPrice", new { partId = part.partId, supplierId = supplierpart.supplierId, averagePrice = average })); } } return(RedirectToAction("Index", new { supplierId = supplierpart.supplierId })); } ViewBag.partId = new SelectList( db.Parts.Where(pa => !db.SupplierParts.Any(sp => sp.supplierId == supplierpart.supplierId && sp.partId == pa.partId)) , "partId", "partName", supplierpart.partId); ViewBag.supplierId = new SelectList( db.Suppliers.Where(su => su.supplierId == supplierpart.supplierId), "supplierId", "supplierName", supplierpart.supplierId); return(View(supplierpart)); }
public ActionResult ExternalLoginConfirmation(RegisterExternalLoginModel model, string returnUrl) { string provider = null; string providerUserId = null; if (User.Identity.IsAuthenticated || !OAuthWebSecurity.TryDeserializeProviderUserId(model.ExternalLoginData, out provider, out providerUserId)) { return(RedirectToAction("Manage")); } if (ModelState.IsValid) { // Insert a new user into the database using (var db = new db_cars_parts_reconstructionStrConn()) { UserProfile user = db.UserProfiles.FirstOrDefault(u => u.UserName.ToLower() == model.UserName.ToLower()); // Check if user already exists if (user == null) { // Insert name into the profile table db.UserProfiles.Add(new UserProfile { UserName = model.UserName }); db.SaveChanges(); OAuthWebSecurity.CreateOrUpdateAccount(provider, providerUserId, model.UserName); OAuthWebSecurity.Login(provider, providerUserId, createPersistentCookie: false); return(RedirectToLocal(returnUrl)); } else { ModelState.AddModelError("UserName", "User name already exists. Please enter a different user name."); } } } ViewBag.ProviderDisplayName = OAuthWebSecurity.GetOAuthClientData(provider).DisplayName; ViewBag.ReturnUrl = returnUrl; return(View(model)); }