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