public ActionResult DeleteConfirmed(string id)
{
CDMA_TRUSTS_CLIENT_ACCOUNTS cDMA_TRUSTS_CLIENT_ACCOUNTS = _db.CDMA_TRUSTS_CLIENT_ACCOUNTS.Find(id);
_db.CDMA_TRUSTS_CLIENT_ACCOUNTS.Remove(cDMA_TRUSTS_CLIENT_ACCOUNTS);
_db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: CusClientAcc/Delete/5
public ActionResult Delete(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CDMA_TRUSTS_CLIENT_ACCOUNTS cDMA_TRUSTS_CLIENT_ACCOUNTS = _db.CDMA_TRUSTS_CLIENT_ACCOUNTS.Find(id);
if (cDMA_TRUSTS_CLIENT_ACCOUNTS == null)
{
return(HttpNotFound());
}
return(View(cDMA_TRUSTS_CLIENT_ACCOUNTS));
}
public ActionResult Create(CustomerTCAModel tcamodel, 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_TRUSTS_CLIENT_ACCOUNTS tca = new CDMA_TRUSTS_CLIENT_ACCOUNTS
{
CUSTOMER_NO = tcamodel.CUSTOMER_NO,
SOURCES_OF_FUND_TO_ACCOUNT = tcamodel.SOURCES_OF_FUND_TO_ACCOUNT,
OTHER_SOURCE_EXPECT_ANN_INC = tcamodel.OTHER_SOURCE_EXPECT_ANN_INC,
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_TRUSTS_CLIENT_ACCOUNTS.Add(tca);
_db.SaveChanges();
//_localizationService.GetResource("Admin.Configuration.Stores.Added")
SuccessNotification("New TCA has been Added");
//do activity log
return(continueEditing ? RedirectToAction("Edit", new { id = tcamodel.CUSTOMER_NO }) : RedirectToAction("Create"));
//return RedirectToAction("Index");
}
PrepareModel(tcamodel);
return(View(tcamodel));
}
public ActionResult Create_1(CustomerTCAModel clienaccmodel, bool continueEditing)
{
if (!User.Identity.IsAuthenticated)
{
return(AccessDeniedView());
}
var identity = ((CustomPrincipal)User).CustomIdentity;
CustomerTCAModel model = new CustomerTCAModel();
PrepareModel(model);
if (ModelState.IsValid)
{
using (var db = new AppDbContext())
{
CDMA_TRUSTS_CLIENT_ACCOUNTS entity = new CDMA_TRUSTS_CLIENT_ACCOUNTS();
//db.CDMA_TRUSTS_CLIENT_ACCOUNTS.FirstOrDefault(o => o.CUSTOMER_NO == clienaccmodel.CUSTOMER_NO);
entity.CUSTOMER_NO = clienaccmodel.CUSTOMER_NO;
entity.SOURCES_OF_FUND_TO_ACCOUNT = clienaccmodel.SOURCES_OF_FUND_TO_ACCOUNT;
entity.OTHER_SOURCE_EXPECT_ANN_INC = clienaccmodel.OTHER_SOURCE_EXPECT_ANN_INC;
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_TRUSTS_CLIENT_ACCOUNTS.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 Edit(CustomerTCAModel tcamodel, bool continueEditing)
{
if (!User.Identity.IsAuthenticated)
{
return(AccessDeniedView());
}
var identity = ((CustomPrincipal)User).CustomIdentity;
bool updateFlag = false;
if (ModelState.IsValid)
{
CDMA_TRUSTS_CLIENT_ACCOUNTS originalObject = new CDMA_TRUSTS_CLIENT_ACCOUNTS();
using (var db = new AppDbContext())
{
int records = db.CDMA_TRUSTS_CLIENT_ACCOUNTS.Count(o => o.CUSTOMER_NO == tcamodel.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_TRUSTS_CLIENT_ACCOUNTS.Where(o => o.CUSTOMER_NO == tcamodel.CUSTOMER_NO && o.AUTHORISED == "U").FirstOrDefault();
var entity = db.CDMA_TRUSTS_CLIENT_ACCOUNTS.FirstOrDefault(o => o.CUSTOMER_NO == tcamodel.CUSTOMER_NO && o.AUTHORISED == "U");
if (entity != null)
{
entity.CUSTOMER_BUSINESS_ADDRESS = tcamodel.CUSTOMER_BUSINESS_ADDRESS;
entity.CUSTOMER_SPOUSE_DOB = tcamodel.CUSTOMER_SPOUSE_DOB;
entity.OTHER_SOURCE_EXPECT_ANN_INC = tcamodel.OTHER_SOURCE_EXPECT_ANN_INC;
entity.CUSTOMER_BUSINESS_NAME = tcamodel.CUSTOMER_BUSINESS_NAME;
entity.CUSTOMER_SPOUSE_NAME = tcamodel.CUSTOMER_SPOUSE_NAME;
entity.CUSTOMER_SPOUSE_OCCUPATION = tcamodel.CUSTOMER_SPOUSE_OCCUPATION;
entity.CUSTOMER_BUSINESS_TYPE = tcamodel.CUSTOMER_BUSINESS_TYPE;
entity.SOURCES_OF_FUND_TO_ACCOUNT = tcamodel.SOURCES_OF_FUND_TO_ACCOUNT;
entity.BRANCH_CODE = tcamodel.BRANCH_CODE;
entity.QUEUE_STATUS = 1;
entity.LAST_MODIFIED_BY = identity.ProfileId.ToString();
entity.LAST_MODIFIED_DATE = DateTime.Now;
//entity.AUTHORISED = "U";
db.CDMA_TRUSTS_CLIENT_ACCOUNTS.Attach(entity);
db.Entry(entity).State = EntityState.Modified;
db.SaveChanges(identity.ProfileId.ToString(), tcamodel.CUSTOMER_NO, updateFlag, originalObject);
_messageService.LogEmailJob(identity.ProfileId, entity.CUSTOMER_NO, MessageJobEnum.MailType.Change);
}
}
else if (records == 1)
{
updateFlag = false;
var entity = db.CDMA_TRUSTS_CLIENT_ACCOUNTS.FirstOrDefault(o => o.CUSTOMER_NO == tcamodel.CUSTOMER_NO && o.AUTHORISED == "A");
originalObject = _db.CDMA_TRUSTS_CLIENT_ACCOUNTS.Where(o => o.CUSTOMER_NO == tcamodel.CUSTOMER_NO && o.AUTHORISED == "A").FirstOrDefault();
if (originalObject != null)
{
entity.CUSTOMER_BUSINESS_ADDRESS = tcamodel.CUSTOMER_BUSINESS_ADDRESS;
entity.CUSTOMER_SPOUSE_DOB = tcamodel.CUSTOMER_SPOUSE_DOB;
entity.OTHER_SOURCE_EXPECT_ANN_INC = tcamodel.OTHER_SOURCE_EXPECT_ANN_INC;
entity.CUSTOMER_BUSINESS_NAME = tcamodel.CUSTOMER_BUSINESS_NAME;
entity.CUSTOMER_SPOUSE_NAME = tcamodel.CUSTOMER_SPOUSE_NAME;
entity.CUSTOMER_SPOUSE_OCCUPATION = tcamodel.CUSTOMER_SPOUSE_OCCUPATION;
entity.CUSTOMER_BUSINESS_TYPE = tcamodel.CUSTOMER_BUSINESS_TYPE;
entity.SOURCES_OF_FUND_TO_ACCOUNT = tcamodel.SOURCES_OF_FUND_TO_ACCOUNT;
entity.BRANCH_CODE = tcamodel.BRANCH_CODE;
entity.QUEUE_STATUS = 1;
entity.LAST_MODIFIED_BY = identity.ProfileId.ToString();
entity.LAST_MODIFIED_DATE = DateTime.Now;
//entity.AUTHORISED = "U";
db.CDMA_TRUSTS_CLIENT_ACCOUNTS.Attach(entity);
db.Entry(entity).State = EntityState.Modified;
db.SaveChanges(identity.ProfileId.ToString(), tcamodel.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_TRUSTS_CLIENT_ACCOUNTS();
newentity.CUSTOMER_BUSINESS_ADDRESS = tcamodel.CUSTOMER_BUSINESS_ADDRESS;
newentity.CUSTOMER_SPOUSE_DOB = tcamodel.CUSTOMER_SPOUSE_DOB;
newentity.OTHER_SOURCE_EXPECT_ANN_INC = tcamodel.OTHER_SOURCE_EXPECT_ANN_INC;
newentity.CUSTOMER_BUSINESS_NAME = tcamodel.CUSTOMER_BUSINESS_NAME;
newentity.CUSTOMER_SPOUSE_NAME = tcamodel.CUSTOMER_SPOUSE_NAME;
newentity.CUSTOMER_SPOUSE_OCCUPATION = tcamodel.CUSTOMER_SPOUSE_OCCUPATION;
newentity.CUSTOMER_BUSINESS_TYPE = tcamodel.CUSTOMER_BUSINESS_TYPE;
newentity.SOURCES_OF_FUND_TO_ACCOUNT = tcamodel.SOURCES_OF_FUND_TO_ACCOUNT;
newentity.BRANCH_CODE = tcamodel.BRANCH_CODE;
newentity.QUEUE_STATUS = 1;
newentity.LAST_MODIFIED_BY = identity.ProfileId.ToString();
newentity.LAST_MODIFIED_DATE = DateTime.Now;
newentity.AUTHORISED = "U";
newentity.CUSTOMER_NO = tcamodel.CUSTOMER_NO;
db.CDMA_TRUSTS_CLIENT_ACCOUNTS.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.", tcamodel.CUSTOMER_NO);
ModelState.AddModelError("", errorMessage);
}
}
}
SuccessNotification("Trust Clients Updated");
return(continueEditing ? RedirectToAction("Edit", new { id = tcamodel.CUSTOMER_NO }) : RedirectToAction("Index", "DQQue"));
//return RedirectToAction("Index");
}
PrepareModel(tcamodel);
return(View(tcamodel));
}
