public ActionResult Create() { //if (!_permissionService.Authorize(StandardPermissionProvider.ManageStores)) // return AccessDeniedView(); AuthFIModel model = new AuthFIModel(); PrepareModel(model); return(View(model)); }
public ActionResult Authorize(string id) { if (string.IsNullOrEmpty(id)) { return(RedirectToAction("AuthList", "DQQue")); } //var model = new AuthFIModel(); var querecord = _dqQueService.GetQueDetailItembyId(Convert.ToInt32(id)); if (querecord == null) { return(RedirectToAction("AuthList", "DQQue")); } //get all changed columns var changeId = _db.CDMA_CHANGE_LOGS.Where(a => a.ENTITYNAME == "CDMA_AUTH_FINANCE_INCLUSION" && a.PRIMARYKEYVALUE == querecord.CUST_ID).OrderByDescending(a => a.DATECHANGED).FirstOrDefault().CHANGEID; var changedSet = _db.CDMA_CHANGE_LOGS.Where(a => a.CHANGEID == changeId); //.Select(a=>a.PROPERTYNAME); AuthFIModel model = (from c in _db.CDMA_AUTH_FINANCE_INCLUSION where c.CUSTOMER_NO == querecord.CUST_ID where c.AUTHORISED == "U" select new AuthFIModel { CUSTOMER_NO = c.CUSTOMER_NO, SOCIAL_FINANCIAL_DISADVTAGE = c.SOCIAL_FINANCIAL_DISADVTAGE, SOCIAL_FINANCIAL_DOCUMENTS = c.SOCIAL_FINANCIAL_DOCUMENTS, ENJOYED_TIERED_KYC = c.ENJOYED_TIERED_KYC, RISK_CATEGORY = c.RISK_CATEGORY, MANDATE_AUTH_COMBINE_RULE = c.MANDATE_AUTH_COMBINE_RULE, ACCOUNT_WITH_OTHER_BANKS = c.ACCOUNT_WITH_OTHER_BANKS, LastUpdatedby = c.LAST_MODIFIED_BY, LastUpdatedDate = c.LAST_MODIFIED_DATE, LastAuthdby = c.AUTHORISED_BY, LastAuthDate = c.AUTHORISED_DATE, ExceptionId = querecord.EXCEPTION_ID }).FirstOrDefault(); if (model != null) { foreach (var item in model.GetType().GetProperties()) //BindingFlags.Public | BindingFlags.Static { foreach (var item2 in changedSet) { if (item2.PROPERTYNAME == item.Name) { ModelState.AddModelError(item.Name, string.Format("Field has been modified, value was {0}", item2.OLDVALUE)); } } } } model.ReadOnlyForm = "True"; PrepareModel(model); return(View(model)); }
// GET: FinInclusion/Create public ActionResult Create_(string id = "") { AuthFIModel model = new AuthFIModel(); if (id != "") { model.CUSTOMER_NO = id; } PrepareModel(model); return(View(model)); }
public ActionResult Edit(string id) { if (string.IsNullOrEmpty(id)) { return(RedirectToAction("Create")); } int records = _db.CDMA_AUTH_FINANCE_INCLUSION.Count(o => o.CUSTOMER_NO == id); AuthFIModel model = new AuthFIModel(); if (records > 1) { model = (from c in _db.CDMA_AUTH_FINANCE_INCLUSION where c.CUSTOMER_NO == id where c.AUTHORISED == "U" select new AuthFIModel { CUSTOMER_NO = c.CUSTOMER_NO, SOCIAL_FINANCIAL_DISADVTAGE = c.SOCIAL_FINANCIAL_DISADVTAGE, SOCIAL_FINANCIAL_DOCUMENTS = c.SOCIAL_FINANCIAL_DOCUMENTS, ENJOYED_TIERED_KYC = c.ENJOYED_TIERED_KYC, RISK_CATEGORY = c.RISK_CATEGORY, MANDATE_AUTH_COMBINE_RULE = c.MANDATE_AUTH_COMBINE_RULE, ACCOUNT_WITH_OTHER_BANKS = c.ACCOUNT_WITH_OTHER_BANKS, }).FirstOrDefault(); } else if (records == 1) { model = (from c in _db.CDMA_AUTH_FINANCE_INCLUSION where c.CUSTOMER_NO == id where c.AUTHORISED == "A" select new AuthFIModel { CUSTOMER_NO = c.CUSTOMER_NO, SOCIAL_FINANCIAL_DISADVTAGE = c.SOCIAL_FINANCIAL_DISADVTAGE, SOCIAL_FINANCIAL_DOCUMENTS = c.SOCIAL_FINANCIAL_DOCUMENTS, ENJOYED_TIERED_KYC = c.ENJOYED_TIERED_KYC, RISK_CATEGORY = c.RISK_CATEGORY, MANDATE_AUTH_COMBINE_RULE = c.MANDATE_AUTH_COMBINE_RULE, ACCOUNT_WITH_OTHER_BANKS = c.ACCOUNT_WITH_OTHER_BANKS, }).FirstOrDefault(); } PrepareModel(model); return(View(model)); }
protected virtual void PrepareModel(AuthFIModel model) { //if (model == null) // throw new ArgumentNullException("model"); if (model == null) { throw new ArgumentNullException("model"); } model.SocialOrFin.Add(new SelectListItem { Text = "Yes", Value = "Y" }); model.SocialOrFin.Add(new SelectListItem { Text = "No", Value = "N" }); model.KycReq.Add(new SelectListItem { Text = "Yes", Value = "Y" }); model.KycReq.Add(new SelectListItem { Text = "No", Value = "N" }); model.YesKyc.Add(new SelectListItem { Text = "Low", Value = "Low" }); model.YesKyc.Add(new SelectListItem { Text = "Medium", Value = "Medium" }); model.YesKyc.Add(new SelectListItem { Text = "High", Value = "High" }); }
public ActionResult Edit_1(AuthFIModel clienaccmodel, 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_AUTH_FINANCE_INCLUSION.FirstOrDefault(o => o.CUSTOMER_NO == clienaccmodel.CUSTOMER_NO); if (entity == null) { string errorMessage = string.Format("Cannot update record with Id:{0} as it's not available.", clienaccmodel.CUSTOMER_NO); ModelState.AddModelError("", errorMessage); } else { entity.CUSTOMER_NO = clienaccmodel.CUSTOMER_NO; entity.SOCIAL_FINANCIAL_DISADVTAGE = clienaccmodel.SOCIAL_FINANCIAL_DISADVTAGE; entity.SOCIAL_FINANCIAL_DOCUMENTS = clienaccmodel.SOCIAL_FINANCIAL_DOCUMENTS; entity.ENJOYED_TIERED_KYC = clienaccmodel.ENJOYED_TIERED_KYC; entity.RISK_CATEGORY = clienaccmodel.RISK_CATEGORY; entity.MANDATE_AUTH_COMBINE_RULE = clienaccmodel.MANDATE_AUTH_COMBINE_RULE; entity.ACCOUNT_WITH_OTHER_BANKS = clienaccmodel.ACCOUNT_WITH_OTHER_BANKS; entity.LAST_MODIFIED_BY = identity.ProfileId.ToString(); entity.LAST_MODIFIED_DATE = DateTime.Now; entity.AUTHORISED = "U"; db.CDMA_AUTH_FINANCE_INCLUSION.Attach(entity); db.Entry(entity).State = EntityState.Modified; db.SaveChanges(); } } SuccessNotification("Customer Client Acc Updated"); return(continueEditing ? RedirectToAction("Edit", new { id = clienaccmodel.CUSTOMER_NO }) : RedirectToAction("Index", "DQQue")); //return RedirectToAction("Index"); } PrepareModel(clienaccmodel); return(View(clienaccmodel)); }
public ActionResult Create_1(AuthFIModel clienaccmodel, bool continueEditing) { if (!User.Identity.IsAuthenticated) { return(AccessDeniedView()); } var identity = ((CustomPrincipal)User).CustomIdentity; AuthFIModel model = new AuthFIModel(); PrepareModel(model); if (ModelState.IsValid) { using (var db = new AppDbContext()) { CDMA_AUTH_FINANCE_INCLUSION entity = new CDMA_AUTH_FINANCE_INCLUSION(); //db.CDMA_TRUSTS_CLIENT_ACCOUNTS.FirstOrDefault(o => o.CUSTOMER_NO == clienaccmodel.CUSTOMER_NO); entity.CUSTOMER_NO = clienaccmodel.CUSTOMER_NO; entity.CUSTOMER_NO = clienaccmodel.CUSTOMER_NO; entity.SOCIAL_FINANCIAL_DISADVTAGE = clienaccmodel.SOCIAL_FINANCIAL_DISADVTAGE; entity.SOCIAL_FINANCIAL_DOCUMENTS = clienaccmodel.SOCIAL_FINANCIAL_DOCUMENTS; entity.ENJOYED_TIERED_KYC = clienaccmodel.ENJOYED_TIERED_KYC; entity.RISK_CATEGORY = clienaccmodel.RISK_CATEGORY; entity.MANDATE_AUTH_COMBINE_RULE = clienaccmodel.MANDATE_AUTH_COMBINE_RULE; entity.ACCOUNT_WITH_OTHER_BANKS = clienaccmodel.ACCOUNT_WITH_OTHER_BANKS; entity.CREATED_BY = identity.ProfileId.ToString(); entity.CREATED_DATE = DateTime.Now; entity.LAST_MODIFIED_BY = identity.ProfileId.ToString(); entity.LAST_MODIFIED_DATE = DateTime.Now; entity.AUTHORISED = "U"; entity.IP_ADDRESS = this.Request.ServerVariables["REMOTE_ADDR"]; db.CDMA_AUTH_FINANCE_INCLUSION.Add(entity); // db.Entry(entity).State = EntityState.Modified; db.SaveChanges(); SuccessNotification("Customer Client Acc Created"); return(continueEditing ? RedirectToAction("Edit", new { id = clienaccmodel.CUSTOMER_NO }) : RedirectToAction("Index", "DQQue")); } } return(View(clienaccmodel)); }
public ActionResult DisApprove_(AuthFIModel afimodel, bool continueEditing) { if (!User.Identity.IsAuthenticated) { return(AccessDeniedView()); } var identity = ((CustomPrincipal)User).CustomIdentity; if (ModelState.IsValid) { _dqQueService.DisApproveExceptionQueItems(afimodel.ExceptionId.ToString(), afimodel.AuthoriserRemarks); SuccessNotification("AFI Authorised"); return(continueEditing ? RedirectToAction("Authorize", new { id = afimodel.CUSTOMER_NO }) : RedirectToAction("Authorize", "AuthFinInclusion")); //return RedirectToAction("Index"); } PrepareModel(afimodel); return(View(afimodel)); }
public ActionResult Create(AuthFIModel afimodel, 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_AUTH_FINANCE_INCLUSION afi = new CDMA_AUTH_FINANCE_INCLUSION { CUSTOMER_NO = afimodel.CUSTOMER_NO, SOCIAL_FINANCIAL_DISADVTAGE = afimodel.SOCIAL_FINANCIAL_DISADVTAGE, SOCIAL_FINANCIAL_DOCUMENTS = afimodel.SOCIAL_FINANCIAL_DOCUMENTS, ENJOYED_TIERED_KYC = afimodel.ENJOYED_TIERED_KYC, RISK_CATEGORY = afimodel.RISK_CATEGORY, MANDATE_AUTH_COMBINE_RULE = afimodel.MANDATE_AUTH_COMBINE_RULE, ACCOUNT_WITH_OTHER_BANKS = afimodel.ACCOUNT_WITH_OTHER_BANKS, 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_AUTH_FINANCE_INCLUSION.Add(afi); _db.SaveChanges(); //_localizationService.GetResource("Admin.Configuration.Stores.Added") SuccessNotification("New AFI has been Added"); //do activity log return(continueEditing ? RedirectToAction("Edit", new { id = afimodel.CUSTOMER_NO }) : RedirectToAction("Create")); //return RedirectToAction("Index"); } PrepareModel(afimodel); return(View(afimodel)); }
public ActionResult Authorize(AuthFIModel afimodel, bool disapproveRecord) { if (!User.Identity.IsAuthenticated) { return(AccessDeniedView()); } var identity = ((CustomPrincipal)User).CustomIdentity; if (ModelState.IsValid) { var routeValues = System.Web.HttpContext.Current.Request.RequestContext.RouteData.Values; int exceptionId = 0; if (routeValues.ContainsKey("id")) { exceptionId = int.Parse((string)routeValues["id"]); } if (disapproveRecord) { _dqQueService.DisApproveExceptionQueItems(exceptionId.ToString(), afimodel.AuthoriserRemarks); SuccessNotification("AFI Not Authorised"); _messageService.LogEmailJob(identity.ProfileId, afimodel.CUSTOMER_NO, MessageJobEnum.MailType.Reject, Convert.ToInt32(afimodel.LastUpdatedby)); } else { _dqQueService.ApproveExceptionQueItems(exceptionId.ToString(), identity.ProfileId); SuccessNotification("AFI Authorised"); _messageService.LogEmailJob(identity.ProfileId, afimodel.CUSTOMER_NO, MessageJobEnum.MailType.Authorize, Convert.ToInt32(afimodel.LastUpdatedby)); } return(RedirectToAction("AuthList", "DQQue")); //return RedirectToAction("Index"); } PrepareModel(afimodel); return(View(afimodel)); }
public ActionResult Edit(AuthFIModel afimodel, bool continueEditing) { if (!User.Identity.IsAuthenticated) { return(AccessDeniedView()); } var identity = ((CustomPrincipal)User).CustomIdentity; bool updateFlag = false; if (ModelState.IsValid) { CDMA_AUTH_FINANCE_INCLUSION originalObject = new CDMA_AUTH_FINANCE_INCLUSION(); using (var db = new AppDbContext()) { int records = db.CDMA_AUTH_FINANCE_INCLUSION.Count(o => o.CUSTOMER_NO == afimodel.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_AUTH_FINANCE_INCLUSION.Where(o => o.CUSTOMER_NO == afimodel.CUSTOMER_NO && o.AUTHORISED == "U").FirstOrDefault(); var entity = db.CDMA_AUTH_FINANCE_INCLUSION.FirstOrDefault(o => o.CUSTOMER_NO == afimodel.CUSTOMER_NO && o.AUTHORISED == "U"); if (entity != null) { entity.SOCIAL_FINANCIAL_DISADVTAGE = afimodel.SOCIAL_FINANCIAL_DISADVTAGE; entity.SOCIAL_FINANCIAL_DOCUMENTS = afimodel.SOCIAL_FINANCIAL_DOCUMENTS; entity.ENJOYED_TIERED_KYC = afimodel.ENJOYED_TIERED_KYC; entity.RISK_CATEGORY = afimodel.RISK_CATEGORY; entity.MANDATE_AUTH_COMBINE_RULE = afimodel.MANDATE_AUTH_COMBINE_RULE; entity.ACCOUNT_WITH_OTHER_BANKS = afimodel.ACCOUNT_WITH_OTHER_BANKS; entity.LAST_MODIFIED_BY = identity.ProfileId.ToString(); entity.LAST_MODIFIED_DATE = DateTime.Now; //entity.AUTHORISED = "U"; db.CDMA_AUTH_FINANCE_INCLUSION.Attach(entity); db.Entry(entity).State = EntityState.Modified; db.SaveChanges(identity.ProfileId.ToString(), afimodel.CUSTOMER_NO, updateFlag, originalObject); _messageService.LogEmailJob(identity.ProfileId, entity.CUSTOMER_NO, MessageJobEnum.MailType.Change); } } else if (records == 1) { updateFlag = false; var entity = db.CDMA_AUTH_FINANCE_INCLUSION.FirstOrDefault(o => o.CUSTOMER_NO == afimodel.CUSTOMER_NO && o.AUTHORISED == "A"); originalObject = _db.CDMA_AUTH_FINANCE_INCLUSION.Where(o => o.CUSTOMER_NO == afimodel.CUSTOMER_NO && o.AUTHORISED == "A").FirstOrDefault(); if (originalObject != null) { entity.SOCIAL_FINANCIAL_DISADVTAGE = afimodel.SOCIAL_FINANCIAL_DISADVTAGE; entity.SOCIAL_FINANCIAL_DOCUMENTS = afimodel.SOCIAL_FINANCIAL_DOCUMENTS; entity.ENJOYED_TIERED_KYC = afimodel.ENJOYED_TIERED_KYC; entity.RISK_CATEGORY = afimodel.RISK_CATEGORY; entity.MANDATE_AUTH_COMBINE_RULE = afimodel.MANDATE_AUTH_COMBINE_RULE; entity.ACCOUNT_WITH_OTHER_BANKS = afimodel.ACCOUNT_WITH_OTHER_BANKS; entity.LAST_MODIFIED_BY = identity.ProfileId.ToString(); entity.LAST_MODIFIED_DATE = DateTime.Now; //entity.AUTHORISED = "U"; db.CDMA_AUTH_FINANCE_INCLUSION.Attach(entity); db.Entry(entity).State = EntityState.Modified; db.SaveChanges(identity.ProfileId.ToString(), afimodel.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_AUTH_FINANCE_INCLUSION(); newentity.SOCIAL_FINANCIAL_DISADVTAGE = afimodel.SOCIAL_FINANCIAL_DISADVTAGE; newentity.SOCIAL_FINANCIAL_DOCUMENTS = afimodel.SOCIAL_FINANCIAL_DOCUMENTS; newentity.ENJOYED_TIERED_KYC = afimodel.ENJOYED_TIERED_KYC; newentity.RISK_CATEGORY = afimodel.RISK_CATEGORY; newentity.MANDATE_AUTH_COMBINE_RULE = afimodel.MANDATE_AUTH_COMBINE_RULE; newentity.ACCOUNT_WITH_OTHER_BANKS = afimodel.ACCOUNT_WITH_OTHER_BANKS; newentity.CREATED_BY = identity.ProfileId.ToString(); newentity.CREATED_DATE = DateTime.Now; newentity.AUTHORISED = "U"; newentity.CUSTOMER_NO = afimodel.CUSTOMER_NO; db.CDMA_AUTH_FINANCE_INCLUSION.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.", afimodel.CUSTOMER_NO); ModelState.AddModelError("", errorMessage); } } } SuccessNotification("AFI Updated"); return(continueEditing ? RedirectToAction("Edit", new { id = afimodel.CUSTOMER_NO }) : RedirectToAction("Index", "DQQue")); //return RedirectToAction("Index"); } PrepareModel(afimodel); return(View(afimodel)); }