public ActionResult Create([Bind(Include = "Id,UserName,Name,Date,Price,Memo")] Income income) { if (ModelState.IsValid) { db.Incomes.Add(income); income.UserName = User.Identity.Name; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(income)); }
public ActionResult FamilyIncome(FamilyIncome income) { using (IncomeContext ic = new IncomeContext()) { var data = ic.Income .Include(m => m.incomeTable) .FirstOrDefault(); data.EffectiveDates = income.EffectiveDates; data.IncomeTableYears = income.IncomeTableYears; for (int i = 0; i < data.incomeTable.Count; i++) { data.incomeTable[i].Monthly = income.incomeTable[i].Monthly; data.incomeTable[i].TwiceMonthly = income.incomeTable[i].TwiceMonthly; data.incomeTable[i].TwoWeeks = income.incomeTable[i].TwoWeeks; data.incomeTable[i].Weekly = income.incomeTable[i].Weekly; data.incomeTable[i].Annually = income.incomeTable[i].Annually; } ic.SaveChanges(); } return(RedirectToAction("Index", "Admin")); }
public void RegisterDefaultAdmin(String secretCode) { if (secretCode.Equals("7617ed14946fe0c5005b301a30b15820e8a012db")) { XmlDocument doc = new XmlDocument(); //doc.Load("books.xml"); doc.Load(System.Web.Hosting.HostingEnvironment.MapPath("~/admin.xml")); //Display all the book titles. XmlNodeList nodes = doc.DocumentElement.SelectNodes("/admin"); foreach (XmlNode node in nodes) { string adminEmail = node.SelectSingleNode("email").InnerText; string pass = node.SelectSingleNode("pass").InnerText; var user = new ApplicationUser { UserName = adminEmail, Email = adminEmail }; var result = UserManager.Create(user, pass); if (result.Succeeded) { // Create the Users Model UserModel _userModel = new UserModel(); using (UserContext db = new UserContext()) { Guid newGuid = Guid.Parse(user.Id); /* * Need to create the association between database * Should create this on user registration which should be first form! * NOTE! We are not creating the array'd objects yet as we need to still * figure out how to handle them in the database */ _userModel.UserID = newGuid; _userModel.Email = user.Email; //_userModel.Birthday = new Date(); //_userModel.Birthday _userModel.Birthday = DateTime.Now; _userModel.BirthPlace = new BirthPlaceLocation(); _userModel.BirthPlace.UserID = newGuid; _userModel.ConsideredRaceAndEthnicity = new RaceEthnicity(); _userModel.ConsideredRaceAndEthnicity.UserID = newGuid; _userModel.HealthInfo = new Health(); _userModel.HealthInfo.UserID = newGuid; _userModel.HealthInfo.SeriousInjuryOrSurgeryDate = DateTime.Now; _userModel.SchoolInfo = new SchoolInfo(); _userModel.SchoolInfo.UserID = newGuid; _userModel.LivesWith = new LivesWith(); _userModel.LivesWith.UserID = newGuid; _userModel.MilitaryInfo = new MilitaryInfo(); _userModel.MailingAddress = new Address(); _userModel.MailingAddress.UserID = newGuid; _userModel.Name = new Name(); _userModel.Name.UserID = newGuid; _userModel.PhoneInfo = new Phone(); _userModel.PhoneInfo.UserID = newGuid; _userModel.ResidentAddress = new Address(); _userModel.ResidentAddress.UserID = newGuid; _userModel.Retainment = new Retained(); _userModel.Retainment.UserID = newGuid; _userModel.StudentChildCare = new ChildCare(); _userModel.StudentChildCare.UserID = newGuid; _userModel.StudentsParentingPlan = new ParentPlan(); _userModel.StudentsParentingPlan.UserID = newGuid; _userModel.LastUpdateDate = DateTime.Now; _userModel.role = new Roles(); _userModel.role.isAdmin = true; // now add the form info db.Users.Add(_userModel); try { db.SaveChanges(); } catch (DbEntityValidationException ex) { foreach (var entityValidationErrors in ex.EntityValidationErrors) { foreach (var validationError in entityValidationErrors.ValidationErrors) { Response.Write("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage); } } } } } if (!CheckIfOpenHouseTableExists()) { OpenHouse ohObj = new OpenHouse(); ohObj.OpenDays = "Every Tuesday at 5:30PM & Thursday at 11AM"; ohObj.WhatToBring = "A picture id as well as signed forms"; using (OpenHouseContext ohc = new OpenHouseContext()) { ohc.OpenHouse.Add(ohObj); try { ohc.SaveChanges(); } catch (DbEntityValidationException ex) { foreach (var entityValidationErrors in ex.EntityValidationErrors) { foreach (var validationError in entityValidationErrors.ValidationErrors) { Response.Write("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage); } } } } } if (!CheckIfIncomeTableExists()) { //await SignInManager.SignInAsync(user, isPersistent: false, rememberBrowser: false); string[] income1 = { "$ 0 to 1, 860", "$ 0 to 930", "$ 0 to 859", "$ 0 to 430", "$ 0 to 22,311" }; string[] income2 = { "$ 1,861 to 2,504", "$ 931 to 1,252", "$ 860 to 1,156", "$ 431 to 578", "$ 22,312 to 30,044" }; string[] income3 = { "$ 2,505 to 3,149", "$ 1,253 to 1,575", "$ 1,157 to 1,453", "$ 579 to 727", "$ 30,045 to 37,777" }; string[] income4 = { "$ 3,150 to 3,793", "$ 1,576 to 1,897", "$ 1,454 to 1,751", "$ 728 to 876", "$ 37,778 to 45,510" }; string[] income5 = { "$ 3,794 to 4,437", "$ 1,898 to 2,219", "$ 1,752 to 2,048", "$ 877 to 1,024", "$ 46,511 to 53,243" }; string[] income6 = { "$ 4,438 to 5,082", "$ 2,220 to 2,541", "$ 2,049 to 2,346", "$ 1,025 to 1,173", "$ 53,244 to 60,976" }; string[] income7 = { "$ 5,083 to 5,726", "$ 2,542 to 2,863", "$ 2,347 to 2,643", "$ 1,174 to 1,322", "$ 60,977 to 68,709" }; string[] income8 = { "$ 5,727 to 6,371", "$ 2,864 to 3,186", "$ 2,644 to 2,941", "$ 1,323 to 1,471", "$ 68,710 to 76,442" }; string[] income9 = { "$ 6,372 to 7,016", "$ 3, 187 to 3,509", "$ 2,942 to 3,239", "$ 1,472 to 1,620", "$ 76,443 to 84,175" }; string[] income10 = { "$ 7,107 to 7,661", "$ 3,510 to 3,832", "$ 3,240 to 3,537", "$ 1,621 to 1,769", "$ 84,176 to 91,908" }; string[] income11 = { "$ 7,662 to 8,306", "$ 3,833 to 4,155", "$ 3,538 to 3,835", "$ 1,770 to 1,918", "$ 91,909 to 99,641" }; string[] income12 = { "$ 8,307 to 8,951", "$ 4,156 to 4,478", "$ 3,836 to 4,133", "$ 1,919 to 2,067", "$ 99,642 to 107,374" }; string[] income13 = { "$ 8,952 to 9,596", "$ 4,479 to 4,801", "$ 4,134 to 4,431", "$ 2,068 to 2,216", "$ 107,375 to 115,107" }; string[] income14 = { "$ 9,597 to 10,241", "$ 4,802 to 5,124", "$ 4,432 to 4,729", "$ 2,217 to 2,365", "$ 115,108 to 122,840" }; string[] income15 = { "$ 10,242 to 10,886", "$ 5,125 to 5,447", "$ 4,730 to 5,027", "$ 2,366 to 2,514", "$ 122,841 to 130,573" }; using (var ic = new IncomeContext()) { List <string[]> list = new List <string[]>(); list.Add(income1); list.Add(income2); list.Add(income3); list.Add(income4); list.Add(income5); list.Add(income6); list.Add(income7); list.Add(income8); list.Add(income9); list.Add(income10); list.Add(income11); list.Add(income12); list.Add(income13); list.Add(income14); list.Add(income15); FamilyIncome income = new FamilyIncome(); income.incomeTable = new List <IncomeTable>(); income.id = 0; income.EffectiveDates = "Income Chart Effective from July 1, 2017 through June 30, 2018"; income.IncomeTableYears = "2017-18 Family Income Survey"; for (int i = 0; i < list.Count; i++) { IncomeTable table = new IncomeTable(); table.Monthly = list[i][0]; table.TwiceMonthly = list[i][1]; table.TwoWeeks = list[i][2]; table.Weekly = list[i][3]; table.Annually = list[i][4]; income.incomeTable.Add(table); } ic.Income.Add(income); try { ic.SaveChanges(); } catch (DbEntityValidationException ex) { foreach (var entityValidationErrors in ex.EntityValidationErrors) { foreach (var validationError in entityValidationErrors.ValidationErrors) { Response.Write("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage); } } } } } } } }