public void add(BackofficeDelete obj)
{
Backoffice_delete obj1 = new Backoffice_delete();
obj1.bd_instdesc = obj.bd_instdesc;
obj1.bd_trx_type = obj.bd_trx_type;
obj1.bd_trx_date = obj.bd_trx_date;
obj1.bd_client_id = obj.bd_client_id;
obj1.bd_isin = obj.bd_isin;
obj1.bd_qty = obj.bd_qty;
obj1.bd_market_type = obj.bd_market_type;
obj1.bd_settlement = obj.bd_settlement;
obj1.bd_execution_date = obj.bd_execution_date;
obj1.bd_other_dp_id = obj.bd_other_dp_id;
obj1.bd_other_client_id = obj.bd_other_client_id;
obj1.bd_other_cmbp_id = obj.bd_other_cmbp_id;
obj1.bd_internal_refno = obj.bd_internal_refno;
obj1.bd_other_markettype = obj.bd_other_markettype;
obj1.bd_other_settle_no = obj.bd_other_settle_no;
obj1.bd_lock_release_code = obj.bd_lock_release_code;
obj1.bd_lock_release_date = obj.bd_lock_release_date;
obj1.bd_cc_id1 = obj.bd_cc_id1;
obj1.bd_cc_id2 = obj.bd_cc_id2;
obj1.bd_status = obj.bd_status;
obj1.bd_trx_allow = obj.bd_trx_allow;
obj1.bd_pri_key = obj.bd_pri_key;
obj1.bd_authcode1 = obj.bd_authcode1;
obj1.bd_authuserid1 = obj.bd_authuserid1;
obj1.bd_authdt1 = obj.bd_authdt1;
obj1.bd_authcode2 = obj.bd_authcode2;
obj1.bd_authuserid2 = obj.bd_authuserid2;
obj1.bd_authdt2 = obj.bd_authdt2;
obj1.bd_branchcd = obj.bd_branchcd;
obj1.bd_branchbatchcd = obj.bd_branchbatchcd;
obj1.mkrid = obj.mkrid;
obj1.mkrdt = obj.mkrdt;
obj1.bd_authcode3 = obj.bd_authcode3;
obj1.bd_authuserid3 = obj.bd_authuserid3;
obj1.bd_authdt3 = obj.bd_authdt3;
obj1.bd_authremarks = obj.bd_authremarks;
obj1.bd_scrollno = obj.bd_scrollno;
obj1.bd_totalcertificate = obj.bd_totalcertificate;
obj1.bd_computername = obj.bd_computername;
obj1.mkrtm = obj.mkrtm;
obj1.bd_unique = obj.bd_unique;
obj1.mkrtmold = obj.mkrtmold;
obj1.mkridold = obj.mkridold;
obj1.bd_authtm1 = obj.bd_authtm1;
obj1.bd_authtm2 = obj.bd_authtm2;
obj1.bd_authtm3 = obj.bd_authtm3;
obj1.mkrdtold = obj.mkrdtold;
SingleEntities db = new SingleEntities();
db.Backoffice_delete.Add(obj1);
db.SaveChanges();
}
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;
}
}