public ActionResult DeleteConfirmed(string id) { CDMA_FOREIGN_DETAILS cDMA_FOREIGN_DETAILS = _db.CDMA_FOREIGN_DETAILS.Find(id); _db.CDMA_FOREIGN_DETAILS.Remove(cDMA_FOREIGN_DETAILS); _db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit_1([Bind(Include = "CUSTOMER_NO,FOREIGNER,PASSPORT_RESIDENCE_PERMIT,PERMIT_ISSUE_DATE,PERMIT_EXPIRY_DATE,FOREIGN_ADDRESS,CITY,COUNTRY,ZIP_POSTAL_CODE,FOREIGN_TEL_NUMBER,PURPOSE_OF_ACCOUNT,CREATED_DATE,CREATED_BY,LAST_MODIFIED_DATE,LAST_MODIFIED_BY,AUTHORISED,AUTHORISED_BY,AUTHORISED_DATE,IP_ADDRESS,MULTIPLE_CITEZENSHIP")] CDMA_FOREIGN_DETAILS cDMA_FOREIGN_DETAILS) { if (ModelState.IsValid) { _db.Entry(cDMA_FOREIGN_DETAILS).State = EntityState.Modified; _db.SaveChanges(); return(RedirectToAction("Index")); } return(View(cDMA_FOREIGN_DETAILS)); }
// GET: CustForeigner/Delete/5 public ActionResult Delete(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CDMA_FOREIGN_DETAILS cDMA_FOREIGN_DETAILS = _db.CDMA_FOREIGN_DETAILS.Find(id); if (cDMA_FOREIGN_DETAILS == null) { return(HttpNotFound()); } return(View(cDMA_FOREIGN_DETAILS)); }
public ActionResult Create(CustomerForeignerModel formodel, 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_FOREIGN_DETAILS ford = new CDMA_FOREIGN_DETAILS { CUSTOMER_NO = formodel.CUSTOMER_NO, FOREIGNER = formodel.FOREIGNER, PASSPORT_RESIDENCE_PERMIT = formodel.PASSPORT_RESIDENCE_PERMIT, PERMIT_ISSUE_DATE = formodel.PERMIT_ISSUE_DATE, PERMIT_EXPIRY_DATE = formodel.PERMIT_EXPIRY_DATE, FOREIGN_ADDRESS = formodel.FOREIGN_ADDRESS, CITY = formodel.CITY, COUNTRY = formodel.COUNTRY, ZIP_POSTAL_CODE = formodel.ZIP_POSTAL_CODE, FOREIGN_TEL_NUMBER = formodel.FOREIGN_TEL_NUMBER, PURPOSE_OF_ACCOUNT = formodel.PURPOSE_OF_ACCOUNT, 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, MULTIPLE_CITEZENSHIP = formodel.MULTIPLE_CITEZENSHIP }; _db.CDMA_FOREIGN_DETAILS.Add(ford); _db.SaveChanges(); //_localizationService.GetResource("Admin.Configuration.Stores.Added") SuccessNotification("New FORD has been Added"); //do activity log return(continueEditing ? RedirectToAction("Edit", new { id = formodel.CUSTOMER_NO }) : RedirectToAction("Create")); //return RedirectToAction("Index"); } PrepareModel(formodel); return(View(formodel)); }
public ActionResult Edit(CustomerForeignerModel formodel, bool continueEditing) { if (!User.Identity.IsAuthenticated) { return(AccessDeniedView()); } var identity = ((CustomPrincipal)User).CustomIdentity; bool updateFlag = false; if (ModelState.IsValid) { CDMA_FOREIGN_DETAILS originalObject = new CDMA_FOREIGN_DETAILS(); using (var db = new AppDbContext()) { int records = db.CDMA_FOREIGN_DETAILS.Count(o => o.CUSTOMER_NO == formodel.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_FOREIGN_DETAILS.Where(o => o.CUSTOMER_NO == formodel.CUSTOMER_NO && o.AUTHORISED == "U").FirstOrDefault(); var entity = db.CDMA_FOREIGN_DETAILS.FirstOrDefault(o => o.CUSTOMER_NO == formodel.CUSTOMER_NO && o.AUTHORISED == "U"); if (entity != null) { entity.FOREIGNER = formodel.FOREIGNER; entity.PASSPORT_RESIDENCE_PERMIT = formodel.PASSPORT_RESIDENCE_PERMIT; entity.COUNTRY = formodel.COUNTRY; entity.PERMIT_ISSUE_DATE = formodel.PERMIT_ISSUE_DATE; entity.PERMIT_EXPIRY_DATE = formodel.PERMIT_EXPIRY_DATE; entity.FOREIGN_ADDRESS = formodel.FOREIGN_ADDRESS; entity.CITY = formodel.CITY; entity.COUNTRY = formodel.COUNTRY; entity.ZIP_POSTAL_CODE = formodel.ZIP_POSTAL_CODE; entity.FOREIGN_TEL_NUMBER = formodel.FOREIGN_TEL_NUMBER; entity.PURPOSE_OF_ACCOUNT = formodel.PURPOSE_OF_ACCOUNT; entity.MULTIPLE_CITEZENSHIP = formodel.MULTIPLE_CITEZENSHIP; entity.LAST_MODIFIED_BY = identity.ProfileId.ToString(); entity.LAST_MODIFIED_DATE = DateTime.Now; db.CDMA_FOREIGN_DETAILS.Attach(entity); db.Entry(entity).State = EntityState.Modified; db.SaveChanges(identity.ProfileId.ToString(), formodel.CUSTOMER_NO, updateFlag, originalObject); _messageService.LogEmailJob(identity.ProfileId, entity.CUSTOMER_NO, MessageJobEnum.MailType.Change); } } else if (records == 1) { updateFlag = false; var entity = db.CDMA_FOREIGN_DETAILS.FirstOrDefault(o => o.CUSTOMER_NO == formodel.CUSTOMER_NO && o.AUTHORISED == "A"); originalObject = _db.CDMA_FOREIGN_DETAILS.Where(o => o.CUSTOMER_NO == formodel.CUSTOMER_NO && o.AUTHORISED == "A").FirstOrDefault(); if (originalObject != null) { entity.FOREIGNER = formodel.FOREIGNER; entity.PASSPORT_RESIDENCE_PERMIT = formodel.PASSPORT_RESIDENCE_PERMIT; entity.COUNTRY = formodel.COUNTRY; entity.PERMIT_ISSUE_DATE = formodel.PERMIT_ISSUE_DATE; entity.PERMIT_EXPIRY_DATE = formodel.PERMIT_EXPIRY_DATE; entity.FOREIGN_ADDRESS = formodel.FOREIGN_ADDRESS; entity.CITY = formodel.CITY; entity.COUNTRY = formodel.COUNTRY; entity.ZIP_POSTAL_CODE = formodel.ZIP_POSTAL_CODE; entity.FOREIGN_TEL_NUMBER = formodel.FOREIGN_TEL_NUMBER; entity.PURPOSE_OF_ACCOUNT = formodel.PURPOSE_OF_ACCOUNT; entity.MULTIPLE_CITEZENSHIP = formodel.MULTIPLE_CITEZENSHIP; entity.LAST_MODIFIED_BY = identity.ProfileId.ToString(); entity.LAST_MODIFIED_DATE = DateTime.Now; db.CDMA_FOREIGN_DETAILS.Attach(entity); db.Entry(entity).State = EntityState.Modified; db.SaveChanges(identity.ProfileId.ToString(), formodel.CUSTOMER_NO, updateFlag, originalObject); var newentity = new CDMA_FOREIGN_DETAILS(); newentity.FOREIGNER = formodel.FOREIGNER; newentity.PASSPORT_RESIDENCE_PERMIT = formodel.PASSPORT_RESIDENCE_PERMIT; newentity.COUNTRY = formodel.COUNTRY; newentity.PERMIT_ISSUE_DATE = formodel.PERMIT_ISSUE_DATE; newentity.PERMIT_EXPIRY_DATE = formodel.PERMIT_EXPIRY_DATE; newentity.FOREIGN_ADDRESS = formodel.FOREIGN_ADDRESS; newentity.CITY = formodel.CITY; newentity.COUNTRY = formodel.COUNTRY; newentity.ZIP_POSTAL_CODE = formodel.ZIP_POSTAL_CODE; newentity.FOREIGN_TEL_NUMBER = formodel.FOREIGN_TEL_NUMBER; newentity.PURPOSE_OF_ACCOUNT = formodel.PURPOSE_OF_ACCOUNT; newentity.MULTIPLE_CITEZENSHIP = formodel.MULTIPLE_CITEZENSHIP; newentity.CREATED_BY = identity.ProfileId.ToString(); newentity.CREATED_DATE = DateTime.Now; newentity.AUTHORISED = "U"; newentity.CUSTOMER_NO = formodel.CUSTOMER_NO; db.CDMA_FOREIGN_DETAILS.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.", formodel.CUSTOMER_NO); ModelState.AddModelError("", errorMessage); } } } SuccessNotification("FORD Updated"); return(continueEditing ? RedirectToAction("Edit", new { id = formodel.CUSTOMER_NO }) : RedirectToAction("Index", "DQQue")); //return RedirectToAction("Index"); } PrepareModel(formodel); return(View(formodel)); }