public IActionResult Index() { try { var value = HttpContext.Session.GetString("user"); User user = JsonConvert.DeserializeObject <User>(value); Models.CustomerContext context = HttpContext.RequestServices.GetService(typeof(BugReportMVC5.Models.CustomerContext)) as Models.CustomerContext; TempData["User"] = user; if (user.role_id == 3) { return(View(context.GetAllCustomers())); } else { ModelState.AddModelError("Error", "Unauthorized!!"); return(RedirectToAction("Index", "Home")); } } catch { ModelState.AddModelError("Error", "Login First!!"); return(RedirectToAction("Index", "Home")); } }
// GET: Customer public ActionResult GetAllCustomers() { var db = new Models.CustomerContext(); List<Models.Customer> GetAllCustomers = db.Customer.ToList(); ViewData.Model = GetAllCustomers; //ViewBag.Message = "Click here " + GetAllCustomers[0].FirstName; ViewData["Message"] = "Do some stuff..and some shit: "; return View(); }
public ActionResult createCustomer1() { try { Customer customer = new Customer(); // customer.Customer_id= Convert.ToInt32( Request.Form["Customer_id"]); customer.Customer_name = Convert.ToString(Request.Form["Customer_name"]); Models.CustomerContext context = HttpContext.RequestServices.GetService(typeof(BugReportMVC5.Models.CustomerContext)) as Models.CustomerContext; if (context.createCustomer(customer) == 0) { Customer custumorInserted = context.FindCustomer(customer.Customer_name)[0]; Models.UserContext user_context = HttpContext.RequestServices.GetService(typeof(BugReportMVC5.Models.UserContext)) as Models.UserContext; User user = new User(); user.customer_id = custumorInserted.Customer_id; user.email = custumorInserted.Customer_name + "default"; user.password = "******"; user.phone_number = 123; user.role_id = 4; user.user_name = custumorInserted.Customer_name + "admin"; user_context.createUser(user); // TempData["User"] = user; return(RedirectToAction("Index")); } else { TempData["Errors"] = "Duplicate entry!!"; return(RedirectToAction("createCustomer")); } } catch (SqlException ex) { string message = ex.Message.ToString();//e.Data.ToString();//+ " " + e.InnerException.ToString() + " "+e.Message.ToString(); TempData["Errors"] = message; // TempData["Errors"] = "Duplicate records!! Please enter unique values"; return(RedirectToAction("createCustomer")); } //catch //{ // // TempData["User"] = user; // TempData["Errors"] = "An Error Ocurred!! Kindly enter the details correctly!!"; // return RedirectToAction("createCustomer"); //} }
public CustomerController(CustomerContext context) { _context = context; if (_context.Customers.Count() == 0) { // Create a new customer if collection is empty, // which means you can't delete all customers. _context.Customers.Add(new Customer { FirstName = "Frank", LastName = "Lampard", DateOfBirth = Convert.ToDateTime("1978-06-20T00: 00:00") }); _context.SaveChanges(); } }
public ActionResult createUser() { try { var value = HttpContext.Session.GetString("user"); User user = JsonConvert.DeserializeObject <User>(value); if (user.role_id == 3) { // Models.ProblemContext context = HttpContext.RequestServices.GetService(typeof(Models.ProblemContext)) as Models.ProblemContext; Models.CustomerContext customer_context = HttpContext.RequestServices.GetService(typeof(Models.CustomerContext)) as Models.CustomerContext; //Models.StatusContext status_context = HttpContext.RequestServices.GetService(typeof(Models.StatusContext)) as Models.StatusContext; //var bugs = from b in context.GetAllProblems() select b; //var customers = (from c in customer_context.GetAllCustomers() select (c.Customer_id, c.Customer_name)).ToList(); var customers = (from c in customer_context.GetOnlyCustomers() select(c.Customer_id, c.Customer_name)).ToList(); ViewBag.ListofCustomer = customers; // Models.CustomerContext context = HttpContext.RequestServices.GetService(typeof(BugReportMVC5.Models.CustomerContext)) as Models.CustomerContext; TempData["User"] = user; return(View()); } else { ModelState.AddModelError("Error", "Unauthorized!!"); return(RedirectToAction("Index", "Home")); } } catch { ModelState.AddModelError("Error", "Login First!!"); return(RedirectToAction("Index", "Home")); } }
public ActionResult CreateCustomer(FormCollection inList) { try { using (var db = new Models.CustomerContext()) { var newCustomer = new Models.Customer(); newCustomer.FirstName = inList["FirstName"]; newCustomer.LastName = inList["LastName"]; newCustomer.Address = inList["Address"]; // kan ikke bruke dette array i LINQ nedenfor string inZip = inList["ZipCode"]; var foundPostalArea = db.PostalArea .FirstOrDefault(p => p.ZipCode == inZip); if (foundPostalArea == null) // fant ikke poststed, må legge inn et nytt { var newPostalArea = new Models.PostalArea(); newPostalArea.ZipCode = inList["ZipCode"]; newPostalArea.PostalArea_ = inList["PostalArea"]; db.PostalArea.Add(newPostalArea); // det nye poststedet legges i den nye brukeren newCustomer.PostalArea = newPostalArea; } else { // fant poststedet, legger det inn i den nye brukeren newCustomer.PostalArea = foundPostalArea; } db.Customer.Add(newCustomer); db.SaveChanges(); return RedirectToAction("GetAllCustomers"); } } catch (Exception e) { return View(); } }