コード例 #1
0
        // GET: Admin
        public ActionResult Admin()
        {
            using (InsuranceEntities db = new InsuranceEntities())
            {
                var insurees   = (from x in db.Insurees select x).ToList();
                var insureeVms = new List <InsureeVm>();
                foreach (var insuree in insurees)
                {
                    var insureeVm = new InsureeVm();
                    insureeVm.Id           = insuree.Id;
                    insureeVm.FirstName    = insuree.FirstName;
                    insureeVm.LastName     = insuree.LastName;
                    insureeVm.EmailAddress = insuree.EmailAddress;
                    insureeVm.Quote        = insuree.Quote;
                }

                return(View(insureeVms));
            }
        }
コード例 #2
0
        // GET: Admin
        public ActionResult Index()
        {
            using (Insurance_5Entities db = new Insurance_5Entities())
            {
                //var signups = db.SignUps.Where(x => x.Removed == null).ToList();
                // var signups = (from c in db.SignUps where c.Removed == null select c).ToList();
                var insures = db.Insurees;

                var InsureVms = new List <InsureeVm>();
                foreach (var insur in insures)
                {
                    var insureVm = new InsureeVm();
                    insureVm.Id           = insur.Id;
                    insureVm.FirstName    = insur.FirstName;
                    insureVm.LastName     = insur.LastName;
                    insureVm.EmailAddress = insur.EmailAddress;
                    insureVm.Quote        = insur.Quote;
                    InsureVms.Add(insureVm);
                }
                return(View(InsureVms));
            }
        }
コード例 #3
0
        // GET: Admin
        public ActionResult Index()
        {
            using (InsuranceEntities db = new InsuranceEntities())
            {
                var insurees = db.Tables.Where(x => x.Removed == null).ToList();

                //ViewModel
                var insureeVms = new List <InsureeVm>();
                foreach (var insuree in insurees)
                {
                    var insureeVm = new InsureeVm();
                    insureeVm.Id           = insuree.Id;
                    insureeVm.Quote        = insuree.Quote;
                    insureeVm.FirstName    = insuree.FirstName;
                    insureeVm.LastName     = insuree.LastName;
                    insureeVm.EmailAddress = insuree.EmailAddress;
                    insureeVms.Add(insureeVm);
                }

                return(View(insureeVms));
            }
        }
コード例 #4
0
        // GET: Admin
        public ActionResult Index()
        {
            using (InsuranceEntities db = new InsuranceEntities())
            {
                // setting up access to database list
                var insurees = db.Tables.ToList();

                // empty list to add all info into later and then return to vies
                var insureeVms = new List <InsureeVm>();

                // for each loop
                foreach (var insuree in insurees)
                {
                    insuree.Quote = 50;
                    var insureeVm = new InsureeVm();

                    // checking insuree age. if 18 or below, goes through first if, if 19-25, goes through else if, all others goes through final else
                    var insureeAge = (insuree.DateOfBirth - DateTime.Now).TotalDays / 365;
                    if (insureeAge < 19)
                    {
                        insuree.Quote += 100;
                    }
                    else if (insureeAge >= 19 && insureeAge < 26)
                    {
                        insuree.Quote += 50;
                    }
                    else
                    {
                        insuree.Quote += 25;
                    }

                    // checks if car year is below 200 or above 2015
                    if (insuree.CarYear < 2000 || insuree.CarYear > 2015)
                    {
                        insuree.Quote += 25;
                    }

                    //checks car make and model for porsche and carerra
                    if (insuree.CarMake == "Porsche" && insuree.CarModel == "911 Carerra")
                    {
                        insuree.Quote += 50;
                    }
                    else if (insuree.CarMake == "Porsche")
                    {
                        insuree.Quote += 25;
                    }

                    // checks if speedingtickets are greater than zero, then adds 10 times how many tickets to the quote total
                    if (insuree.SpeedingTickets > 0)
                    {
                        insuree.Quote += 10 * insuree.SpeedingTickets;
                    }

                    //if user had DUI, multiplies quote value and sets it to that
                    if (insuree.DUI == true)
                    {
                        insuree.Quote *= (Decimal)1.25;
                    }

                    // if user selects full coverage, adds 50% to total
                    if (insuree.CoverageType == true)
                    {
                        insuree.Quote *= (Decimal)1.5;
                    }

                    insureeVm.FirstName    = insuree.FirstName;
                    insureeVm.LastName     = insuree.LastName;
                    insureeVm.EmailAddress = insuree.EmailAddress;
                    insureeVm.Quote        = insuree.Quote;
                    insureeVms.Add(insureeVm);
                }
                return(View(insureeVms));
            }
        }