public HttpResponseMessage BumpClaimCount(string id) { // add 1 to count of claims for customer. CustomerDBConnect customerDBConnect = new CustomerDBConnect(); var cust = from c in customerDBConnect.Custs where c.CustomerID == id select c; Cust rCust = new Cust(); foreach (var cus in cust) { cus.ClaimCount++; rCust = cus; } customerDBConnect.SaveChanges(); string output = JsonConvert.SerializeObject(rCust); return(new HttpResponseMessage() { Content = new StringContent(output, Encoding.UTF8, "application/json"), StatusCode = HttpStatusCode.Created }); }
public string CustomerEdits(CustomerDBConnect context, Customer customer) { var dup = from cust in context.Customers where cust.CustomerID == customer.CustomerID select cust; var message = ""; foreach (var cust in dup) { message = "Customer ID already used."; } if (message != "") { return(message); } var email = from cust in context.Customers where cust.Email == customer.Email select cust; message = ""; foreach (var cust in email) { message = "Email already used."; } if (message != "") { return(message); } return(""); // no errors }
public ActionResult CustomerReview() { Customer customer = new Customer(); CustomerDBConnect customerDBConnect = new CustomerDBConnect(); var customerID = Session["CustomerID"].ToString(); var lookup = from c in customerDBConnect.Customers where c.CustomerID == customerID select c; // first time populate with existing values foreach (var c in lookup) { ViewBag.screenCustomerID = c.CustomerID; customer.CustomerID = c.CustomerID; customer.CustomerPassword = Security.cry(c.Encrypted, -1); customer.FirstName = c.FirstName; customer.LastName = c.LastName; customer.Address1 = c.Address1; customer.Address2 = c.Address2; customer.City = c.City; customer.State = c.State; customer.Zip = c.Zip; customer.Email = c.Email; customer.Phone = c.Phone; } return(View(customer)); }
public ActionResult CustomerReviewSignOn(CustomerReviewSignOn s) { if (ModelState.IsValid == false) { return(View()); } CustomerDBConnect context = new CustomerDBConnect(); var cus = from cust in context.Customers where cust.CustomerID == s.CustomerID select cust; var found = false; var pass = ""; foreach (var cust in cus) { found = true; var passe = cust.Encrypted;; pass = Security.cry(passe, -1); } if (!found) { ViewBag.Message = "Customer ID not found."; return(View()); } if (pass != s.Password) { ViewBag.Message = "Incorrect password."; return(View()); } Session["CustomerID"] = s.CustomerID; if (s.Action == "Personal Info") { // register and this should pass custid in temp data for policy assignment. TempData["CustomerID"] = s.CustomerID; return(RedirectToAction("CustomerReview")); } if (s.Action == "Select New Policy") { return(RedirectToAction("AssignPolicy")); } return(View()); }
public HttpResponseMessage Put([FromBody] Cust cust) { // Update Customer CustomerDBConnect customerDbConnect = new CustomerDBConnect(); var cus = from c in customerDbConnect.Custs where c.CustomerID == cust.CustomerID select c; foreach (var u in cus) { u.CustomerID = cust.CustomerID; u.Encrypted = Security.cry(cust.Password, 1); u.Password = "******"; u.FirstName = cust.FirstName; u.LastName = cust.LastName; u.Email = cust.Email; u.Phone = cust.Phone; u.Address1 = cust.Address1; u.Address2 = cust.Address2; u.City = cust.City; u.State = cust.State; u.Zip = cust.Zip; u.ClaimCount = cust.ClaimCount; u.PolicyName = cust.PolicyName; u.PolicyID = cust.PolicyID; u.PromotionCode = cust.PromotionCode; } customerDbConnect.SaveChanges(); string output = JsonConvert.SerializeObject(cust); return(new HttpResponseMessage() { Content = new StringContent(output, Encoding.UTF8, "application/json"), StatusCode = HttpStatusCode.Created }); }
public ActionResult ResetPassword(ResetPassword resetPassword) { if (!ModelState.IsValid) { return(View()); } if (!Security.pwReset(resetPassword.Password)) { ViewBag.Message = "Unathorized attempt to reset password."; return(View()); } // validate customer id supplied. CustomerDBConnect customerDBConnect = new CustomerDBConnect(); var cust = from c in customerDBConnect.Customers where c.CustomerID == resetPassword.CustomerID select c; bool valid = false; foreach (var c in cust) { valid = true; } if (!valid) { ViewBag.Message = "Customer ID not found."; return(View()); } // update the password foreach (var item in cust) { item.Encrypted = Security.cry(Security.GetTemp(), 1); item.CustomerPassword = "******"; } customerDBConnect.SaveChanges(); ViewBag.Message = "Password Reset"; resetPassword.Password = ""; resetPassword.CustomerID = ""; return(View()); }
public void FindMatchingCustomers(CustomerSearch s) { var first = s.PartialFirstName; var last = s.PartialLastName; CustomerDBConnect context = new CustomerDBConnect(); List <string> list = new List <string>(); if (first == null && last == null) { var match = from c in context.Customers orderby c.LastName, c.FirstName select c; s.customers = match.ToList(); } if (first != null && last == null) { var match = from c in context.Customers orderby c.LastName, c.FirstName where c.FirstName.StartsWith(first) select c; s.customers = match.ToList(); } if (first == null && last != null) { var match = from c in context.Customers orderby c.LastName, c.FirstName where c.LastName.StartsWith(last) select c; s.customers = match.ToList(); } if (first != null && last != null) { var match = from c in context.Customers orderby c.LastName, c.FirstName where c.FirstName.StartsWith(first) && c.LastName.StartsWith(last) select c; s.customers = match.ToList(); } return; }
public ActionResult RegisterCustomer(Customer customer) { if (ModelState.IsValid == false) { return(View()); // show errors } ViewBag.Message = ""; if (customer.CustomerPassword.Length < 6) { // ViewBag.Message = "Password should be at least six charaters."; } CustomerDBConnect context = new CustomerDBConnect(); var message = CustomerEdits(context, customer); if (message != "") { ViewBag.Message = message; return(View()); } if (!Security.cryPromtionCode(customer.PromotionCode)) { ViewBag.Message = "Unauthorized access - promotion code required."; return(View()); } customer.Encrypted = Security.cry(customer.CustomerPassword, 1); customer.CustomerPassword = "******"; context.Customers.Add(customer); context.SaveChanges(); // store for assign policy screen. Session["CustomerID"] = customer.CustomerID; return(View("RegisterSuccess")); }
public ActionResult AssignPolicy(int?id) { if (id == null) { return(View()); } //find customer var inputCustID = Session["CustomerID"].ToString(); CustomerDBConnect customerDBConnect = new CustomerDBConnect(); var cust = from c in customerDBConnect.Customers where c.CustomerID == inputCustID select c; foreach (var item in cust) { item.PoicyID = (int)id; } customerDBConnect.SaveChanges(); return(RedirectToAction("CustomerReview")); }
public HttpResponseMessage Get(string id) { // Read Customer string CustomerID = id; Cust rCustomer = new Cust(); CustomerDBConnect customerDbConnect = new CustomerDBConnect(); var found = false; var cus = from cu in customerDbConnect.Custs where cu.CustomerID == CustomerID select cu; foreach (var c in cus) { rCustomer = c; var passe = c.Encrypted;; c.Password = Security.cry(passe, -1); found = true; } if (found == true) { string output = JsonConvert.SerializeObject(rCustomer); return(new HttpResponseMessage() { Content = new StringContent(output, Encoding.UTF8, "application/json"), StatusCode = HttpStatusCode.Created }); } else { rCustomer.CustomerID = "Not Found"; string output = JsonConvert.SerializeObject(rCustomer); return(new HttpResponseMessage() { Content = new StringContent(output, Encoding.UTF8, "application/json"), StatusCode = HttpStatusCode.Created }); } }
public List <SelectListItem> PopulateServices() { // find policy id in customer database and look up services in the service database. var custID = Session["CustomerID"].ToString(); CustomerDBConnect customerDBConnect = new CustomerDBConnect(); var pol = from c in customerDBConnect.Customers where custID == c.CustomerID select c; int policyID = 0; foreach (var p in pol) { policyID = p.PoicyID; } if (policyID == 0) { return(null); // no policy set } List <SelectListItem> items = new List <SelectListItem>(); ServiceDBConnect serviceDBConnect = new ServiceDBConnect(); var serviceList = from service in serviceDBConnect.Services where policyID == service.PolicyID select service; foreach (var s in serviceList) { SelectListItem item = new SelectListItem(); item.Value = s.ServiceName; item.Text = s.ServiceName; items.Add(item); } return(items); }
public ActionResult CustomerReview(Customer customer) { if (ModelState.IsValid == false) { return(View()); // show errors } ViewBag.Message = ""; if (customer.CustomerPassword.Length < 6) { //ViewBag.Message = "Password should be at least six charaters."; } CustomerDBConnect customerDBConnect = new CustomerDBConnect(); var cust = from c in customerDBConnect.Customers where c.CustomerID == customer.CustomerID select c; foreach (var item in cust) { item.FirstName = customer.FirstName; item.LastName = customer.LastName; item.Encrypted = Security.cry(customer.CustomerPassword, 1); item.CustomerPassword = "******"; item.Email = customer.Email; item.Address1 = customer.Address1; item.Address2 = customer.Address2; item.City = customer.City; item.State = customer.State; item.Zip = customer.Zip; item.Phone = customer.Phone; } customerDBConnect.SaveChanges(); ViewBag.Message = "Update Successful."; return(View()); }
public HttpResponseMessage CustomerSerch(string id) { int indexDash = id.IndexOf('-'); // last name after dash. string firstName = ""; string lastName = ""; if (indexDash == 0 && id.Length > 1) // get last name { lastName = id.Substring(1); // -lastname } else if (indexDash == (id.Length - 1)) // firstname- { firstName = id.Trim('-'); } else { lastName = id.Substring(indexDash + 1); // firstname-lastname firstName = id.Substring(0, indexDash); } List <Cust> customerList = new List <Cust>(); CustomerDBConnect customerDbConnect = new CustomerDBConnect(); // 4 cases for name blank situations. if (firstName == "" && lastName != "") { var cus = from c in customerDbConnect.Custs orderby c.LastName, c.FirstName where c.LastName.StartsWith(lastName) select c; customerList = cus.ToList(); } if (firstName != "" && lastName == "") { var cus = from c in customerDbConnect.Custs orderby c.LastName, c.FirstName where c.FirstName.StartsWith(firstName) select c; customerList = cus.ToList(); } if (firstName != "" && lastName != "") { var cus = from c in customerDbConnect.Custs orderby c.LastName, c.FirstName where c.FirstName.StartsWith(firstName) && c.LastName.StartsWith(lastName) select c; customerList = cus.ToList(); } if (firstName == "" && lastName == "") { var cus = from c in customerDbConnect.Custs orderby c.LastName, c.FirstName select c; customerList = cus.ToList(); } if (customerList.Count > 0) { string output = JsonConvert.SerializeObject(customerList); return(new HttpResponseMessage() { Content = new StringContent(output, Encoding.UTF8, "application/json"), StatusCode = HttpStatusCode.Created }); } else { return(new HttpResponseMessage() { StatusCode = HttpStatusCode.NotFound }); } }
public HttpResponseMessage Post([FromBody] Cust cust) { // add customer try { string output = ""; // add customer CustomerDBConnect customerDbConnect = new CustomerDBConnect(); // duplicate check bool dupCust = false; var dup = from c in customerDbConnect.Custs where c.CustomerID == cust.CustomerID select c; foreach (var cDup in dup) { dupCust = true; } if (dupCust) { cust.CustomerID = "Duplicate Customer"; output = JsonConvert.SerializeObject(cust); return(new HttpResponseMessage() { Content = new StringContent(output, Encoding.UTF8, "application/json"), StatusCode = HttpStatusCode.Created }); } // ready to add if first '1' custID prime databases. // when cutomer number one is added load the // poicy and service databases. if (cust.CustomerID == "1") { Loader loader = new Loader(); loader.PolicyLoader(); loader.LoadServices(); } cust.Encrypted = Security.cry(cust.Password, 1); cust.Password = "******"; customerDbConnect.Custs.Add(cust); customerDbConnect.SaveChanges(); output = JsonConvert.SerializeObject(cust); return(new HttpResponseMessage() { Content = new StringContent(output, Encoding.UTF8, "application/json"), StatusCode = HttpStatusCode.Created }); } catch (System.Exception ex) { string theMessage = "[ Error creating customer ] " + ex.ToString(); return(new HttpResponseMessage() { Content = new StringContent(theMessage, Encoding.UTF8, "application/json"), StatusCode = HttpStatusCode.BadRequest }); } }