// parse data values to correct table prior saving
private void ParseDataHelper(vinsuree_data_all data)
{
try
{
// car_main
_car.car_year = data.car_year.GetValueOrDefault();
_car.car_make = data.car_make;
_car.car_model = data.car_model;
// insuree_main
_main.first_name = data.first_name;
_main.last_name = data.last_name;
_main.create_date = DateTime.Now;
// insuree_info
_info.email = data.email;
_info.dob = data.dob.GetValueOrDefault();
_info.state = ext.ValidateParseStateCode(data.state); // validate
_info.zip = data.zip.GetValueOrDefault();
// insuree_hist
_hist.dui = data.dui;
// TO DO _hist.tickets = data.tickets.GetValueOrDefault();
// insuree_quote
_quote.coverage_type = data.coverage_type;
_quote.curr_quote = data.curr_quote = ext.CalcQuote(data);
// WIP _quote.prev_quote = data.prev_quote;
}
catch (Exception ex) { throw new Exception(ex.Message); }
}
public bool DataUpdate(db_insuranceEntities_ db, [Bind(Exclude = "insuree_key")] vinsuree_data_all data, int key)
{
bool res = false; // default to fail
db.SaveChanges();
return(res);
}
static HomeController()
{
// instantiate data objects
_db = new db_insuranceEntities_();
_vdata = new vinsuree_data_all();
// instantiate controller(s)
_data = new WebAppDataController();
_ext = new WebAppExtController();
}
public bool DataInsert(db_insuranceEntities_ db, vinsuree_data_all data)
{
bool res = true; // default to pass
ParseDataHelper(data);
SetTableValHelper(db);
try { db.SaveChanges(); }
catch (DbEntityValidationException ex) { throw new Exception(ex.Message); }
return(res);
}
public ActionResult Create(vinsuree_data_all rec)
{
bool pass;
pass = _ext.CheckFieldVals(rec); // validate req fields are populated
if (!pass)
{
ViewBag.ErrorMessage = "All fields required for record creation."; return(View("Error"));
}
pass = _data.DataInsert(_db, rec); // insert record to db
if (!pass)
{
ViewBag.ErrorMessage = "Error on record creation at WebAppDataController.DataInsert()"; return(View("Error"));
}
return(View());
}
// validate cshtml fields are populated
public bool CheckFieldVals(vinsuree_data_all data)
{
bool res = true; // default to valid
PropertyInfo[] props = typeof(vinsuree_data_all).GetProperties();
var _props = new List <PropertyInfo>(props);
_props.RemoveRange(13, 2); // remove quote vals
_props.ToArray();
foreach (PropertyInfo prop in _props)
{
object value = prop.GetValue(data, null);
if (value == null)
{
return(res = false);
}
}
return(res);
}
public string CalcQuote(vinsuree_data_all data)
{
decimal quote = 50.00M; // default quote val
// age logic
quote = (DateTime.Now.Year - data.dob.Value.Year > 25) ? quote + 25.00M : quote;
quote = (DateTime.Now.Year - data.dob.Value.Year < 18) ? quote + 25.00M : quote;
quote = (DateTime.Now.Year - data.dob.Value.Year > 100) ? quote + 25.00M : quote;
// automobile logic
quote = (data.car_year < 2000) ? quote + 25.00M : quote;
quote = (data.car_year > 2015) ? quote + 25.00M : quote;
quote = (data.car_make.ToLower() == "porsche") ? quote + 25.00M : quote;
quote = (data.car_make.ToLower() == "porsche" && data.car_model.Contains("carrera")) ? quote + 25.00M : quote;
// risk logic
//TO DO quote = (data.tickets > 4) ? quote + (data.tickets * 10).Value : quote;
//TO DO quote = (data.dui > 0) ? quote + (Decimal.Multiply(quote, .25M)): quote;
quote = (data.coverage_type.ToLower() == "full") ? quote + (Decimal.Multiply(quote, .25M)) : quote;
return(quote.ToString());
}
public bool DataDelete(db_insuranceEntities_ db, vinsuree_data_all data, int key)
{
bool res = false; // default to fail
return(res);
}
public bool DataSelect(db_insuranceEntities_ db, vinsuree_data_all data, int key) // single record select
{
bool res = false; // default to fail
return(res);
}
public bool DataSelect(db_insuranceEntities_ db, vinsuree_data_all data) // load all applicable records
{
bool res = false; // default to fail
return(res);
}
