public int DeleteInterDP(int intprikey)
{
try
{
SingleEntities db = new SingleEntities();
Interdepository obj = db.Interdepositories.Where(x => x.id_pri_key == intprikey).FirstOrDefault();
Backoffice_audit obj1 = new Backoffice_audit();
Backoffice_delete obj2 = new Backoffice_delete();
obj1.ba_branchcd = obj.id_branchcd;
obj1.ba_computername = "";
obj1.ba_pri_key = obj.id_pri_key;
obj1.ba_trx_type = obj.id_trxtype;
obj2.bd_authcode1 = obj.id_authcode1;
obj2.bd_authcode2 = obj.id_authcode2;
obj2.bd_authcode3 = obj.id_authcode3;
obj2.bd_authdt1 = obj.id_authdate1;
obj2.bd_authdt2 = obj.id_authdate2;
obj2.bd_authdt3 = obj.id_authdt3;
obj2.bd_authremarks = obj.id_authremarks;
obj2.bd_branchcd = obj.id_branchcd;
obj2.bd_client_id = obj.id_clientid;
obj2.bd_execution_date = obj.id_executiondate;
obj2.bd_instdesc = obj.id_instreceivemode;
obj2.bd_internal_refno = obj.id_internalrefno;
obj2.bd_isin = obj.id_isin;
obj2.bd_trx_type = obj.id_trxtype;
obj2.bd_trx_date = obj.id_trxdate;
obj2.bd_trx_allow = obj.id_allow;
obj2.bd_scrollno = obj.id_scrollno;
db.Backoffice_audit.Add(obj1);
db.Backoffice_delete.Add(obj2);
db.Interdepositories.Remove(obj);
return db.SaveChanges();
}
catch (Exception)
{
return 0;
}
}
public void add(BackofficeAudit obj)
{
Backoffice_audit obj1 = new Backoffice_audit();
obj1.ba_trx_type = obj.ba_trx_type;
obj1.ba_pri_key = obj.ba_pri_key;
obj1.ba_branchcd = obj.ba_branchcd;
obj1.ba_field = obj.ba_field;
obj1.ba_oldvalue = obj.ba_oldvalue;
obj1.ba_newvalue = obj.ba_newvalue;
obj1.mkrid = obj.mkrid;
obj1.mkrdt = obj.mkrdt;
obj1.ba_computername = obj.ba_computername;
obj1.mkrtm = obj.mkrtm;
obj1.ba_delunique = obj.ba_delunique;
obj1.mkrtmold = obj.mkrtmold;
obj1.mkridold = obj.mkridold;
obj1.mkrdtold = obj.mkrdtold;
SingleEntities db = new SingleEntities();
db.Backoffice_audit.Add(obj1);
db.SaveChanges();
}
