public ActionResult Index(HouseholdViewModel household, string deleteId) { // Check Client data var client = db.Clients.Find(household.ClientId); if (client != null) { client.StreetNumber = household.StreetNumber; client.StreetName = household.StreetName; client.City = household.City; client.Zip = household.Zip; client.Notes = household.Notes; client.Phone = household.Phone; foreach (var member in household.FamilyMembers) { if (member.Id == 0 && member.ClientId == 0) // is Head of Household { client.FirstName = member.FirstName; client.LastName = member.LastName; client.DateOfBirth = DateTime.Today.AddYears(-member.Age); } else if (member.Id == 0 && member.ClientId < 0) //Adding new member (ClientId = -1) { var familyMember = new FamilyMember(); if (member.FirstName != null || member.LastName != null) { familyMember.ClientId = client.Id; familyMember.Active = true; familyMember.Delete = false; familyMember.FirstName = member.FirstName; familyMember.LastName = member.LastName; familyMember.DateOfBirth = DateTime.Today.AddYears(-member.Age); db.FamilyMembers.Add(familyMember); } } else { var familyMember = db.FamilyMembers.Find(member.Id); if (familyMember != null) { familyMember.FirstName = member.FirstName; familyMember.LastName = member.LastName; familyMember.DateOfBirth = DateTime.Today.AddYears(-member.Age); if (member.Delete == true) { db.FamilyMembers.Remove(familyMember); } } } } db.SaveChanges(); return(RedirectToAction("UpdateHousehold", "OD", new { Id = client.Id })); } return(null); }
public ActionResult Create([Bind(Include = "Id,Active,FirstName,LastName,DateOfBirth,StreetNumber,StreetName,City,Zip,Phone,Notes")] Client client) { if (ModelState.IsValid) { db.Clients.Add(client); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(client)); }
public ActionResult Create([Bind(Include = "Id,ClientId,Active,FirstName,LastName,DateOfBirth")] FamilyMember familyMember) { if (ModelState.IsValid) { db.FamilyMembers.Add(familyMember); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(familyMember)); }
public ActionResult Create( [Bind(Include = "Id,ClientId,DeliveryDate,Notes,FullBags,HalfBags,KidSnacks,GiftCards")] Delivery delivery) { if (ModelState.IsValid) { db.Deliveries.Add(delivery); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(delivery)); }
public static Boolean UploadClients() { var db = new BHelpContext(); var filePath = @"c:\TEMP\BH Food Client List-Table 1.csv"; DataTable csvtable = new DataTable(); using (CsvReader csvReader = new CsvReader(new StreamReader(filePath), true)) { csvtable.Load(csvReader); } foreach (DataRow row in csvtable.Rows) { Client client = new Client() { Active = true, LastName = row[0].ToString(), FirstName = row[1].ToString(), StreetNumber = row[2].ToString(), StreetName = row[3].ToString(), City = row[4].ToString(), Zip = row[5].ToString(), Phone = row[6].ToString(), Notes = row[13].ToString() }; db.Clients.Add(client); db.SaveChanges(); //System.Diagnostics.Debug.WriteLine(client.FirstName, client.LastName); } return(true); }
public static Boolean ReverseNames() // Initial load had First & Last Names revesed { var db = new BHelpContext(); foreach (Client client in db.Clients.ToList()) { var oldLastName = client.LastName; client.LastName = client.FirstName; client.FirstName = oldLastName; db.SaveChanges(); } return(true); }
public ActionResult AddDelivery(int clientId) { var userIid = System.Web.HttpContext.Current.User.Identity.GetUserId(); Delivery delivery = new Delivery() { ODId = userIid, ClientId = clientId, DeliveryDate = Convert.ToDateTime(Session["CallLogDate"]) }; db.Deliveries.Add(delivery); db.SaveChanges(); return(RedirectToAction("Index")); }
public static Boolean UploadAdults() { var db = new BHelpContext(); var filePath = @"c:\TEMP\BH Food Client List-Table 1.csv"; DataTable csvtable = new DataTable(); using (CsvReader csvReader = new CsvReader(new StreamReader(filePath), true)) { csvtable.Load(csvReader); } int i = 0; foreach (DataRow row in csvtable.Rows) { i++; // Switch for Kids / Adults: string _adults = row[10].ToString(); // Adults //string _adults = row[11].ToString(); // Kids string[] adultsArray = _adults.Split(','); foreach (var nameAge in adultsArray) { if (i > 0) // to reset if errors occured { if (nameAge.Contains(row[0].ToString()) && nameAge.Contains(row[1].ToString())) // First and Last Name)) { //Don't add to FamilyMembers - just capture the age & update the client DoB int ageIndex = nameAge.IndexOf('/'); if (ageIndex > 0) { var years = nameAge.Substring(nameAge.IndexOf('/') + 1); //System.Diagnostics.Debug.WriteLine(i.ToString() + ' ' + row[0].ToString() + ' ' + row[1].ToString() + ' ' + years); if (int.TryParse(years, out int yy)) { // Everybody born on April 1st DateTime doB = new DateTime(2021 - yy, 4, 1); var original = db.Clients.Find(i); if (original != null) { original.DateOfBirth = doB; db.SaveChanges(); } } } } else // not a client - add a family member ================= { string nameAgeTrim = nameAge.Trim(); var years = nameAge.Substring(nameAge.IndexOf('/') + 1); if (int.TryParse(years, out int yy)) { DateTime doB = new DateTime(2021 - yy, 4, 1); string fullName = nameAgeTrim.Substring(0, nameAgeTrim.IndexOf('/')); string firstName; string lastName; if (fullName.IndexOf(' ') <= 0) { firstName = fullName; lastName = ""; } else { firstName = fullName.Substring(0, fullName.IndexOf(' ')); lastName = fullName.Substring(fullName.IndexOf(' ') + 1); } FamilyMember newAdult = new FamilyMember() { Active = true, ClientId = i, FirstName = firstName, LastName = lastName, DateOfBirth = doB }; db.FamilyMembers.Add(newAdult); db.SaveChanges(); } } } } //System.Diagnostics.Debug.WriteLine(client.FirstName, client.LastName); } return(true); }