public ActionResult DeleteConfirmed(int id) { NGODetail nGODetail = db.NGODetails.Find(id); db.NGODetails.Remove(nGODetail); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Create([Bind(Include = "UserName,Password,SecurityQuestionID,SecurityAnswer,FirstName,Description,WebSiteURL,PhoneNumber,ContactNumber1,ContactPersonName," + "EmailAddress,Address1,Address2,Landmark,LocationId,CityId,Zipcode,StateId,CountryId")] NGORegistration nGORegisration) { if (ModelState.IsValid) { DonateForGood.Models.User user = new Models.User { FirstName = nGORegisration.FirstName, LastName = nGORegisration.FirstName, UserName = nGORegisration.UserName, UserTypeId = 2, Password = nGORegisration.Password, SecurityQuestionID = nGORegisration.SecurityQuestionID, SecurityAnswer = nGORegisration.SecurityAnswer, PhoneNumber = nGORegisration.PhoneNumber, EmailAddress = nGORegisration.EmailAddress }; db.Users.Add(user); db.SaveChanges(); int userId = (from tableUser in db.Users where tableUser.FirstName == user.FirstName select tableUser.UserId).First(); NGODetail ngoDetails = new NGODetail { UserId = userId, Description = nGORegisration.Description, WebSiteURL = nGORegisration.WebSiteURL, ContactNumber1 = nGORegisration.ContactNumber1, ContactPersonName = nGORegisration.ContactPersonName, Address1 = nGORegisration.Address1, Address2 = nGORegisration.Address2, Landmark = nGORegisration.Landmark, LocationId = nGORegisration.LocationId, CityId = nGORegisration.CityId, Zipcode = nGORegisration.Zipcode, StateId = nGORegisration.StateId, CountryId = nGORegisration.CountryId }; db.NGODetails.Add(ngoDetails); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CityId = new SelectList(db.Cities, "CityId", "CityName", nGORegisration.CityId); ViewBag.CountryId = new SelectList(db.Countries, "CountryId", "CountryName", nGORegisration.CountryId); ViewBag.LocationId = new SelectList(db.Locations, "LocationId", "LocationName", nGORegisration.LocationId); ViewBag.StateId = new SelectList(db.States, "StateId", "StateName", nGORegisration.StateId); return(View(nGORegisration)); }
// GET: NGODetails/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } NGODetail nGODetail = db.NGODetails.Find(id); if (nGODetail == null) { return(HttpNotFound()); } return(View(nGODetail)); }
public ActionResult Edit([Bind(Include = "UserId,Description,WebSiteURL,ContactNumber1,ContactNumber2,Photo,ContactPersonName,Address1,Address2,CityId,LocationId,StateId,CountryId,Zipcode,Landmark")] NGODetail nGODetail) { if (ModelState.IsValid) { db.Entry(nGODetail).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CityId = new SelectList(db.Cities, "CityId", "CityName", nGODetail.CityId); ViewBag.CountryId = new SelectList(db.Countries, "CountryId", "CountryName", nGODetail.CountryId); ViewBag.LocationId = new SelectList(db.Locations, "LocationId", "LocationName", nGODetail.LocationId); ViewBag.StateId = new SelectList(db.States, "StateId", "StateName", nGODetail.StateId); ViewBag.UserId = new SelectList(db.Users, "UserId", "FirstName", nGODetail.UserId); return(View(nGODetail)); }
// GET: NGODetails/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } NGODetail nGODetail = db.NGODetails.Find(id); if (nGODetail == null) { return(HttpNotFound()); } ViewBag.CityId = new SelectList(db.Cities, "CityId", "CityName", nGODetail.CityId); ViewBag.CountryId = new SelectList(db.Countries, "CountryId", "CountryName", nGODetail.CountryId); ViewBag.LocationId = new SelectList(db.Locations, "LocationId", "LocationName", nGODetail.LocationId); ViewBag.StateId = new SelectList(db.States, "StateId", "StateName", nGODetail.StateId); ViewBag.UserId = new SelectList(db.Users, "UserId", "FirstName", nGODetail.UserId); return(View(nGODetail)); }
// GET: NGODetails/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } NGODetail nGODetail = db.NGODetails.Find(id); // get NGO Detail var getNGODetail = (from tableUser in db.Users join tableNgoList in db.NGODetails on tableUser.UserId equals tableNgoList.UserId where tableUser.UserId == (int)id select new NGORegistration() { UserId = tableUser.UserId, Description = tableNgoList.Description, WebSiteURL = tableNgoList.WebSiteURL, ContactNumber1 = tableNgoList.ContactNumber1, Photo = tableNgoList.Photo, ContactPersonName = tableNgoList.ContactPersonName, Address1 = tableNgoList.Address1, Address2 = tableNgoList.Address2, CityName = tableNgoList.City.CityName, CountryName = tableNgoList.Country.CountryName, StateName = tableNgoList.State.StateName, LocationName = tableNgoList.Location.LocationName, Zipcode = tableNgoList.Zipcode, Landmark = tableNgoList.Landmark, UserTypeId = tableUser.UserTypeId, FirstName = tableUser.FirstName, LastName = tableUser.LastName, PhoneNumber = tableUser.PhoneNumber, EmailAddress = tableUser.EmailAddress }).ToList(); if (getNGODetail == null) { return(HttpNotFound()); } return(View(getNGODetail.ToList())); }