public ActionResult DeleteConfirmed(string id) { CDMA_ADDITIONAL_INFORMATION cDMA_ADDITIONAL_INFORMATION = _db.CDMA_ADDITIONAL_INFORMATION.Find(id); _db.CDMA_ADDITIONAL_INFORMATION.Remove(cDMA_ADDITIONAL_INFORMATION); _db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit_1([Bind(Include = "CUSTOMER_NO,ANNUAL_SALARY_EXPECTED_INC,FAX_NUMBER,CREATED_DATE,CREATED_BY,LAST_MODIFIED_DATE,LAST_MODIFIED_BY,AUTHORISED,AUTHORISED_BY,AUTHORISED_DATE,IP_ADDRESS")] CDMA_ADDITIONAL_INFORMATION cDMA_ADDITIONAL_INFORMATION) { if (ModelState.IsValid) { _db.Entry(cDMA_ADDITIONAL_INFORMATION).State = EntityState.Modified; _db.SaveChanges(); return(RedirectToAction("Index")); } return(View(cDMA_ADDITIONAL_INFORMATION)); }
// GET: CustAdi/Delete/5 public ActionResult Delete(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CDMA_ADDITIONAL_INFORMATION cDMA_ADDITIONAL_INFORMATION = _db.CDMA_ADDITIONAL_INFORMATION.Find(id); if (cDMA_ADDITIONAL_INFORMATION == null) { return(HttpNotFound()); } return(View(cDMA_ADDITIONAL_INFORMATION)); }
public ActionResult Create(CustomerADIModel adimodel, 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_ADDITIONAL_INFORMATION adi = new CDMA_ADDITIONAL_INFORMATION { CUSTOMER_NO = adimodel.CUSTOMER_NO, ANNUAL_SALARY_EXPECTED_INC = adimodel.ANNUAL_SALARY_EXPECTED_INC, FAX_NUMBER = adimodel.FAX_NUMBER, 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_ADDITIONAL_INFORMATION.Add(adi); _db.SaveChanges(); //_localizationService.GetResource("Admin.Configuration.Stores.Added") SuccessNotification("New ADI has been Added"); //do activity log return(continueEditing ? RedirectToAction("Edit", new { id = adimodel.CUSTOMER_NO }) : RedirectToAction("Create")); //return RedirectToAction("Index"); } PrepareModel(adimodel); return(View(adimodel)); }
public ActionResult Edit(CustomerADIModel adimodel, bool continueEditing) { if (!User.Identity.IsAuthenticated) { return(AccessDeniedView()); } var identity = ((CustomPrincipal)User).CustomIdentity; bool updateFlag = false; if (ModelState.IsValid) { CDMA_ADDITIONAL_INFORMATION originalObject = new CDMA_ADDITIONAL_INFORMATION(); using (var db = new AppDbContext()) { int records = db.CDMA_ADDITIONAL_INFORMATION.Count(o => o.CUSTOMER_NO == adimodel.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_ADDITIONAL_INFORMATION.Where(o => o.CUSTOMER_NO == adimodel.CUSTOMER_NO && o.AUTHORISED == "U").FirstOrDefault(); var entity = db.CDMA_ADDITIONAL_INFORMATION.FirstOrDefault(o => o.CUSTOMER_NO == adimodel.CUSTOMER_NO && o.AUTHORISED == "U"); if (entity != null) { entity.ANNUAL_SALARY_EXPECTED_INC = adimodel.ANNUAL_SALARY_EXPECTED_INC; entity.FAX_NUMBER = adimodel.FAX_NUMBER; entity.LAST_MODIFIED_BY = identity.ProfileId.ToString(); entity.LAST_MODIFIED_DATE = DateTime.Now; //entity.AUTHORISED = "U"; db.CDMA_ADDITIONAL_INFORMATION.Attach(entity); db.Entry(entity).State = EntityState.Modified; db.SaveChanges(identity.ProfileId.ToString(), adimodel.CUSTOMER_NO, updateFlag, originalObject); _messageService.LogEmailJob(identity.ProfileId, entity.CUSTOMER_NO, MessageJobEnum.MailType.Change); } } else if (records == 1) { updateFlag = false; var entity = db.CDMA_ADDITIONAL_INFORMATION.FirstOrDefault(o => o.CUSTOMER_NO == adimodel.CUSTOMER_NO && o.AUTHORISED == "A"); originalObject = _db.CDMA_ADDITIONAL_INFORMATION.Where(o => o.CUSTOMER_NO == adimodel.CUSTOMER_NO && o.AUTHORISED == "A").FirstOrDefault(); if (originalObject != null) { entity.ANNUAL_SALARY_EXPECTED_INC = adimodel.ANNUAL_SALARY_EXPECTED_INC; entity.FAX_NUMBER = adimodel.FAX_NUMBER; entity.LAST_MODIFIED_BY = identity.ProfileId.ToString(); entity.LAST_MODIFIED_DATE = DateTime.Now; //entity.AUTHORISED = "U"; db.CDMA_ADDITIONAL_INFORMATION.Attach(entity); db.Entry(entity).State = EntityState.Modified; db.SaveChanges(identity.ProfileId.ToString(), adimodel.CUSTOMER_NO, updateFlag, originalObject); var newentity = new CDMA_ADDITIONAL_INFORMATION(); newentity.ANNUAL_SALARY_EXPECTED_INC = adimodel.ANNUAL_SALARY_EXPECTED_INC; newentity.FAX_NUMBER = adimodel.FAX_NUMBER; newentity.CREATED_BY = identity.ProfileId.ToString(); newentity.CREATED_DATE = DateTime.Now; newentity.AUTHORISED = "U"; newentity.CUSTOMER_NO = adimodel.CUSTOMER_NO; db.CDMA_ADDITIONAL_INFORMATION.Attach(entity); db.Entry(entity).State = EntityState.Modified; db.SaveChanges(); _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.", adimodel.CUSTOMER_NO); ModelState.AddModelError("", errorMessage); //string errorMessage = string.Format("Unauthorized record exists for record with Id:{0} .", nokmodel.CUSTOMER_NO); //ModelState.AddModelError("", errorMessage); } } } SuccessNotification("ADI Updated"); return(continueEditing ? RedirectToAction("Edit", new { id = adimodel.CUSTOMER_NO }) : RedirectToAction("Index", "DQQue")); //return RedirectToAction("Index"); } PrepareModel(adimodel); return(View(adimodel)); }