public ActionResult DeleteConfirmed(string id)
{
CDMA_FOREIGN_DETAILS cDMA_FOREIGN_DETAILS = _db.CDMA_FOREIGN_DETAILS.Find(id);
_db.CDMA_FOREIGN_DETAILS.Remove(cDMA_FOREIGN_DETAILS);
_db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit_1([Bind(Include = "CUSTOMER_NO,FOREIGNER,PASSPORT_RESIDENCE_PERMIT,PERMIT_ISSUE_DATE,PERMIT_EXPIRY_DATE,FOREIGN_ADDRESS,CITY,COUNTRY,ZIP_POSTAL_CODE,FOREIGN_TEL_NUMBER,PURPOSE_OF_ACCOUNT,CREATED_DATE,CREATED_BY,LAST_MODIFIED_DATE,LAST_MODIFIED_BY,AUTHORISED,AUTHORISED_BY,AUTHORISED_DATE,IP_ADDRESS,MULTIPLE_CITEZENSHIP")] CDMA_FOREIGN_DETAILS cDMA_FOREIGN_DETAILS)
{
if (ModelState.IsValid)
{
_db.Entry(cDMA_FOREIGN_DETAILS).State = EntityState.Modified;
_db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(cDMA_FOREIGN_DETAILS));
}
// GET: CustForeigner/Delete/5
public ActionResult Delete(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CDMA_FOREIGN_DETAILS cDMA_FOREIGN_DETAILS = _db.CDMA_FOREIGN_DETAILS.Find(id);
if (cDMA_FOREIGN_DETAILS == null)
{
return(HttpNotFound());
}
return(View(cDMA_FOREIGN_DETAILS));
}
public ActionResult Create(CustomerForeignerModel formodel, 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_FOREIGN_DETAILS ford = new CDMA_FOREIGN_DETAILS
{
CUSTOMER_NO = formodel.CUSTOMER_NO,
FOREIGNER = formodel.FOREIGNER,
PASSPORT_RESIDENCE_PERMIT = formodel.PASSPORT_RESIDENCE_PERMIT,
PERMIT_ISSUE_DATE = formodel.PERMIT_ISSUE_DATE,
PERMIT_EXPIRY_DATE = formodel.PERMIT_EXPIRY_DATE,
FOREIGN_ADDRESS = formodel.FOREIGN_ADDRESS,
CITY = formodel.CITY,
COUNTRY = formodel.COUNTRY,
ZIP_POSTAL_CODE = formodel.ZIP_POSTAL_CODE,
FOREIGN_TEL_NUMBER = formodel.FOREIGN_TEL_NUMBER,
PURPOSE_OF_ACCOUNT = formodel.PURPOSE_OF_ACCOUNT,
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,
MULTIPLE_CITEZENSHIP = formodel.MULTIPLE_CITEZENSHIP
};
_db.CDMA_FOREIGN_DETAILS.Add(ford);
_db.SaveChanges();
//_localizationService.GetResource("Admin.Configuration.Stores.Added")
SuccessNotification("New FORD has been Added");
//do activity log
return(continueEditing ? RedirectToAction("Edit", new { id = formodel.CUSTOMER_NO }) : RedirectToAction("Create"));
//return RedirectToAction("Index");
}
PrepareModel(formodel);
return(View(formodel));
}
public ActionResult Edit(CustomerForeignerModel formodel, bool continueEditing)
{
if (!User.Identity.IsAuthenticated)
{
return(AccessDeniedView());
}
var identity = ((CustomPrincipal)User).CustomIdentity;
bool updateFlag = false;
if (ModelState.IsValid)
{
CDMA_FOREIGN_DETAILS originalObject = new CDMA_FOREIGN_DETAILS();
using (var db = new AppDbContext())
{
int records = db.CDMA_FOREIGN_DETAILS.Count(o => o.CUSTOMER_NO == formodel.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_FOREIGN_DETAILS.Where(o => o.CUSTOMER_NO == formodel.CUSTOMER_NO && o.AUTHORISED == "U").FirstOrDefault();
var entity = db.CDMA_FOREIGN_DETAILS.FirstOrDefault(o => o.CUSTOMER_NO == formodel.CUSTOMER_NO && o.AUTHORISED == "U");
if (entity != null)
{
entity.FOREIGNER = formodel.FOREIGNER;
entity.PASSPORT_RESIDENCE_PERMIT = formodel.PASSPORT_RESIDENCE_PERMIT;
entity.COUNTRY = formodel.COUNTRY;
entity.PERMIT_ISSUE_DATE = formodel.PERMIT_ISSUE_DATE;
entity.PERMIT_EXPIRY_DATE = formodel.PERMIT_EXPIRY_DATE;
entity.FOREIGN_ADDRESS = formodel.FOREIGN_ADDRESS;
entity.CITY = formodel.CITY;
entity.COUNTRY = formodel.COUNTRY;
entity.ZIP_POSTAL_CODE = formodel.ZIP_POSTAL_CODE;
entity.FOREIGN_TEL_NUMBER = formodel.FOREIGN_TEL_NUMBER;
entity.PURPOSE_OF_ACCOUNT = formodel.PURPOSE_OF_ACCOUNT;
entity.MULTIPLE_CITEZENSHIP = formodel.MULTIPLE_CITEZENSHIP;
entity.LAST_MODIFIED_BY = identity.ProfileId.ToString();
entity.LAST_MODIFIED_DATE = DateTime.Now;
db.CDMA_FOREIGN_DETAILS.Attach(entity);
db.Entry(entity).State = EntityState.Modified;
db.SaveChanges(identity.ProfileId.ToString(), formodel.CUSTOMER_NO, updateFlag, originalObject);
_messageService.LogEmailJob(identity.ProfileId, entity.CUSTOMER_NO, MessageJobEnum.MailType.Change);
}
}
else if (records == 1)
{
updateFlag = false;
var entity = db.CDMA_FOREIGN_DETAILS.FirstOrDefault(o => o.CUSTOMER_NO == formodel.CUSTOMER_NO && o.AUTHORISED == "A");
originalObject = _db.CDMA_FOREIGN_DETAILS.Where(o => o.CUSTOMER_NO == formodel.CUSTOMER_NO && o.AUTHORISED == "A").FirstOrDefault();
if (originalObject != null)
{
entity.FOREIGNER = formodel.FOREIGNER;
entity.PASSPORT_RESIDENCE_PERMIT = formodel.PASSPORT_RESIDENCE_PERMIT;
entity.COUNTRY = formodel.COUNTRY;
entity.PERMIT_ISSUE_DATE = formodel.PERMIT_ISSUE_DATE;
entity.PERMIT_EXPIRY_DATE = formodel.PERMIT_EXPIRY_DATE;
entity.FOREIGN_ADDRESS = formodel.FOREIGN_ADDRESS;
entity.CITY = formodel.CITY;
entity.COUNTRY = formodel.COUNTRY;
entity.ZIP_POSTAL_CODE = formodel.ZIP_POSTAL_CODE;
entity.FOREIGN_TEL_NUMBER = formodel.FOREIGN_TEL_NUMBER;
entity.PURPOSE_OF_ACCOUNT = formodel.PURPOSE_OF_ACCOUNT;
entity.MULTIPLE_CITEZENSHIP = formodel.MULTIPLE_CITEZENSHIP;
entity.LAST_MODIFIED_BY = identity.ProfileId.ToString();
entity.LAST_MODIFIED_DATE = DateTime.Now;
db.CDMA_FOREIGN_DETAILS.Attach(entity);
db.Entry(entity).State = EntityState.Modified;
db.SaveChanges(identity.ProfileId.ToString(), formodel.CUSTOMER_NO, updateFlag, originalObject);
var newentity = new CDMA_FOREIGN_DETAILS();
newentity.FOREIGNER = formodel.FOREIGNER;
newentity.PASSPORT_RESIDENCE_PERMIT = formodel.PASSPORT_RESIDENCE_PERMIT;
newentity.COUNTRY = formodel.COUNTRY;
newentity.PERMIT_ISSUE_DATE = formodel.PERMIT_ISSUE_DATE;
newentity.PERMIT_EXPIRY_DATE = formodel.PERMIT_EXPIRY_DATE;
newentity.FOREIGN_ADDRESS = formodel.FOREIGN_ADDRESS;
newentity.CITY = formodel.CITY;
newentity.COUNTRY = formodel.COUNTRY;
newentity.ZIP_POSTAL_CODE = formodel.ZIP_POSTAL_CODE;
newentity.FOREIGN_TEL_NUMBER = formodel.FOREIGN_TEL_NUMBER;
newentity.PURPOSE_OF_ACCOUNT = formodel.PURPOSE_OF_ACCOUNT;
newentity.MULTIPLE_CITEZENSHIP = formodel.MULTIPLE_CITEZENSHIP;
newentity.CREATED_BY = identity.ProfileId.ToString();
newentity.CREATED_DATE = DateTime.Now;
newentity.AUTHORISED = "U";
newentity.CUSTOMER_NO = formodel.CUSTOMER_NO;
db.CDMA_FOREIGN_DETAILS.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.", formodel.CUSTOMER_NO);
ModelState.AddModelError("", errorMessage);
}
}
}
SuccessNotification("FORD Updated");
return(continueEditing ? RedirectToAction("Edit", new { id = formodel.CUSTOMER_NO }) : RedirectToAction("Index", "DQQue"));
//return RedirectToAction("Index");
}
PrepareModel(formodel);
return(View(formodel));
}
