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));
}
