Ejemplo n.º 1
0
 public List<VendorDropDown> bookSizesList()
 {
     List<VendorDropDown> list = new List<VendorDropDown>();
     using (var db = new SingleEntities())
     {
         foreach (Book_size x in db.Book_size)
         {
             VendorDropDown obj = new VendorDropDown();
             obj.id = x.bk_size;
             obj.name = x.bk_size.ToString();
             list.Add(obj);
         }
     }
     return list;
 }
Ejemplo n.º 2
0
 public List<InstrumentDropDown> InstrumentList()
 {
     List<InstrumentDropDown> list = new List<InstrumentDropDown>();
     using (var db = new SingleEntities())
     {
         foreach (Instrument_master x in db.Instrument_master)
         {
             InstrumentDropDown obj = new InstrumentDropDown();
             obj.id = x.im_instcd;
             obj.name = x.im_desc;
             obj.im_trtype = x.im_trtype;
             obj.im_defaultyn = x.im_defaultyn;
             list.Add(obj);
         }
     }
     return list;
 }
Ejemplo n.º 3
0
 public List<LotSize> LotSizeList()
 {
     List<LotSize> list = new List<LotSize>();
     using (var db = new SingleEntities())
     {
         foreach(Lot_size x in db.Lot_size)
         {
             LotSize obj = new LotSize();
             obj.lz_lotno = x.lz_lotno;
             obj.lz_type=x.lz_type;
             obj.lz_size = x.lz_size;
             obj.lz_status = x.lz_status;
             obj.mkrid=x.mkrid;
             obj.mkrdt=x.mkrdt;
             list.Add(obj);
         }
     }
     return list;
 }
Ejemplo n.º 4
0
        public InterDepository GETInterDP(int int_pri_key)
        {
            try
            {
                SingleEntities db = new SingleEntities();
                Interdepository obj = db.Interdepositories.Where(x=>x.id_pri_key == int_pri_key).FirstOrDefault();
                InterDepository objIndp = new InterDepository();
                if(obj != null)
                {
                    objIndp.id_instcd = obj.id_instcd;
                    objIndp.id_trxdate = obj.id_trxdate;
                    objIndp.id_trxtype = obj.id_trxtype;
                    objIndp.id_trxflag = obj.id_trxflag;
                    objIndp.id_clientid = obj.id_clientid;
                    objIndp.id_isin = obj.id_isin;
                    objIndp.id_qty = obj.id_qty;
                    objIndp.id_mkttype = obj.id_mkttype;
                    objIndp.id_settlementno = obj.id_settlementno;
                    objIndp.id_executiondate = obj.id_executiondate;
                    objIndp.id_otherclientid = obj.id_otherclientid;
                    objIndp.id_otherdpid = obj.id_otherdpid;
                    objIndp.id_internalrefno = obj.id_internalrefno;
                    objIndp.id_cc_id = obj.id_cc_id;
                    objIndp.id_status = obj.id_status;
                    objIndp.id_allow = obj.id_allow;
                    objIndp.id_othersettlement = obj.id_othersettlement;
                    objIndp.id_authcode1 = obj.id_authcode1;
                    objIndp.id_authuserid1 = obj.id_authuserid1;
                    objIndp.id_authdate1 = obj.id_authdate1;
                    objIndp.id_authcode2 = obj.id_authcode2;
                    objIndp.id_authuserid2 = obj.id_authuserid2;
                    objIndp.id_authdate2 = obj.id_authdate2;
                    objIndp.id_batch_no = obj.id_batch_no;
                    //objIndp.id_pri_key = obj.id_pri_key;
                    objIndp.id_branchcd = obj.id_branchcd;
                    objIndp.id_branchbatchcd = obj.id_branchbatchcd;
                    objIndp.mkrid = obj.mkrid;
                    objIndp.mkrdt = obj.mkrdt;
                    objIndp.id_authcode3 = obj.id_authcode3;
                    objIndp.id_authuserid3 = obj.id_authuserid3;
                    objIndp.id_authdt3 = obj.id_authdt3;
                    objIndp.id_authremarks = obj.id_authremarks;
                    objIndp.id_scrollno = obj.id_scrollno;
                    objIndp.id_dqty = obj.id_dqty;
                    objIndp.id_lotno = obj.id_lotno;
                    objIndp.id_authtm1 = obj.id_authtm1;
                    objIndp.id_authtm2 = obj.id_authtm2;
                    objIndp.id_authtm3 = obj.id_authtm3;
                    objIndp.mkrtm = obj.mkrtm;
                    objIndp.id_instreceivemode = obj.id_instreceivemode;
                    objIndp.id_recoslipyn = obj.id_recoslipyn;
                    objIndp.id_entrymode = obj.id_entrymode;
                    objIndp.id_remarks = obj.id_remarks;
                    objIndp.id_CDSLsettlement = obj.id_CDSLsettlement;
                }

                return objIndp;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Ejemplo n.º 5
0
 public int UpdateInwardEntry(Inward obj)
 {
     try
     {
         SingleEntities db = new SingleEntities();
         Inward_entry objInw = db.Inward_entry.Where(x=>x.ie_scrollno == obj.ie_scrollno).First();
         objInw.ie_lotno = obj.ie_lotno;
         objInw.ie_trxtype = obj.ie_trxtype.Trim();
         objInw.ie_instno = obj.ie_instno.Trim();
         objInw.ie_slipno = obj.ie_slipno.Trim();
         objInw.ie_cmcd = obj.ie_cmcd.Trim();
         objInw.ie_dt = obj.ie_dt;
         objInw.ie_execdt = obj.ie_execdt;
         objInw.ie_nooftrx = obj.ie_nooftrx;
         objInw.ie_noofcert = obj.ie_noofcert;
         objInw.ie_rejected = obj.ie_rejected;
         objInw.mkrid = obj.mkrid.Trim();
         objInw.mkrdt = obj.mkrdt;
         objInw.ie_charge = obj.ie_charge;
         objInw.ie_mode = obj.ie_mode.Trim();
         objInw.ie_remark = obj.ie_remark.Trim();
         objInw.ie_pri_key = obj.ie_pri_key;
         objInw.ie_branchcd = obj.ie_branchcd.Trim();
         return db.SaveChanges();
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Ejemplo n.º 6
0
 public void UpdateLotSize(LotSize obj)
 {
     try
     {
         SingleEntities db = new SingleEntities();
         Lot_size objLot = db.Lot_size.First(x => x.lz_lotno == obj.lz_lotno && x.lz_type == obj.lz_type);
         //objLot.lz_status = obj.lz_status;
         db.SaveChanges();
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Ejemplo n.º 7
0
        public void GetRecievvedIn()
        {
            try
            {
                SingleEntities db = new SingleEntities();

            }
            catch (Exception ex)
            {

                throw ex;
            }
        }
Ejemplo n.º 8
0
 public DataSet GetSearchResult(string strModule, string strKey)
 {
     SingleEntities db = new SingleEntities();
     DataSet dsResult = new DataSet();
     switch (strModule)
     {
         case "ClientID":
             //dsResult = db.Client_master1.Select(x => {x.cm_cd , x.cm_na}).ToList();
             break;
         case "ClientName":
             break;
     }
     return dsResult;
 }
Ejemplo n.º 9
0
        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;

            }
        }
Ejemplo n.º 10
0
 public void AddCheque(ChequeMaster obj)
 {
     try
     {
         Chequemaster objCheque = new Chequemaster();
         objCheque.chm_cmcd = obj.companyCode;
         objCheque.chm_chqno = obj.chequeNo;
         objCheque.chm_instcd = obj.instrumentCode;
         objCheque.chm_booksize = obj.bookSize;
         objCheque.chm_refno = obj.refNo;
         objCheque.chm_refdate = obj.refDate;
         objCheque.chm_status = obj.status;
         objCheque.chm_issuedate = obj.issueDate;
         objCheque.chm_remarks = obj.remarks;
         objCheque.chm_branchcd = obj.branchCode;
         objCheque.mkrid = HttpContext.Current.Session["UserId"].ToString();
         objCheque.mkrdt = obj.makerDate;
         objCheque.chm_fromno = obj.chequeFromNo;
         objCheque.chm_tono = obj.chequeToNo;
         SingleEntities db = new SingleEntities();
         db.Chequemasters.Add(objCheque);
         db.SaveChanges();
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Ejemplo n.º 11
0
        public int AddInterDP(List<InterDepository> objs)
        {
            try
            {
                SingleEntities db = new SingleEntities();
                foreach (InterDepository obj in objs)
                {
                    Interdepository objIndp = new Interdepository();
                    objIndp.id_instcd = obj.id_instcd;
                    objIndp.id_trxdate = obj.id_trxdate;
                    objIndp.id_trxtype = obj.id_trxtype;
                    objIndp.id_trxflag = obj.id_trxflag;
                    objIndp.id_clientid = obj.id_clientid;
                    objIndp.id_isin = obj.id_isin;
                    objIndp.id_qty = obj.id_qty;
                    objIndp.id_mkttype = obj.id_mkttype;
                    objIndp.id_settlementno = obj.id_settlementno;
                    objIndp.id_executiondate = obj.id_executiondate;
                    objIndp.id_otherclientid = obj.id_otherclientid;
                    objIndp.id_otherdpid = obj.id_otherdpid;
                    objIndp.id_internalrefno = obj.id_internalrefno;
                    objIndp.id_cc_id = obj.id_cc_id;
                    objIndp.id_status = obj.id_status;
                    objIndp.id_allow = obj.id_allow;
                    objIndp.id_othersettlement = obj.id_othersettlement;
                    objIndp.id_authcode1 = obj.id_authcode1;
                    objIndp.id_authuserid1 = obj.id_authuserid1;
                    objIndp.id_authdate1 = obj.id_authdate1;
                    objIndp.id_authcode2 = obj.id_authcode2;
                    objIndp.id_authuserid2 = obj.id_authuserid2;
                    objIndp.id_authdate2 = obj.id_authdate2;
                    objIndp.id_batch_no = obj.id_batch_no;
                    //objIndp.id_pri_key = obj.id_pri_key;
                    objIndp.id_branchcd = obj.id_branchcd;
                    objIndp.id_branchbatchcd = obj.id_branchbatchcd;
                    objIndp.mkrid = obj.mkrid;
                    objIndp.mkrdt = obj.mkrdt;
                    objIndp.id_authcode3 = obj.id_authcode3;
                    objIndp.id_authuserid3 = obj.id_authuserid3;
                    objIndp.id_authdt3 = obj.id_authdt3;
                    objIndp.id_authremarks = obj.id_authremarks;
                    objIndp.id_scrollno = obj.id_scrollno;
                    objIndp.id_dqty = obj.id_dqty;
                    objIndp.id_lotno = obj.id_lotno;
                    objIndp.id_authtm1 = obj.id_authtm1;
                    objIndp.id_authtm2 = obj.id_authtm2;
                    objIndp.id_authtm3 = obj.id_authtm3;
                    objIndp.mkrtm = obj.mkrtm;
                    objIndp.id_instreceivemode = obj.id_instreceivemode;
                    objIndp.id_recoslipyn = obj.id_recoslipyn;
                    objIndp.id_entrymode = obj.id_entrymode;
                    objIndp.id_remarks = obj.id_remarks;
                    objIndp.id_CDSLsettlement = obj.id_CDSLsettlement;
                    db.Interdepositories.Add(objIndp);
                }

                return db.SaveChanges();
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Ejemplo n.º 12
0
 public List<VendorDropDown> VendorList()
 {
     List<VendorDropDown> list = new List<VendorDropDown>();
     using (var db = new SingleEntities())
     {
         foreach (Vendor_master x in db.Vendor_master)
         {
             VendorDropDown obj = new VendorDropDown();
             obj.id = x.vm_cd;
             obj.name = x.vm_name;
             list.Add(obj);
         }
     }
     return list;
 }
Ejemplo n.º 13
0
 public ChequeMaster GetCheque(int slipNo, int instrNo)
 {
     try
     {
         SingleEntities db = new SingleEntities();
         Chequemaster objCheque = new Chequemaster();
         var obj1 = db.Chequemasters.Where(x => x.chm_fromno == slipNo && x.chm_instcd == instrNo)
                     .Join(db.Client_master1, ch => ch.chm_cmcd, cl => cl.cm_cd, (ch, cl) => new { ch, cl })
                     .FirstOrDefault();
         if (obj1 != null)
         {
             objCheque = obj1.ch;
             ChequeMaster obj = new ChequeMaster();
             obj.companyCode = objCheque.chm_cmcd;
             obj.companyName = obj1.cl.cm_name;
             obj.secondName = obj1.cl.cm_sech_name;
             obj.thirdName = obj1.cl.cm_thih_name;
             obj.chequeNo = Convert.ToInt32(objCheque.chm_chqno);
             obj.instrumentCode = objCheque.chm_instcd;
             obj.bookSize = objCheque.chm_booksize;
             obj.refNo = objCheque.chm_refno;
             obj.refDate = objCheque.chm_refdate;
             obj.status = objCheque.chm_status;
             obj.issueDate = objCheque.chm_issuedate;
             obj.remarks = objCheque.chm_remarks;
             obj.branchCode = objCheque.chm_branchcd;
             obj.makerDate = objCheque.mkrdt;
             obj.chequeFromNo = Convert.ToInt32(objCheque.chm_fromno);
             obj.chequeToNo = Convert.ToInt32(objCheque.chm_tono);
             return obj;
         }
         else
         {
             return null;
         }
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Ejemplo n.º 14
0
 public int DeleteInward(int scrollNo)
 {
     SingleEntities db = new SingleEntities();
     int result = 0;
     Inward_entry obj = db.Inward_entry.Where(x => x.ie_scrollno == scrollNo).FirstOrDefault();
     if (obj != null) {
         db.Inward_entry.Remove(obj);
         result =  db.SaveChanges();
     }
     else
     {
         result = 0;
     }
     return result;
 }
Ejemplo n.º 15
0
        public void AddStockEntry(Stock obj)
        {
            try
            {

                Stock_master objStock = new Stock_master();
                objStock.stm_instcd = obj.intInstrumentCode;
                objStock.stm_vmcd = obj.intVendorCode;
                objStock.stm_vmrefno = obj.strRef;
                objStock.stm_date = obj.strRefDt;
                objStock.stm_fromno = obj.intSlipNoFrom;
                objStock.stm_tono = obj.intSlipTo;
                objStock.stm_booksize = obj.intSize;
                objStock.stm_noofbooks = obj.intBooks;
                objStock.stm_bookfromno = obj.intBookFrom;
                objStock.stm_booktono = obj.intBookTo;
                objStock.mkrid = HttpContext.Current.Session["UserId"].ToString();
                objStock.mkrdt = DateTime.Now.ToString("yyyyMMdd");
                //objStock.mkrid = GetMakerID(obj.intVendorCode);
                SingleEntities dbContext = new SingleEntities();
                dbContext.Stock_master.Add(objStock);
                dbContext.SaveChanges();
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Ejemplo n.º 16
0
 public void AddLotSize(LotSize obj)
 {
     try
     {
         Lot_size objLot = new Lot_size();
         objLot.lz_lotno = obj.lz_lotno;
         objLot.lz_size = obj.lz_size;
         objLot.lz_type = obj.lz_type;
         objLot.lz_status = obj.lz_status;
         objLot.mkrid = obj.mkrid;
         objLot.mkrdt = obj.mkrdt;
         objLot.lz_branchcd = obj.lz_branchcd;
         SingleEntities db = new SingleEntities();
         db.Lot_size.Add(objLot);
         db.SaveChanges();
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Ejemplo n.º 17
0
 public int AddInwardEntry(Inward obj)
 {
     try
     {
         Inward_entry objInw = new Inward_entry();
         objInw.ie_lotno = obj.ie_lotno;
         objInw.ie_trxtype = obj.ie_trxtype.Trim();
         objInw.ie_instno = obj.ie_instno.Trim();
         objInw.ie_slipno = obj.ie_slipno.Trim();
         objInw.ie_cmcd = obj.ie_cmcd.Trim();
         objInw.ie_dt = obj.ie_dt;
         objInw.ie_execdt = obj.ie_execdt;
         objInw.ie_nooftrx = obj.ie_nooftrx;
         objInw.ie_noofcert = obj.ie_noofcert;
         objInw.ie_rejected = obj.ie_rejected;
         objInw.mkrid = obj.mkrid;
         objInw.mkrdt = obj.mkrdt;
         objInw.ie_charge = obj.ie_charge;
         objInw.ie_mode = obj.ie_mode;
         objInw.ie_remark = obj.ie_remark.Trim();
         objInw.ie_pri_key = obj.ie_pri_key;
         objInw.ie_branchcd = obj.ie_branchcd;
         SingleEntities db = new SingleEntities();
         db.Inward_entry.Add(objInw);
         return db.SaveChanges();
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Ejemplo n.º 18
0
 public int GetInterDP(TrxbackofficeClass obj)
 {
     try
     {
         Trxbackoffice objTrxBO = new Trxbackoffice();
         objTrxBO.tb_pri_key = obj.tb_pri_key;
         objTrxBO.tb_internal_refno = obj.tb_internal_refno;
         objTrxBO.tb_instcd = obj.tb_instcd;
         objTrxBO.tb_trx_type = obj.tb_trx_type;
         objTrxBO.tb_trx_date = obj.tb_trx_date;
         objTrxBO.tb_trx_flag = obj.tb_trx_flag;
         objTrxBO.tb_client_id = obj.tb_client_id;
         objTrxBO.tb_isin = obj.tb_isin;
         objTrxBO.tb_qty = obj.tb_qty;
         objTrxBO.tb_market_type = obj.tb_market_type;
         objTrxBO.tb_settlement = obj.tb_settlement;
         objTrxBO.tb_exchangeid = obj.tb_exchangeid;
         objTrxBO.tb_chid = obj.tb_chid;
         objTrxBO.tb_other_dp_id = obj.tb_other_dp_id;
         objTrxBO.tb_other_client_id = obj.tb_other_client_id;
         objTrxBO.tb_other_cmbp_id = obj.tb_other_cmbp_id;
         objTrxBO.tb_other_markettype = obj.tb_other_markettype;
         objTrxBO.tb_other_settle_no = obj.tb_other_settle_no;
         objTrxBO.tb_br_code = obj.tb_br_code;
         objTrxBO.tb_reference = obj.tb_reference;
         objTrxBO.tb_irre_code1 = obj.tb_irre_code1;
         objTrxBO.tb_irre_code2 = obj.tb_irre_code2;
         objTrxBO.tb_irre_code3 = obj.tb_irre_code3;
         objTrxBO.tb_irre_code4 = obj.tb_irre_code4;
         objTrxBO.tb_br_pri_key = obj.tb_br_pri_key;
         objTrxBO.tb_status = obj.tb_status;
         objTrxBO.tb_trx_allow = obj.tb_trx_allow;
         objTrxBO.tb_authcode1 = obj.tb_authcode1;
         objTrxBO.tb_authuserid1 = obj.tb_authuserid1;
         objTrxBO.tb_authdt1 = obj.tb_authdt1;
         objTrxBO.tb_authcode2 = obj.tb_authcode2;
         objTrxBO.tb_authuserid2 = obj.tb_authuserid2;
         objTrxBO.tb_authdt2 = obj.tb_authdt2;
         objTrxBO.tb_batch_no = obj.tb_batch_no;
         objTrxBO.tb_branchcd = obj.tb_branchcd;
         objTrxBO.tb_branchbatchcd = obj.tb_branchbatchcd;
         objTrxBO.tb_cash = obj.tb_cash;
         objTrxBO.tb_reasfortrade = obj.tb_reasfortrade;
         objTrxBO.tb_rejreason = obj.tb_rejreason;
         objTrxBO.mkrid = obj.mkrid;
         objTrxBO.mkrdt = obj.mkrdt;
         objTrxBO.tb_authcode3 = obj.tb_authcode3;
         objTrxBO.tb_authuserid3 = obj.tb_authuserid3;
         objTrxBO.tb_authdt3 = obj.tb_authdt3;
         objTrxBO.tb_authremarks = obj.tb_authremarks;
         objTrxBO.tb_scrollno = obj.tb_scrollno;
         objTrxBO.tb_obligationid = obj.tb_obligationid;
         objTrxBO.tb_serialno = obj.tb_serialno;
         objTrxBO.tb_tradeno = obj.tb_tradeno;
         objTrxBO.tb_exec_date = obj.tb_exec_date;
         objTrxBO.tb_remark = obj.tb_remark;
         objTrxBO.mkrtm = obj.mkrtm;
         objTrxBO.tb_authtm1 = obj.tb_authtm1;
         objTrxBO.tb_authtm2 = obj.tb_authtm2;
         objTrxBO.tb_authtm3 = obj.tb_authtm3;
         objTrxBO.tb_instreceivemode = obj.tb_instreceivemode;
         objTrxBO.tb_recoslipyn = obj.tb_recoslipyn;
         objTrxBO.tb_entrymode = obj.tb_entrymode;
         objTrxBO.tb_lotno = obj.tb_lotno;
         SingleEntities db = new SingleEntities();
         db.Trxbackoffices.Add(objTrxBO);
         return db.SaveChanges();
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Ejemplo n.º 19
0
        public Inward GetInwardEntry(int scrollNo)
        {
            try
            {
                Inward_entry obj = new Inward_entry();

                SingleEntities db = new SingleEntities();
                obj = db.Inward_entry.Where(x => x.ie_scrollno == scrollNo).FirstOrDefault();
                if (obj != null)
                {
                    Inward objInw = new Inward();
                    objInw.ie_lotno = obj.ie_lotno;
                    objInw.ie_trxtype = obj.ie_trxtype;
                    objInw.ie_instno = obj.ie_instno;
                    objInw.ie_slipno = obj.ie_slipno;
                    objInw.ie_cmcd = obj.ie_cmcd;
                    objInw.ie_dt = obj.ie_dt;
                    objInw.ie_execdt = obj.ie_execdt;
                    objInw.ie_nooftrx = obj.ie_nooftrx;
                    objInw.ie_noofcert = obj.ie_noofcert;
                    objInw.ie_rejected = obj.ie_rejected;
                    objInw.ie_scrollno = obj.ie_scrollno;
                    objInw.mkrid = obj.mkrid;
                    objInw.mkrdt = obj.mkrdt;
                    objInw.ie_charge = obj.ie_charge;
                    objInw.ie_mode = obj.ie_mode;
                    objInw.ie_remark = obj.ie_remark;
                    objInw.ie_pri_key = obj.ie_pri_key;
                    objInw.ie_branchcd = obj.ie_branchcd;
                    return objInw;
                }
                else
                {
                    return null;
                }

            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Ejemplo n.º 20
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();
 }
Ejemplo n.º 21
0
        public LotSize GetLotSize(decimal lotNo, int instrNo)
        {
            try
            {
                SingleEntities db = new SingleEntities();
                Lot_size objCheque = new Lot_size();
                string insType = getInstype(instrNo);
                var obj = db.Lot_size.Where(x => x.lz_lotno == lotNo && x.lz_type == insType).FirstOrDefault();
                if (obj != null)
                {
                    LotSize obj1 = new LotSize();
                    obj1.lz_lotno = obj.lz_lotno;
                    obj1.lz_size = obj.lz_size;
                    obj1.lz_type = obj.lz_type;
                    obj1.lz_status = obj.lz_status;
                    obj1.mkrid = obj.mkrid;
                    obj1.mkrdt = obj.mkrdt;
                    obj1.lz_branchcd = obj.lz_branchcd;
                    return obj1;
                }
                else
                {
                    return null;
                }
            }
            catch (Exception ex)
            {

                throw ex;
            }
        }
Ejemplo n.º 22
0
 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();
 }
Ejemplo n.º 23
0
        public int AddBackOffice(BackOffice Obj)
        {
            try
            {

                Trxbackoffice ObjBO = new Trxbackoffice();
                ObjBO.tb_pri_key = Obj.tb_pri_key ;
                ObjBO.tb_internal_refno = Obj.tb_internal_refno ;
                ObjBO.tb_instcd = Obj.tb_instcd ;
                ObjBO.tb_trx_type = Obj.tb_trx_type ;
                ObjBO.tb_trx_date = Obj.tb_trx_date ;
                ObjBO.tb_trx_flag = Obj.tb_trx_flag ;
                ObjBO.tb_client_id = Obj.tb_client_id ;
                ObjBO.tb_isin = Obj.tb_isin ;
                ObjBO.tb_qty = Obj.tb_qty ;
                ObjBO.tb_market_type = Obj.tb_market_type ;
                ObjBO.tb_settlement = Obj.tb_settlement ;
                ObjBO.tb_exchangeid = Obj.tb_exchangeid ;
                ObjBO.tb_chid = Obj.tb_chid ;
                ObjBO.tb_other_dp_id = Obj.tb_other_dp_id ;
                ObjBO.tb_other_client_id = Obj.tb_other_client_id ;
                ObjBO.tb_other_cmbp_id = Obj.tb_other_cmbp_id ;
                ObjBO.tb_other_markettype = Obj.tb_other_markettype ;
                ObjBO.tb_other_settle_no = Obj.tb_other_settle_no ;
                ObjBO.tb_br_code = Obj.tb_br_code ;
                ObjBO.tb_reference = Obj.tb_reference ;
                ObjBO.tb_irre_code1 = Obj.tb_irre_code1 ;
                ObjBO.tb_irre_code2 = Obj.tb_irre_code2 ;
                ObjBO.tb_irre_code3 = Obj.tb_irre_code3 ;
                ObjBO.tb_irre_code4 = Obj.tb_irre_code4 ;
                ObjBO.tb_br_pri_key = Obj.tb_br_pri_key ;
                ObjBO.tb_status = Obj.tb_status ;
                ObjBO.tb_trx_allow = Obj.tb_trx_allow ;
                ObjBO.tb_authcode1 = Obj.tb_authcode1 ;
                ObjBO.tb_authuserid1 = Obj.tb_authuserid1 ;
                ObjBO.tb_authdt1 = Obj.tb_authdt1 ;
                ObjBO.tb_authcode2 = Obj.tb_authcode2 ;
                ObjBO.tb_authuserid2 = Obj.tb_authuserid2 ;
                ObjBO.tb_authdt2 = Obj.tb_authdt2 ;
                ObjBO.tb_batch_no = Obj.tb_batch_no ;
                ObjBO.tb_branchcd = Obj.tb_branchcd ;
                ObjBO.tb_branchbatchcd = Obj.tb_branchbatchcd ;
                ObjBO.tb_cash = Obj.tb_cash ;
                ObjBO.tb_reasfortrade = Obj.tb_reasfortrade ;
                ObjBO.tb_rejreason = Obj.tb_rejreason ;
                ObjBO.mkrid = Obj.mkrid ;
                ObjBO.mkrdt = Obj.mkrdt ;
                ObjBO.tb_authcode3 = Obj.tb_authcode3 ;
                ObjBO.tb_authuserid3 = Obj.tb_authuserid3 ;
                ObjBO.tb_authdt3 = Obj.tb_authdt3 ;
                ObjBO.tb_authremarks = Obj.tb_authremarks ;
                ObjBO.tb_scrollno = Obj.tb_scrollno ;
                ObjBO.tb_obligationid = Obj.tb_obligationid ;
                ObjBO.tb_serialno = Obj.tb_serialno ;
                ObjBO.tb_tradeno = Obj.tb_tradeno ;
                ObjBO.tb_exec_date = Obj.tb_exec_date ;
                ObjBO.tb_remark = Obj.tb_remark ;
                ObjBO.mkrtm = Obj.mkrtm ;
                ObjBO.tb_authtm1 = Obj.tb_authtm1 ;
                ObjBO.tb_authtm2 = Obj.tb_authtm2 ;
                ObjBO.tb_authtm3 = Obj.tb_authtm3 ;
                ObjBO.tb_instreceivemode = Obj.tb_instreceivemode ;
                ObjBO.tb_recoslipyn = Obj.tb_recoslipyn ;
                ObjBO.tb_entrymode = Obj.tb_entrymode ;
                ObjBO.tb_lotno = Obj.tb_lotno ;
                SingleEntities db = new SingleEntities();
                db.Trxbackoffices.Add(ObjBO);
                return db.SaveChanges();
            }
            catch (Exception)
            {
                return 0;
            }
        }