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