public ActionResult Create(CustomerNOKModel nokmodel, bool continueEditing) { //if (!_permissionService.Authorize(StandardPermissionProvider.ManageStores)) // return AccessDeniedView(); if (!User.Identity.IsAuthenticated) { return(AccessDeniedView()); } var identity = ((CustomPrincipal)User).CustomIdentity; if (ModelState.IsValid) { CDMA_INDIVIDUAL_NEXT_OF_KIN nok = new CDMA_INDIVIDUAL_NEXT_OF_KIN { }; _db.CDMA_INDIVIDUAL_NEXT_OF_KIN.Add(nok); _db.SaveChanges(); //_localizationService.GetResource("Admin.Configuration.Stores.Added") SuccessNotification("New NOK has been Added"); //do activity log return(continueEditing ? RedirectToAction("Edit", new { id = nokmodel.CUSTOMER_NO }) : RedirectToAction("Index")); //return RedirectToAction("Index"); } PrepareModel(nokmodel); return(View(nokmodel)); }
public ActionResult DeleteConfirmed(string id) { CDMA_INDIVIDUAL_NEXT_OF_KIN cDMA_INDIVIDUAL_NEXT_OF_KIN = _db.CDMA_INDIVIDUAL_NEXT_OF_KIN.Find(id); _db.CDMA_INDIVIDUAL_NEXT_OF_KIN.Remove(cDMA_INDIVIDUAL_NEXT_OF_KIN); _db.SaveChanges(); return(RedirectToAction("Index")); }
// GET: CustNok/Delete/5 public ActionResult Delete(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CDMA_INDIVIDUAL_NEXT_OF_KIN cDMA_INDIVIDUAL_NEXT_OF_KIN = _db.CDMA_INDIVIDUAL_NEXT_OF_KIN.Find(id); if (cDMA_INDIVIDUAL_NEXT_OF_KIN == null) { return(HttpNotFound()); } return(View(cDMA_INDIVIDUAL_NEXT_OF_KIN)); }
public ActionResult Edit_Scaffold([Bind(Include = "CUSTOMER_NO,TITLE,SURNAME,FIRST_NAME,OTHER_NAME,DATE_OF_BIRTH,SEX,RELATIONSHIP,OFFICE_NO,MOBILE_NO,EMAIL_ADDRESS,HOUSE_NUMBER,IDENTIFICATION_TYPE,ID_EXPIRY_DATE,ID_ISSUE_DATE,RESIDENT_PERMIT_NUMBER,PLACE_OF_ISSUANCE,STREET_NAME,NEAREST_BUS_STOP_LANDMARK,CITY_TOWN,LGA,ZIP_POSTAL_CODE,STATE,COUNTRY,CREATED_DATE,CREATED_BY,LAST_MODIFIED_DATE,LAST_MODIFIED_BY,AUTHORISED,AUTHORISED_BY,AUTHORISED_DATE,IP_ADDRESS,BRANCH_CODE")] CDMA_INDIVIDUAL_NEXT_OF_KIN cDMA_INDIVIDUAL_NEXT_OF_KIN) { if (ModelState.IsValid) { _db.Entry(cDMA_INDIVIDUAL_NEXT_OF_KIN).State = EntityState.Modified; _db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.LGA = new SelectList(_db.SRC_CDMA_LGA, "LGA_ID", "LGA_NAME", cDMA_INDIVIDUAL_NEXT_OF_KIN.LGA); ViewBag.RELATIONSHIP = new SelectList(_db.CDMA_CUST_REL_TYPE, "REL_CODE", "REL_DESC", cDMA_INDIVIDUAL_NEXT_OF_KIN.RELATIONSHIP); ViewBag.STATE = new SelectList(_db.SRC_CDMA_STATE, "STATE_ID", "STATE_NAME", cDMA_INDIVIDUAL_NEXT_OF_KIN.STATE); ViewBag.TITLE = new SelectList(_db.CDMA_CUST_TITLE, "TITLE_CODE", "TITLE_DESC", cDMA_INDIVIDUAL_NEXT_OF_KIN.TITLE); return(View(cDMA_INDIVIDUAL_NEXT_OF_KIN)); }
// GET: CustNok/Edit/5 public ActionResult Edit_(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CDMA_INDIVIDUAL_NEXT_OF_KIN cDMA_INDIVIDUAL_NEXT_OF_KIN = _db.CDMA_INDIVIDUAL_NEXT_OF_KIN.Find(id); if (cDMA_INDIVIDUAL_NEXT_OF_KIN == null) { return(HttpNotFound()); } ViewBag.LGA = new SelectList(_db.SRC_CDMA_LGA, "LGA_ID", "LGA_NAME", cDMA_INDIVIDUAL_NEXT_OF_KIN.LGA); ViewBag.RELATIONSHIP = new SelectList(_db.CDMA_CUST_REL_TYPE, "REL_CODE", "REL_DESC", cDMA_INDIVIDUAL_NEXT_OF_KIN.RELATIONSHIP); ViewBag.STATE = new SelectList(_db.SRC_CDMA_STATE, "STATE_ID", "STATE_NAME", cDMA_INDIVIDUAL_NEXT_OF_KIN.STATE); ViewBag.TITLE = new SelectList(_db.CDMA_CUST_TITLE, "TITLE_CODE", "TITLE_DESC", cDMA_INDIVIDUAL_NEXT_OF_KIN.TITLE); return(View(cDMA_INDIVIDUAL_NEXT_OF_KIN)); }
public ActionResult Edit(CustomerNOKModel nokmodel, bool continueEditing) { if (!User.Identity.IsAuthenticated) { return(AccessDeniedView()); } var identity = ((CustomPrincipal)User).CustomIdentity; bool updateFlag = false; if (ModelState.IsValid) { CDMA_INDIVIDUAL_NEXT_OF_KIN originalObject = new CDMA_INDIVIDUAL_NEXT_OF_KIN(); using (var db = new AppDbContext()) { int records = db.CDMA_INDIVIDUAL_NEXT_OF_KIN.Count(o => o.CUSTOMER_NO == nokmodel.CUSTOMER_NO); // && o.AUTHORISED == "U" && o.LAST_MODIFIED_BY == identity.ProfileId.ToString() //if there are more than one records, the 'U' one is the edited one if (records > 1) { updateFlag = true; originalObject = _db.CDMA_INDIVIDUAL_NEXT_OF_KIN.Where(o => o.CUSTOMER_NO == nokmodel.CUSTOMER_NO && o.AUTHORISED == "U").FirstOrDefault(); var entity = db.CDMA_INDIVIDUAL_NEXT_OF_KIN.FirstOrDefault(o => o.CUSTOMER_NO == nokmodel.CUSTOMER_NO && o.AUTHORISED == "U"); if (entity != null) { entity.TITLE = nokmodel.TITLE; entity.SURNAME = nokmodel.SURNAME; entity.FIRST_NAME = nokmodel.FIRST_NAME; entity.OTHER_NAME = nokmodel.OTHER_NAME; entity.DATE_OF_BIRTH = nokmodel.DATE_OF_BIRTH; entity.SEX = nokmodel.SEX; entity.RELATIONSHIP = nokmodel.RELATIONSHIP; entity.EMAIL_ADDRESS = nokmodel.EMAIL_ADDRESS; entity.NEXT_OF_KIN_RESIDENTIALSTREET = nokmodel.NEXT_OF_KIN_RESIDENTIALSTREET; entity.NOK_ADDRESS_NO = nokmodel.NOK_ADDRESS_NO; entity.CITY_TOWN = nokmodel.CITY_TOWN; entity.LGA = nokmodel.LGA; entity.NEAREST_BUS_STOP_LANDMARK = nokmodel.NEAREST_BUS_STOP_LANDMARK; entity.STATE = nokmodel.STATE; entity.NEXT_OF_KIN_PHONE_NUMBER = nokmodel.NEXT_OF_KIN_PHONE_NUMBER; entity.NEXT_OF_KIN_PHONE_NUMBER2 = nokmodel.NEXT_OF_KIN_PHONE_NUMBER2; entity.BRANCH_CODE = nokmodel.BRANCH_CODE; entity.QUEUE_STATUS = 1; entity.LAST_MODIFIED_BY = identity.ProfileId.ToString(); entity.LAST_MODIFIED_DATE = DateTime.Now; //entity.AUTHORISED = "U"; db.CDMA_INDIVIDUAL_NEXT_OF_KIN.Attach(entity); db.Entry(entity).State = EntityState.Modified; db.SaveChanges(identity.ProfileId.ToString(), nokmodel.CUSTOMER_NO, updateFlag, originalObject); _messageService.LogEmailJob(identity.ProfileId, entity.CUSTOMER_NO, MessageJobEnum.MailType.Change); } } else if (records == 1) { updateFlag = false; var entity = db.CDMA_INDIVIDUAL_NEXT_OF_KIN.FirstOrDefault(o => o.CUSTOMER_NO == nokmodel.CUSTOMER_NO && o.AUTHORISED == "A"); originalObject = _db.CDMA_INDIVIDUAL_NEXT_OF_KIN.Where(o => o.CUSTOMER_NO == nokmodel.CUSTOMER_NO && o.AUTHORISED == "A").FirstOrDefault(); if (originalObject != null) { entity.TITLE = nokmodel.TITLE; entity.SURNAME = nokmodel.SURNAME; entity.FIRST_NAME = nokmodel.FIRST_NAME; entity.OTHER_NAME = nokmodel.OTHER_NAME; entity.DATE_OF_BIRTH = nokmodel.DATE_OF_BIRTH; entity.SEX = nokmodel.SEX; entity.RELATIONSHIP = nokmodel.RELATIONSHIP; entity.EMAIL_ADDRESS = nokmodel.EMAIL_ADDRESS; entity.NEXT_OF_KIN_RESIDENTIALSTREET = nokmodel.NEXT_OF_KIN_RESIDENTIALSTREET; entity.NOK_ADDRESS_NO = nokmodel.NOK_ADDRESS_NO; entity.CITY_TOWN = nokmodel.CITY_TOWN; entity.LGA = nokmodel.LGA; entity.NEAREST_BUS_STOP_LANDMARK = nokmodel.NEAREST_BUS_STOP_LANDMARK; entity.STATE = nokmodel.STATE; entity.NEXT_OF_KIN_PHONE_NUMBER = nokmodel.NEXT_OF_KIN_PHONE_NUMBER; entity.NEXT_OF_KIN_PHONE_NUMBER2 = nokmodel.NEXT_OF_KIN_PHONE_NUMBER2; entity.BRANCH_CODE = nokmodel.BRANCH_CODE; entity.QUEUE_STATUS = 1; entity.LAST_MODIFIED_BY = identity.ProfileId.ToString(); entity.LAST_MODIFIED_DATE = DateTime.Now; entity.NEAREST_BUS_STOP_LANDMARK = nokmodel.NEAREST_BUS_STOP_LANDMARK; //entity.AUTHORISED = "U"; // db.CDMA_INDIVIDUAL_NEXT_OF_KIN.Attach(entity); db.Entry(entity).State = EntityState.Modified; db.SaveChanges(identity.ProfileId.ToString(), nokmodel.CUSTOMER_NO, updateFlag, originalObject); //track the audit // There is no 'U' status row in the table so, Add new record with mnt_status U //entity.AUTHORISED = "U"; var newentity = new CDMA_INDIVIDUAL_NEXT_OF_KIN(); newentity.TITLE = nokmodel.TITLE; newentity.SURNAME = nokmodel.SURNAME; newentity.FIRST_NAME = nokmodel.FIRST_NAME; newentity.OTHER_NAME = nokmodel.OTHER_NAME; newentity.DATE_OF_BIRTH = nokmodel.DATE_OF_BIRTH; newentity.SEX = nokmodel.SEX; newentity.RELATIONSHIP = nokmodel.RELATIONSHIP; newentity.EMAIL_ADDRESS = nokmodel.EMAIL_ADDRESS; newentity.NEXT_OF_KIN_RESIDENTIALSTREET = nokmodel.NEXT_OF_KIN_RESIDENTIALSTREET; newentity.NOK_ADDRESS_NO = nokmodel.NOK_ADDRESS_NO; newentity.CITY_TOWN = nokmodel.CITY_TOWN; newentity.LGA = nokmodel.LGA; newentity.NEAREST_BUS_STOP_LANDMARK = nokmodel.NEAREST_BUS_STOP_LANDMARK; newentity.STATE = nokmodel.STATE; newentity.NEXT_OF_KIN_PHONE_NUMBER = nokmodel.NEXT_OF_KIN_PHONE_NUMBER; newentity.NEXT_OF_KIN_PHONE_NUMBER2 = nokmodel.NEXT_OF_KIN_PHONE_NUMBER2; newentity.BRANCH_CODE = nokmodel.BRANCH_CODE; newentity.QUEUE_STATUS = 1; newentity.CREATED_BY = identity.ProfileId.ToString(); newentity.CREATED_DATE = DateTime.Now; newentity.AUTHORISED = "U"; newentity.CUSTOMER_NO = nokmodel.CUSTOMER_NO; newentity.NEAREST_BUS_STOP_LANDMARK = nokmodel.NEAREST_BUS_STOP_LANDMARK; db.CDMA_INDIVIDUAL_NEXT_OF_KIN.Add(newentity); db.SaveChanges(); //do not track audit. _messageService.LogEmailJob(identity.ProfileId, newentity.CUSTOMER_NO, MessageJobEnum.MailType.Change); } else { string errorMessage = string.Format("Cannot update record with Id:{0} as it's not available.", nokmodel.CUSTOMER_NO); ModelState.AddModelError("", errorMessage); } } } SuccessNotification("Next of Kin Updated"); return(continueEditing ? RedirectToAction("Edit", new { id = nokmodel.CUSTOMER_NO }) : RedirectToAction("Index", "DQQue")); //return RedirectToAction("Index"); } PrepareModel(nokmodel); return(View(nokmodel)); }