public ActionResult DeleteConfirmed(string id) { CDMA_EMPLOYMENT_DETAILS cDMA_EMPLOYMENT_DETAILS = _db.CDMA_EMPLOYMENT_DETAILS.Find(id); _db.CDMA_EMPLOYMENT_DETAILS.Remove(cDMA_EMPLOYMENT_DETAILS); _db.SaveChanges(); return(RedirectToAction("Index")); }
// GET: EmployeeInfo/Delete/5 public ActionResult Delete(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CDMA_EMPLOYMENT_DETAILS cDMA_EMPLOYMENT_DETAILS = _db.CDMA_EMPLOYMENT_DETAILS.Find(id); if (cDMA_EMPLOYMENT_DETAILS == null) { return(HttpNotFound()); } return(View(cDMA_EMPLOYMENT_DETAILS)); }
public ActionResult Create_1([Bind(Include = "CUSTOMER_NO,EMPLOYMENT_STATUS,EMPLOYER_INSTITUTION_NAME,DATE_OF_EMPLOYMENT,SECTOR_CLASS,SUB_SECTOR,NATURE_OF_BUSINESS_OCCUPATION,INDUSTRY_SEGMENT,CREATED_DATE,CREATED_BY,LAST_MODIFIED_DATE,LAST_MODIFIED_BY,AUTHORISED,AUTHORISED_BY,AUTHORISED_DATE,IP_ADDRESS")] CDMA_EMPLOYMENT_DETAILS cDMA_EMPLOYMENT_DETAILS) { if (ModelState.IsValid) { _db.CDMA_EMPLOYMENT_DETAILS.Add(cDMA_EMPLOYMENT_DETAILS); _db.SaveChanges(); return(RedirectToAction("Index", "DQQue")); } ViewBag.NATURE_OF_BUSINESS_OCCUPATION = new SelectList(_db.CDMA_NATURE_OF_BUSINESS, "BUSINESS_CODE", "BUSINESS", cDMA_EMPLOYMENT_DETAILS.NATURE_OF_BUSINESS_OCCUPATION); RedirectToAction("Index", "DQQue"); return(View(cDMA_EMPLOYMENT_DETAILS)); }
public ActionResult Edit_1(CDMA_EMPLOYMENT_DETAILS empmodel, bool continueEditing) { if (!User.Identity.IsAuthenticated) { return(AccessDeniedView()); } var identity = ((CustomPrincipal)User).CustomIdentity; if (ModelState.IsValid) { using (var db = new AppDbContext()) { var entity = db.CDMA_EMPLOYMENT_DETAILS.FirstOrDefault(o => o.CUSTOMER_NO == empmodel.CUSTOMER_NO); if (entity == null) { string errorMessage = string.Format("Cannot update record with Id:{0} as it's not available.", empmodel.CUSTOMER_NO); ModelState.AddModelError("", errorMessage); } else { entity.CREATED_BY = empmodel.CREATED_BY; entity.CREATED_DATE = empmodel.CREATED_DATE; entity.DATE_OF_EMPLOYMENT = empmodel.DATE_OF_EMPLOYMENT; entity.EMPLOYER_INSTITUTION_NAME = empmodel.EMPLOYER_INSTITUTION_NAME; entity.EMPLOYMENT_STATUS = empmodel.EMPLOYMENT_STATUS; entity.NATURE_OF_BUSINESS_OCCUPATION = empmodel.NATURE_OF_BUSINESS_OCCUPATION; entity.LAST_MODIFIED_BY = identity.ProfileId.ToString(); entity.LAST_MODIFIED_DATE = DateTime.Now; entity.AUTHORISED = "U"; db.CDMA_EMPLOYMENT_DETAILS.Attach(entity); db.Entry(entity).State = EntityState.Modified; db.SaveChanges(); } } ViewBag.NATURE_OF_BUSINESS_OCCUPATION = new SelectList(_db.CDMA_NATURE_OF_BUSINESS, "BUSINESS_CODE", "BUSINESS", empmodel.NATURE_OF_BUSINESS_OCCUPATION); // PrepareModel(empmodel); SuccessNotification("EMPd Updated"); return(continueEditing ? RedirectToAction("Edit", new { id = empmodel.CUSTOMER_NO }) : RedirectToAction("Index", "DQQue")); } return(View(empmodel)); }
public ActionResult Create(EmpInfoModel empmodel, 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_EMPLOYMENT_DETAILS emp = new CDMA_EMPLOYMENT_DETAILS { CUSTOMER_NO = empmodel.CUSTOMER_NO, EMPLOYMENT_STATUS = empmodel.EMPLOYMENT_STATUS, EMPLOYER_INSTITUTION_NAME = empmodel.EMPLOYER_INSTITUTION_NAME, DATE_OF_EMPLOYMENT = empmodel.DATE_OF_EMPLOYMENT, NATURE_OF_BUSINESS_OCCUPATION = empmodel.NATURE_OF_BUSINESS_OCCUPATION, 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_EMPLOYMENT_DETAILS.Add(emp); _db.SaveChanges(); //_localizationService.GetResource("Admin.Configuration.Stores.Added") SuccessNotification("New EMP has been Added"); //do activity log return(continueEditing ? RedirectToAction("Edit", new { id = empmodel.CUSTOMER_NO }) : RedirectToAction("Create")); //return RedirectToAction("Index"); } PrepareModel(empmodel); return(View(empmodel)); }
public ActionResult Edit(EmpInfoModel empmodel, bool continueEditing) { if (!User.Identity.IsAuthenticated) { return(AccessDeniedView()); } var identity = ((CustomPrincipal)User).CustomIdentity; bool updateFlag = false; if (ModelState.IsValid) { CDMA_EMPLOYMENT_DETAILS originalObject = new CDMA_EMPLOYMENT_DETAILS(); using (var db = new AppDbContext()) { int records = db.CDMA_EMPLOYMENT_DETAILS.Count(o => o.CUSTOMER_NO == empmodel.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_EMPLOYMENT_DETAILS.Where(o => o.CUSTOMER_NO == empmodel.CUSTOMER_NO && o.AUTHORISED == "U").FirstOrDefault(); var entity = db.CDMA_EMPLOYMENT_DETAILS.FirstOrDefault(o => o.CUSTOMER_NO == empmodel.CUSTOMER_NO && o.AUTHORISED == "U"); if (entity != null) { entity.OCCUPATION = empmodel.OCCUPATION; entity.EMPLOYMENT_STATUS = empmodel.EMPLOYMENT_STATUS; entity.FAX_NO = empmodel.FAX_NO; entity.DATE_OF_EMPLOYMENT = empmodel.DATE_OF_EMPLOYMENT; entity.EMP_ADDRESS_NO = empmodel.EMP_ADDRESS_NO; entity.EMPLOYMENT_ADD_LGA = empmodel.EMPLOYMENT_ADD_LGA; entity.EMPLOYMENT_ADDRESS_CITY = empmodel.EMPLOYMENT_ADDRESS_CITY; entity.EMPLOYER_INSTITUTION_NAME = empmodel.EMPLOYER_INSTITUTION_NAME; entity.NATURE_OF_BUSINESS_OCCUPATION = empmodel.NATURE_OF_BUSINESS_OCCUPATION; entity.OFFICE_NO_CUSTOMER = empmodel.OFFICE_NO_CUSTOMER; entity.EMPLOYER_ADD_STATE = empmodel.EMPLOYER_ADD_STATE; entity.STREET_NAME = empmodel.STREET_NAME; entity.ANNUAL_INCOME = empmodel.ANNUAL_INCOME; entity.BUSTOP_LANDMARK_EMPLOYMENT_ADD = empmodel.BUSTOP_LANDMARK_EMPLOYMENT_ADD; entity.BRANCH_CODE = empmodel.BRANCH_CODE; entity.TIER = empmodel.TIER; entity.QUEUE_STATUS = 1; entity.LAST_MODIFIED_BY = identity.ProfileId.ToString(); entity.LAST_MODIFIED_DATE = DateTime.Now; db.CDMA_EMPLOYMENT_DETAILS.Attach(entity); db.Entry(entity).State = EntityState.Modified; db.SaveChanges(identity.ProfileId.ToString(), empmodel.CUSTOMER_NO, updateFlag, originalObject); _messageService.LogEmailJob(identity.ProfileId, entity.CUSTOMER_NO, MessageJobEnum.MailType.Change); } } else if (records == 1) { updateFlag = false; var entity = db.CDMA_EMPLOYMENT_DETAILS.FirstOrDefault(o => o.CUSTOMER_NO == empmodel.CUSTOMER_NO && o.AUTHORISED == "A"); originalObject = _db.CDMA_EMPLOYMENT_DETAILS.Where(o => o.CUSTOMER_NO == empmodel.CUSTOMER_NO && o.AUTHORISED == "A").FirstOrDefault(); if (originalObject != null) { entity.OCCUPATION = empmodel.OCCUPATION; entity.EMPLOYMENT_STATUS = empmodel.EMPLOYMENT_STATUS; entity.FAX_NO = empmodel.FAX_NO; entity.DATE_OF_EMPLOYMENT = empmodel.DATE_OF_EMPLOYMENT; entity.EMP_ADDRESS_NO = empmodel.EMP_ADDRESS_NO; entity.EMPLOYMENT_ADD_LGA = empmodel.EMPLOYMENT_ADD_LGA; entity.EMPLOYMENT_ADDRESS_CITY = empmodel.EMPLOYMENT_ADDRESS_CITY; entity.EMPLOYER_INSTITUTION_NAME = empmodel.EMPLOYER_INSTITUTION_NAME; entity.NATURE_OF_BUSINESS_OCCUPATION = empmodel.NATURE_OF_BUSINESS_OCCUPATION; entity.OFFICE_NO_CUSTOMER = empmodel.OFFICE_NO_CUSTOMER; entity.EMPLOYER_ADD_STATE = empmodel.EMPLOYER_ADD_STATE; entity.STREET_NAME = empmodel.STREET_NAME; entity.ANNUAL_INCOME = empmodel.ANNUAL_INCOME; entity.BUSTOP_LANDMARK_EMPLOYMENT_ADD = empmodel.BUSTOP_LANDMARK_EMPLOYMENT_ADD; entity.BRANCH_CODE = empmodel.BRANCH_CODE; entity.TIER = empmodel.TIER; entity.QUEUE_STATUS = 1; entity.LAST_MODIFIED_BY = identity.ProfileId.ToString(); entity.LAST_MODIFIED_DATE = DateTime.Now; db.CDMA_EMPLOYMENT_DETAILS.Attach(entity); db.Entry(entity).State = EntityState.Modified; db.SaveChanges(identity.ProfileId.ToString(), empmodel.CUSTOMER_NO, updateFlag, originalObject); var newentity = new CDMA_EMPLOYMENT_DETAILS(); newentity.OCCUPATION = empmodel.OCCUPATION; newentity.EMPLOYMENT_STATUS = empmodel.EMPLOYMENT_STATUS; newentity.FAX_NO = empmodel.FAX_NO; newentity.DATE_OF_EMPLOYMENT = empmodel.DATE_OF_EMPLOYMENT; newentity.EMP_ADDRESS_NO = empmodel.EMP_ADDRESS_NO; newentity.EMPLOYMENT_ADD_LGA = empmodel.EMPLOYMENT_ADD_LGA; newentity.EMPLOYMENT_ADDRESS_CITY = empmodel.EMPLOYMENT_ADDRESS_CITY; newentity.EMPLOYER_INSTITUTION_NAME = empmodel.EMPLOYER_INSTITUTION_NAME; newentity.NATURE_OF_BUSINESS_OCCUPATION = empmodel.NATURE_OF_BUSINESS_OCCUPATION; newentity.OFFICE_NO_CUSTOMER = empmodel.OFFICE_NO_CUSTOMER; newentity.EMPLOYER_ADD_STATE = empmodel.EMPLOYER_ADD_STATE; newentity.STREET_NAME = empmodel.STREET_NAME; newentity.ANNUAL_INCOME = empmodel.ANNUAL_INCOME; newentity.BUSTOP_LANDMARK_EMPLOYMENT_ADD = empmodel.BUSTOP_LANDMARK_EMPLOYMENT_ADD; newentity.BRANCH_CODE = empmodel.BRANCH_CODE; newentity.TIER = empmodel.TIER; newentity.QUEUE_STATUS = 1; newentity.CREATED_BY = identity.ProfileId.ToString(); newentity.CREATED_DATE = DateTime.Now; newentity.AUTHORISED = "U"; newentity.CUSTOMER_NO = empmodel.CUSTOMER_NO; db.CDMA_EMPLOYMENT_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.", empmodel.CUSTOMER_NO); ModelState.AddModelError("", errorMessage); } } } SuccessNotification("Employee Details Updated"); return(continueEditing ? RedirectToAction("Edit", new { id = empmodel.CUSTOMER_NO }) : RedirectToAction("Index", "DQQue")); //return RedirectToAction("Index"); } PrepareModel(empmodel); return(View(empmodel)); }