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));
}
