public ActionResult Edit(string id) { if (string.IsNullOrEmpty(id)) { return(RedirectToAction("Create")); } int records = _db.CDMA_TRUSTS_CLIENT_ACCOUNTS.Count(o => o.CUSTOMER_NO == id); CustomerTCAModel model = new CustomerTCAModel(); if (records > 1) { model = (from c in _db.CDMA_TRUSTS_CLIENT_ACCOUNTS where c.CUSTOMER_NO == id where c.AUTHORISED == "U" select new CustomerTCAModel { CUSTOMER_NO = c.CUSTOMER_NO, CUSTOMER_BUSINESS_ADDRESS = c.CUSTOMER_BUSINESS_ADDRESS, CUSTOMER_SPOUSE_DOB = c.CUSTOMER_SPOUSE_DOB, OTHER_SOURCE_EXPECT_ANN_INC = c.OTHER_SOURCE_EXPECT_ANN_INC, CUSTOMER_BUSINESS_NAME = c.CUSTOMER_BUSINESS_NAME, CUSTOMER_SPOUSE_NAME = c.CUSTOMER_SPOUSE_NAME, CUSTOMER_SPOUSE_OCCUPATION = c.CUSTOMER_SPOUSE_OCCUPATION, CUSTOMER_BUSINESS_TYPE = c.CUSTOMER_BUSINESS_TYPE, SOURCES_OF_FUND_TO_ACCOUNT = c.SOURCES_OF_FUND_TO_ACCOUNT, BRANCH_CODE = c.BRANCH_CODE, }).FirstOrDefault(); } else if (records == 1) { model = (from c in _db.CDMA_TRUSTS_CLIENT_ACCOUNTS where c.CUSTOMER_NO == id where c.AUTHORISED == "A" select new CustomerTCAModel { CUSTOMER_NO = c.CUSTOMER_NO, CUSTOMER_BUSINESS_ADDRESS = c.CUSTOMER_BUSINESS_ADDRESS, CUSTOMER_SPOUSE_DOB = c.CUSTOMER_SPOUSE_DOB, OTHER_SOURCE_EXPECT_ANN_INC = c.OTHER_SOURCE_EXPECT_ANN_INC, CUSTOMER_BUSINESS_NAME = c.CUSTOMER_BUSINESS_NAME, CUSTOMER_SPOUSE_NAME = c.CUSTOMER_SPOUSE_NAME, CUSTOMER_SPOUSE_OCCUPATION = c.CUSTOMER_SPOUSE_OCCUPATION, CUSTOMER_BUSINESS_TYPE = c.CUSTOMER_BUSINESS_TYPE, SOURCES_OF_FUND_TO_ACCOUNT = c.SOURCES_OF_FUND_TO_ACCOUNT, BRANCH_CODE = c.BRANCH_CODE, }).FirstOrDefault(); } PrepareModel(model); var tcacustid = ""; try { tcacustid = _db.MdmDqRunExceptions.Where(a => a.CATALOG_TABLE_NAME == "CDMA_TRUSTS_CLIENT_ACCOUNTS" && a.CUST_ID == model.CUSTOMER_NO).OrderByDescending(a => a.CREATED_DATE).FirstOrDefault().CUST_ID; } catch (Exception e) { Console.WriteLine(e.Message); } if (tcacustid != "" && model != null) { var exceptionSet = _db.MdmDqRunExceptions.Where(a => a.CUST_ID == tcacustid); //.Select(a=>a.PROPERTYNAME); if (tcacustid != null) { foreach (var item in model.GetType().GetProperties()) //BindingFlags.Public | BindingFlags.Static { foreach (var item2 in exceptionSet) { if (item2.CATALOG_TAB_COL == item.Name) { ModelState.AddModelError(item.Name, string.Format("Attention!")); } } //props.Add(item.Name); } } } return(View(model)); }
public ActionResult Authorize(string id) { if (string.IsNullOrEmpty(id)) { return(RedirectToAction("AuthList", "DQQue")); } //var model = new CustomerTCAModel(); var querecord = _dqQueService.GetQueDetailItembyId(Convert.ToInt32(id)); if (querecord == null) { return(RedirectToAction("AuthList", "DQQue")); } //get all changed columns CustomerTCAModel model = new CustomerTCAModel(); model = (from c in _db.CDMA_TRUSTS_CLIENT_ACCOUNTS where c.CUSTOMER_NO == querecord.CUST_ID where c.AUTHORISED == "U" select new CustomerTCAModel { CUSTOMER_NO = c.CUSTOMER_NO, CUSTOMER_BUSINESS_ADDRESS = c.CUSTOMER_BUSINESS_ADDRESS, CUSTOMER_SPOUSE_DOB = c.CUSTOMER_SPOUSE_DOB, OTHER_SOURCE_EXPECT_ANN_INC = c.OTHER_SOURCE_EXPECT_ANN_INC, CUSTOMER_BUSINESS_NAME = c.CUSTOMER_BUSINESS_NAME, CUSTOMER_SPOUSE_NAME = c.CUSTOMER_SPOUSE_NAME, CUSTOMER_SPOUSE_OCCUPATION = c.CUSTOMER_SPOUSE_OCCUPATION, CUSTOMER_BUSINESS_TYPE = c.CUSTOMER_BUSINESS_TYPE, SOURCES_OF_FUND_TO_ACCOUNT = c.SOURCES_OF_FUND_TO_ACCOUNT, BRANCH_CODE = c.BRANCH_CODE, LastUpdatedby = c.LAST_MODIFIED_BY, LastUpdatedDate = c.LAST_MODIFIED_DATE, LastAuthdby = c.AUTHORISED_BY, LastAuthDate = c.AUTHORISED_DATE, ExceptionId = querecord.EXCEPTION_ID }).FirstOrDefault(); var changelog = _db.CDMA_CHANGE_LOGS.Where(a => a.ENTITYNAME == "CDMA_TRUSTS_CLIENT_ACCOUNTS" && a.PRIMARYKEYVALUE == querecord.CUST_ID).OrderByDescending(a => a.DATECHANGED).FirstOrDefault(); if (changelog != null && model != null) { string changeId = changelog.CHANGEID; var changedSet = _db.CDMA_CHANGE_LOGS.Where(a => a.CHANGEID == changeId); 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)); }