public ActionResult DeleteConfirmed(string id) { CDMA_JURAT cDMA_JURAT = _db.CDMA_JURAT.Find(id); _db.CDMA_JURAT.Remove(cDMA_JURAT); _db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit_1([Bind(Include = "CUSTOMER_NO,DATE_OF_OATH,NAME_OF_INTERPRETER,ADDRESS_OF_INTERPRETER,TELEPHONE_NO,LANGUAGE_OF_INTERPRETATION,CREATED_DATE,CREATED_BY,LAST_MODIFIED_DATE,LAST_MODIFIED_BY,AUTHORISED,AUTHORISED_BY,AUTHORISED_DATE,IP_ADDRESS")] CDMA_JURAT cDMA_JURAT) { if (ModelState.IsValid) { _db.Entry(cDMA_JURAT).State = EntityState.Modified; _db.SaveChanges(); return(RedirectToAction("Index")); } return(View(cDMA_JURAT)); }
// GET: CustJurat/Delete/5 public ActionResult Delete(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CDMA_JURAT cDMA_JURAT = _db.CDMA_JURAT.Find(id); if (cDMA_JURAT == null) { return(HttpNotFound()); } return(View(cDMA_JURAT)); }
public ActionResult Create(CustomerJuratModel cjmodel, bool continueEditing) { //if (!_permissionService.Authorize(StandardPermissionProvider.ManageStores)) // return AccessDeniedView(); if (!User.Identity.IsAuthenticated) { return(AccessDeniedView()); } var identity = ((CustomPrincipal)User).CustomIdentity; string ip_address = Request.ServerVariables["REMOTE_ADDR"].ToString(); if (ModelState.IsValid) { CDMA_JURAT jurat = new CDMA_JURAT { CUSTOMER_NO = cjmodel.CUSTOMER_NO, DATE_OF_OATH = cjmodel.DATE_OF_OATH, NAME_OF_INTERPRETER = cjmodel.NAME_OF_INTERPRETER, ADDRESS_OF_INTERPRETER = cjmodel.ADDRESS_OF_INTERPRETER, TELEPHONE_NO = cjmodel.TELEPHONE_NO, LANGUAGE_OF_INTERPRETATION = cjmodel.LANGUAGE_OF_INTERPRETATION, CREATED_BY = identity.ProfileId.ToString(), CREATED_DATE = DateTime.Now, LAST_MODIFIED_BY = identity.ProfileId.ToString(), LAST_MODIFIED_DATE = DateTime.Now, AUTHORISED_BY = null, AUTHORISED_DATE = null, IP_ADDRESS = ip_address }; _db.CDMA_JURAT.Add(jurat); _db.SaveChanges(); //_localizationService.GetResource("Admin.Configuration.Stores.Added") SuccessNotification("New JURAT has been Added"); //do activity log return(continueEditing ? RedirectToAction("Edit", new { id = cjmodel.CUSTOMER_NO }) : RedirectToAction("Create")); //return RedirectToAction("Index"); } PrepareModel(cjmodel); return(View(cjmodel)); }
public ActionResult Edit(CustomerJuratModel cjmodel, bool continueEditing) { if (!User.Identity.IsAuthenticated) { return(AccessDeniedView()); } var identity = ((CustomPrincipal)User).CustomIdentity; bool updateFlag = false; if (ModelState.IsValid) { CDMA_JURAT originalObject = new CDMA_JURAT(); using (var db = new AppDbContext()) { int records = db.CDMA_JURAT.Count(o => o.CUSTOMER_NO == cjmodel.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_JURAT.Where(o => o.CUSTOMER_NO == cjmodel.CUSTOMER_NO && o.AUTHORISED == "U").FirstOrDefault(); var entity = db.CDMA_JURAT.FirstOrDefault(o => o.CUSTOMER_NO == cjmodel.CUSTOMER_NO && o.AUTHORISED == "U"); if (entity != null) { entity.DATE_OF_OATH = cjmodel.DATE_OF_OATH; entity.NAME_OF_INTERPRETER = cjmodel.NAME_OF_INTERPRETER; entity.ADDRESS_OF_INTERPRETER = cjmodel.ADDRESS_OF_INTERPRETER; entity.TELEPHONE_NO = cjmodel.TELEPHONE_NO; entity.LANGUAGE_OF_INTERPRETATION = cjmodel.LANGUAGE_OF_INTERPRETATION; entity.LAST_MODIFIED_BY = identity.ProfileId.ToString(); entity.LAST_MODIFIED_DATE = DateTime.Now; //entity.AUTHORISED = "U"; db.CDMA_JURAT.Attach(entity); db.Entry(entity).State = EntityState.Modified; db.SaveChanges(identity.ProfileId.ToString(), cjmodel.CUSTOMER_NO, updateFlag, originalObject); _messageService.LogEmailJob(identity.ProfileId, entity.CUSTOMER_NO, MessageJobEnum.MailType.Change); } } else if (records == 1) { updateFlag = false; var entity = db.CDMA_JURAT.FirstOrDefault(o => o.CUSTOMER_NO == cjmodel.CUSTOMER_NO && o.AUTHORISED == "A"); originalObject = _db.CDMA_JURAT.Where(o => o.CUSTOMER_NO == cjmodel.CUSTOMER_NO && o.AUTHORISED == "A").FirstOrDefault(); if (originalObject != null) { entity.DATE_OF_OATH = cjmodel.DATE_OF_OATH; entity.NAME_OF_INTERPRETER = cjmodel.NAME_OF_INTERPRETER; entity.ADDRESS_OF_INTERPRETER = cjmodel.ADDRESS_OF_INTERPRETER; entity.TELEPHONE_NO = cjmodel.TELEPHONE_NO; entity.LANGUAGE_OF_INTERPRETATION = cjmodel.LANGUAGE_OF_INTERPRETATION; entity.LAST_MODIFIED_BY = identity.ProfileId.ToString(); entity.LAST_MODIFIED_DATE = DateTime.Now; db.CDMA_JURAT.Attach(entity); db.Entry(entity).State = EntityState.Modified; db.SaveChanges(identity.ProfileId.ToString(), cjmodel.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_JURAT(); newentity.DATE_OF_OATH = cjmodel.DATE_OF_OATH; newentity.NAME_OF_INTERPRETER = cjmodel.NAME_OF_INTERPRETER; newentity.ADDRESS_OF_INTERPRETER = cjmodel.ADDRESS_OF_INTERPRETER; newentity.TELEPHONE_NO = cjmodel.TELEPHONE_NO; newentity.LANGUAGE_OF_INTERPRETATION = cjmodel.LANGUAGE_OF_INTERPRETATION; newentity.LAST_MODIFIED_BY = identity.ProfileId.ToString(); newentity.LAST_MODIFIED_DATE = DateTime.Now; newentity.AUTHORISED = "U"; newentity.CUSTOMER_NO = cjmodel.CUSTOMER_NO; db.CDMA_JURAT.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.", cjmodel.CUSTOMER_NO); ModelState.AddModelError("", errorMessage); } } } SuccessNotification("JURAT Updated"); return(continueEditing ? RedirectToAction("Edit", new { id = cjmodel.CUSTOMER_NO }) : RedirectToAction("Index", "DQQue")); } PrepareModel(cjmodel); return(View(cjmodel)); }