public ActionResult Create(CustomerNOKModel nokmodel, bool continueEditing)
{
//if (!_permissionService.Authorize(StandardPermissionProvider.ManageStores))
// return AccessDeniedView();
if (!User.Identity.IsAuthenticated)
{
return(AccessDeniedView());
}
var identity = ((CustomPrincipal)User).CustomIdentity;
if (ModelState.IsValid)
{
CDMA_INDIVIDUAL_NEXT_OF_KIN nok = new CDMA_INDIVIDUAL_NEXT_OF_KIN
{
};
_db.CDMA_INDIVIDUAL_NEXT_OF_KIN.Add(nok);
_db.SaveChanges();
//_localizationService.GetResource("Admin.Configuration.Stores.Added")
SuccessNotification("New NOK has been Added");
//do activity log
return(continueEditing ? RedirectToAction("Edit", new { id = nokmodel.CUSTOMER_NO }) : RedirectToAction("Index"));
//return RedirectToAction("Index");
}
PrepareModel(nokmodel);
return(View(nokmodel));
}
public ActionResult DeleteConfirmed(string id)
{
CDMA_INDIVIDUAL_NEXT_OF_KIN cDMA_INDIVIDUAL_NEXT_OF_KIN = _db.CDMA_INDIVIDUAL_NEXT_OF_KIN.Find(id);
_db.CDMA_INDIVIDUAL_NEXT_OF_KIN.Remove(cDMA_INDIVIDUAL_NEXT_OF_KIN);
_db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: CustNok/Delete/5
public ActionResult Delete(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CDMA_INDIVIDUAL_NEXT_OF_KIN cDMA_INDIVIDUAL_NEXT_OF_KIN = _db.CDMA_INDIVIDUAL_NEXT_OF_KIN.Find(id);
if (cDMA_INDIVIDUAL_NEXT_OF_KIN == null)
{
return(HttpNotFound());
}
return(View(cDMA_INDIVIDUAL_NEXT_OF_KIN));
}
public ActionResult Edit_Scaffold([Bind(Include = "CUSTOMER_NO,TITLE,SURNAME,FIRST_NAME,OTHER_NAME,DATE_OF_BIRTH,SEX,RELATIONSHIP,OFFICE_NO,MOBILE_NO,EMAIL_ADDRESS,HOUSE_NUMBER,IDENTIFICATION_TYPE,ID_EXPIRY_DATE,ID_ISSUE_DATE,RESIDENT_PERMIT_NUMBER,PLACE_OF_ISSUANCE,STREET_NAME,NEAREST_BUS_STOP_LANDMARK,CITY_TOWN,LGA,ZIP_POSTAL_CODE,STATE,COUNTRY,CREATED_DATE,CREATED_BY,LAST_MODIFIED_DATE,LAST_MODIFIED_BY,AUTHORISED,AUTHORISED_BY,AUTHORISED_DATE,IP_ADDRESS,BRANCH_CODE")] CDMA_INDIVIDUAL_NEXT_OF_KIN cDMA_INDIVIDUAL_NEXT_OF_KIN)
{
if (ModelState.IsValid)
{
_db.Entry(cDMA_INDIVIDUAL_NEXT_OF_KIN).State = EntityState.Modified;
_db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.LGA = new SelectList(_db.SRC_CDMA_LGA, "LGA_ID", "LGA_NAME", cDMA_INDIVIDUAL_NEXT_OF_KIN.LGA);
ViewBag.RELATIONSHIP = new SelectList(_db.CDMA_CUST_REL_TYPE, "REL_CODE", "REL_DESC", cDMA_INDIVIDUAL_NEXT_OF_KIN.RELATIONSHIP);
ViewBag.STATE = new SelectList(_db.SRC_CDMA_STATE, "STATE_ID", "STATE_NAME", cDMA_INDIVIDUAL_NEXT_OF_KIN.STATE);
ViewBag.TITLE = new SelectList(_db.CDMA_CUST_TITLE, "TITLE_CODE", "TITLE_DESC", cDMA_INDIVIDUAL_NEXT_OF_KIN.TITLE);
return(View(cDMA_INDIVIDUAL_NEXT_OF_KIN));
}
// GET: CustNok/Edit/5
public ActionResult Edit_(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CDMA_INDIVIDUAL_NEXT_OF_KIN cDMA_INDIVIDUAL_NEXT_OF_KIN = _db.CDMA_INDIVIDUAL_NEXT_OF_KIN.Find(id);
if (cDMA_INDIVIDUAL_NEXT_OF_KIN == null)
{
return(HttpNotFound());
}
ViewBag.LGA = new SelectList(_db.SRC_CDMA_LGA, "LGA_ID", "LGA_NAME", cDMA_INDIVIDUAL_NEXT_OF_KIN.LGA);
ViewBag.RELATIONSHIP = new SelectList(_db.CDMA_CUST_REL_TYPE, "REL_CODE", "REL_DESC", cDMA_INDIVIDUAL_NEXT_OF_KIN.RELATIONSHIP);
ViewBag.STATE = new SelectList(_db.SRC_CDMA_STATE, "STATE_ID", "STATE_NAME", cDMA_INDIVIDUAL_NEXT_OF_KIN.STATE);
ViewBag.TITLE = new SelectList(_db.CDMA_CUST_TITLE, "TITLE_CODE", "TITLE_DESC", cDMA_INDIVIDUAL_NEXT_OF_KIN.TITLE);
return(View(cDMA_INDIVIDUAL_NEXT_OF_KIN));
}
public ActionResult Edit(CustomerNOKModel nokmodel, bool continueEditing)
{
if (!User.Identity.IsAuthenticated)
{
return(AccessDeniedView());
}
var identity = ((CustomPrincipal)User).CustomIdentity;
bool updateFlag = false;
if (ModelState.IsValid)
{
CDMA_INDIVIDUAL_NEXT_OF_KIN originalObject = new CDMA_INDIVIDUAL_NEXT_OF_KIN();
using (var db = new AppDbContext())
{
int records = db.CDMA_INDIVIDUAL_NEXT_OF_KIN.Count(o => o.CUSTOMER_NO == nokmodel.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_INDIVIDUAL_NEXT_OF_KIN.Where(o => o.CUSTOMER_NO == nokmodel.CUSTOMER_NO && o.AUTHORISED == "U").FirstOrDefault();
var entity = db.CDMA_INDIVIDUAL_NEXT_OF_KIN.FirstOrDefault(o => o.CUSTOMER_NO == nokmodel.CUSTOMER_NO && o.AUTHORISED == "U");
if (entity != null)
{
entity.TITLE = nokmodel.TITLE;
entity.SURNAME = nokmodel.SURNAME;
entity.FIRST_NAME = nokmodel.FIRST_NAME;
entity.OTHER_NAME = nokmodel.OTHER_NAME;
entity.DATE_OF_BIRTH = nokmodel.DATE_OF_BIRTH;
entity.SEX = nokmodel.SEX;
entity.RELATIONSHIP = nokmodel.RELATIONSHIP;
entity.EMAIL_ADDRESS = nokmodel.EMAIL_ADDRESS;
entity.NEXT_OF_KIN_RESIDENTIALSTREET = nokmodel.NEXT_OF_KIN_RESIDENTIALSTREET;
entity.NOK_ADDRESS_NO = nokmodel.NOK_ADDRESS_NO;
entity.CITY_TOWN = nokmodel.CITY_TOWN;
entity.LGA = nokmodel.LGA;
entity.NEAREST_BUS_STOP_LANDMARK = nokmodel.NEAREST_BUS_STOP_LANDMARK;
entity.STATE = nokmodel.STATE;
entity.NEXT_OF_KIN_PHONE_NUMBER = nokmodel.NEXT_OF_KIN_PHONE_NUMBER;
entity.NEXT_OF_KIN_PHONE_NUMBER2 = nokmodel.NEXT_OF_KIN_PHONE_NUMBER2;
entity.BRANCH_CODE = nokmodel.BRANCH_CODE;
entity.QUEUE_STATUS = 1;
entity.LAST_MODIFIED_BY = identity.ProfileId.ToString();
entity.LAST_MODIFIED_DATE = DateTime.Now;
//entity.AUTHORISED = "U";
db.CDMA_INDIVIDUAL_NEXT_OF_KIN.Attach(entity);
db.Entry(entity).State = EntityState.Modified;
db.SaveChanges(identity.ProfileId.ToString(), nokmodel.CUSTOMER_NO, updateFlag, originalObject);
_messageService.LogEmailJob(identity.ProfileId, entity.CUSTOMER_NO, MessageJobEnum.MailType.Change);
}
}
else if (records == 1)
{
updateFlag = false;
var entity = db.CDMA_INDIVIDUAL_NEXT_OF_KIN.FirstOrDefault(o => o.CUSTOMER_NO == nokmodel.CUSTOMER_NO && o.AUTHORISED == "A");
originalObject = _db.CDMA_INDIVIDUAL_NEXT_OF_KIN.Where(o => o.CUSTOMER_NO == nokmodel.CUSTOMER_NO && o.AUTHORISED == "A").FirstOrDefault();
if (originalObject != null)
{
entity.TITLE = nokmodel.TITLE;
entity.SURNAME = nokmodel.SURNAME;
entity.FIRST_NAME = nokmodel.FIRST_NAME;
entity.OTHER_NAME = nokmodel.OTHER_NAME;
entity.DATE_OF_BIRTH = nokmodel.DATE_OF_BIRTH;
entity.SEX = nokmodel.SEX;
entity.RELATIONSHIP = nokmodel.RELATIONSHIP;
entity.EMAIL_ADDRESS = nokmodel.EMAIL_ADDRESS;
entity.NEXT_OF_KIN_RESIDENTIALSTREET = nokmodel.NEXT_OF_KIN_RESIDENTIALSTREET;
entity.NOK_ADDRESS_NO = nokmodel.NOK_ADDRESS_NO;
entity.CITY_TOWN = nokmodel.CITY_TOWN;
entity.LGA = nokmodel.LGA;
entity.NEAREST_BUS_STOP_LANDMARK = nokmodel.NEAREST_BUS_STOP_LANDMARK;
entity.STATE = nokmodel.STATE;
entity.NEXT_OF_KIN_PHONE_NUMBER = nokmodel.NEXT_OF_KIN_PHONE_NUMBER;
entity.NEXT_OF_KIN_PHONE_NUMBER2 = nokmodel.NEXT_OF_KIN_PHONE_NUMBER2;
entity.BRANCH_CODE = nokmodel.BRANCH_CODE;
entity.QUEUE_STATUS = 1;
entity.LAST_MODIFIED_BY = identity.ProfileId.ToString();
entity.LAST_MODIFIED_DATE = DateTime.Now;
entity.NEAREST_BUS_STOP_LANDMARK = nokmodel.NEAREST_BUS_STOP_LANDMARK;
//entity.AUTHORISED = "U";
//
db.CDMA_INDIVIDUAL_NEXT_OF_KIN.Attach(entity);
db.Entry(entity).State = EntityState.Modified;
db.SaveChanges(identity.ProfileId.ToString(), nokmodel.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_INDIVIDUAL_NEXT_OF_KIN();
newentity.TITLE = nokmodel.TITLE;
newentity.SURNAME = nokmodel.SURNAME;
newentity.FIRST_NAME = nokmodel.FIRST_NAME;
newentity.OTHER_NAME = nokmodel.OTHER_NAME;
newentity.DATE_OF_BIRTH = nokmodel.DATE_OF_BIRTH;
newentity.SEX = nokmodel.SEX;
newentity.RELATIONSHIP = nokmodel.RELATIONSHIP;
newentity.EMAIL_ADDRESS = nokmodel.EMAIL_ADDRESS;
newentity.NEXT_OF_KIN_RESIDENTIALSTREET = nokmodel.NEXT_OF_KIN_RESIDENTIALSTREET;
newentity.NOK_ADDRESS_NO = nokmodel.NOK_ADDRESS_NO;
newentity.CITY_TOWN = nokmodel.CITY_TOWN;
newentity.LGA = nokmodel.LGA;
newentity.NEAREST_BUS_STOP_LANDMARK = nokmodel.NEAREST_BUS_STOP_LANDMARK;
newentity.STATE = nokmodel.STATE;
newentity.NEXT_OF_KIN_PHONE_NUMBER = nokmodel.NEXT_OF_KIN_PHONE_NUMBER;
newentity.NEXT_OF_KIN_PHONE_NUMBER2 = nokmodel.NEXT_OF_KIN_PHONE_NUMBER2;
newentity.BRANCH_CODE = nokmodel.BRANCH_CODE;
newentity.QUEUE_STATUS = 1;
newentity.CREATED_BY = identity.ProfileId.ToString();
newentity.CREATED_DATE = DateTime.Now;
newentity.AUTHORISED = "U";
newentity.CUSTOMER_NO = nokmodel.CUSTOMER_NO;
newentity.NEAREST_BUS_STOP_LANDMARK = nokmodel.NEAREST_BUS_STOP_LANDMARK;
db.CDMA_INDIVIDUAL_NEXT_OF_KIN.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.", nokmodel.CUSTOMER_NO);
ModelState.AddModelError("", errorMessage);
}
}
}
SuccessNotification("Next of Kin Updated");
return(continueEditing ? RedirectToAction("Edit", new { id = nokmodel.CUSTOMER_NO }) : RedirectToAction("Index", "DQQue"));
//return RedirectToAction("Index");
}
PrepareModel(nokmodel);
return(View(nokmodel));
}
