public ActionResult Create(int orgID) { try { OrganisationAddressModel editModel = new OrganisationAddressModel(); sw.Organisation member = swdb.Organisation.Where(x => x.Id == orgID).FirstOrDefault(); if (member == null) { return(HttpNotFound()); } sw.AddressBook memberBeneficiary = new sw.AddressBook() { OrgID = member.Id }; editModel.org = member; editModel.addressBook = memberBeneficiary; editModel.addressType = new SelectList(swdb.AddressType, "ID", "Name").ToList(); return(View(editModel)); } catch (Exception ex) { // Log with Elmah Elmah.ErrorSignal.FromCurrentContext().Raise(ex); TempData["message"] = Settings.Default.GenericExceptionMessage; return(RedirectToAction("Index", new { orgID = orgID })); } }
public ActionResult Edit(OrganisationAddressModel editModel) { sw.AddressBook memberBeneficiary = editModel.addressBook; try { if (ModelState.IsValid) { memberBeneficiary.ModifiedBy = User.Identity.Name; memberBeneficiary.ModifedDate = DateTime.Now; swdb.AddressBook.Attach(memberBeneficiary); swdb.Entry(memberBeneficiary).State = EntityState.Modified; //swdb.ObjectStateManager.ChangeObjectState(memberBeneficiary, EntityState.Modified); swdb.SaveChanges(); TempData["message"] = "<b>" + memberBeneficiary.City + "</b> was Successfully Updated"; return(RedirectToAction("Index", new { orgID = memberBeneficiary.OrgID })); } editModel.addressType = new SelectList(swdb.AddressType, "ID", "Name", memberBeneficiary.AddressTypeId).ToList(); return(View(editModel)); } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); TempData["message"] = Settings.Default.GenericExceptionMessage; return(RedirectToAction("Index", new { orgID = memberBeneficiary.OrgID })); } }
public ActionResult Create(OrganisationAddressModel editModel) { sw.AddressBook memberBeneficiary = editModel.addressBook; try { if (ModelState.IsValid) { memberBeneficiary.ModifiedBy = User.Identity.Name; memberBeneficiary.ModifedDate = DateTime.Now; swdb.AddressBook.Add(memberBeneficiary); swdb.SaveChanges(); TempData["message"] = "<b>" + memberBeneficiary.Street + "</b> was Successfully Saved"; return(RedirectToAction("Index", new { orgID = memberBeneficiary.OrgID })); } sw.Organisation member = swdb.Organisation.Where(x => x.Id == editModel.addressBook.OrgID).FirstOrDefault(); editModel.org = member; editModel.addressType = new SelectList(swdb.AddressType, "ID", "Name").ToList(); return(View(editModel)); } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); TempData["message"] = Settings.Default.GenericExceptionMessage; return(RedirectToAction("Index", new { orgID = memberBeneficiary.OrgID })); } }
public ActionResult Index([DefaultValue(1)] int page, string keywords, [DefaultValue(12)] int pgsize, int orgID) { try { //var organisation = db.Organisation.Include("OrganisationType"); //return View(organisation.ToList()); sw.Organisation member = swdb.Organisation.Where(x => x.Id == orgID).FirstOrDefault(); if (member == null) { TempData["message"] = Settings.Default.GenericExceptionMessage; return(RedirectToAction("Index", "Home")); } List <sw.AddressBook> rowsToShow = new List <sw.AddressBook>(); int totalRecords = 0; if (!string.IsNullOrEmpty(keywords)) { rowsToShow = swdb.AddressBook.Where(x => x.OrgID == orgID && (x.City.ToUpper().Contains(keywords.Trim().ToUpper()) || x.Street.ToUpper().Contains(keywords.Trim().ToUpper()))).OrderBy(x => x.Id).Skip((page - 1) * pgsize).Take(pgsize).ToList(); totalRecords = swdb.AddressBook.Where(x => x.OrgID == orgID && (x.City.ToUpper().Contains(keywords.Trim().ToUpper()) || x.Street.ToUpper().Contains(keywords.Trim().ToUpper()))).Count(); } else { rowsToShow = swdb.AddressBook.Where(x => x.OrgID == orgID).OrderBy(x => x.Id).Skip((page - 1) * pgsize).Take(pgsize).ToList(); totalRecords = swdb.AddressBook.Where(x => x.OrgID == orgID).Count(); } OrganisationAddressModel model = new OrganisationAddressModel() { Rows = rowsToShow, org = member, PagingInfo = new PagingInfo { FirstItem = ((page - 1) * pgsize) + 1, LastItem = page * pgsize, CurrentPage = page, ItemsPerPage = pgsize, TotalItems = totalRecords }, CurrentKeywords = keywords, PageSize = pgsize }; return(View(model)); } catch (Exception ex) { // Log with Elmah Elmah.ErrorSignal.FromCurrentContext().Raise(ex); TempData["message"] = Settings.Default.GenericExceptionMessage; return(RedirectToAction("Index", "Home", new { area = "Admin" })); } }