public ActionResult Location_Create([DataSourceRequest] DataSourceRequest request, VolunteerLocationModel location) { int id = 0; var session = HttpContext.Session; if (session != null) { if (session["VolunteerId"] != null) { id = int.Parse(session["VolunteerId"].ToString()); } } if (location != null) { Location target = new Location(); if (db.Locations.Where(m => m.locationId == location.locationId).FirstOrDefault() == null) { target.volunteerId = id; target.locationType = location.locationType; target.address = location.address; target.city = location.city; target.province = location.province; target.postalcode = stringToUpperCase(location.postalcode); db.Locations.Add(target); db.SaveChanges(); } } return Json(ModelState.ToDataSourceResult()); }
public ActionResult CreateNewLocationForVolunteer(Location model) { if (model.locationType == "International") { model.address = convertNullToString(model.address); model.city = ""; model.province = ""; model.country = ""; model.postalcode = ""; } else { model.address = convertNullToString(model.address); model.city = stringToTitleCase(convertNullToString(model.city)); model.province = convertNullToString(model.province); model.country = stringToTitleCase(convertNullToString(model.country)); model.postalcode = convertNullToString(model.postalcode).ToUpper(); } db.Locations.Add(model); db.SaveChanges(); return RedirectToAction("Edit/" + model.volunteerId, "Volunteer"); }
private void CreateLocation(VolunteerLocationModel model) { if (model != null) { Location target = new Location(); if (db.Locations.Where(m => m.locationId == model.locationId).FirstOrDefault() == null) { target.volunteerId = model.volunteerId; target.locationType = model.locationType; target.address = model.address; target.city = model.city; target.province = model.province; target.postalcode = stringToUpperCase(model.postalcode); db.Locations.Add(target); db.SaveChanges(); } } }
public void CreateLocationForNewVolunteer(VolunteerLocationModel model) { Location location = new Location(); location.volunteerId = model.volunteerId; location.locationType = model.locationType; if (model.locationType == "International") { location.address = convertNullToString(model.address); location.city = ""; location.province = ""; location.country = ""; location.postalcode = ""; } else { location.address = convertNullToString(model.address); location.city = stringToTitleCase(convertNullToString(model.city)); location.province = convertNullToString(model.province); location.country = stringToTitleCase(convertNullToString(model.country)); location.postalcode = convertNullToString(model.postalcode).ToUpper(); } db.Locations.Add(location); db.SaveChanges(); }
private void InsertOrUpateLocation(SmsCsvModel item) { var v = db.Volunteers.Where(model => model.constituentCode == item.constituentCode); if (v.FirstOrDefault() != null) { Volunteer volunteer = v.FirstOrDefault(); var location = db.Locations.Where(l => l.volunteerId == volunteer.volunteerId && l.locationType == "Canada"); if (location.FirstOrDefault() == null) { // insert into database Location newLocation = new Location(); newLocation.volunteerId = volunteer.volunteerId; //contactId= newLocation.locationType = "Canada"; newLocation.address = convertNullToString(item.address); newLocation.city = convertNullToString(item.city); newLocation.province = convertNullToString(item.province); newLocation.postalcode = convertNullToString(item.postalcode); db.Locations.Add(newLocation); db.SaveChanges(); } else { Location existLocation = location.FirstOrDefault(); existLocation.volunteerId = volunteer.volunteerId; //contactId= existLocation.locationType = "Canada"; existLocation.address = convertNullToString(item.address); existLocation.city = convertNullToString(item.city); existLocation.province = convertNullToString(item.province); existLocation.postalcode = convertNullToString(item.postalcode); db.Entry(existLocation).State = EntityState.Modified; db.SaveChanges(); } } }