Exemple #1
0
        protected void Login_Click(object sender, EventArgs e)
        {
            Validate validate = new Validate();
            string user="",password="";
            if (validate.isValidInput(UserName, 3))
                user = UserName.Text.Trim();
            else
                showMessage("Invalid User Name");

            if (validate.isValidInput(Password, 3))
                password = Password.Text.Trim();
            else
                showMessage("Invalid Password");
            int res = new ValidateUser().isValidUser(user,password);
            if (res > 0)
            {
                string strUser = "******"
                                + "um_logstat,um_special,um_group_id,um_email,um_lastresetday,datediff(d, um_lastresetday, getdate()) as intDay,"
                                + "um_resetpwddays, um_locked, um_poaforpayin,um_status from User_master where um_user_id ='" + user + "'";

                DBHelper db = new DBHelper();
                DataTable dt = db.executeQuery(strUser);

                db.setSessionValue("UserId", user);
                db.setSessionValue("Password", password);
                db.setSessionValue("UserGroup", db.GetDtValue(dt, "um_group_id"));
                Response.Redirect("~/Home.aspx");
                db.setSessionValue("LoginPage","~/Login.aspx");
            }
            else {
                showMessage("Invalid User Name / Password");
            }
        }
Exemple #2
0
        public int savedatatoBankMaster(object Parameter)
        {
            int j = 0;
            try
            {
                //FinancialDatabaseLayer.DataBase objDB = new DataBase(ConfigurationManager.ConnectionStrings["FinancialConnectionString"].ConnectionString);
                ELBankMaster objEL = (ELBankMaster)Parameter;

                DBHelper objDB = new DBHelper();

                objDB.AddParameter("@bk_micr", objEL.BK_MICR);
                objDB.AddParameter("@bk_name", objEL.BK_NAME);
                objDB.AddParameter("@bk_branch", objEL.BK_BRANCH);
                objDB.AddParameter("@bk_add1", objEL.BK_ADD1);
                objDB.AddParameter("@bk_add2", objEL.BK_ADD2);
                objDB.AddParameter("@bk_add3", objEL.BK_ADD3);
                objDB.AddParameter("@bk_city", objEL.BK_CITY);
                objDB.AddParameter("@bk_state", objEL.BK_STATE);
                objDB.AddParameter("@bk_country", objEL.BK_COUNTRY);
                objDB.AddParameter("@bk_pin", objEL.BK_PIN);
                objDB.AddParameter("@bk_tele1", objEL.BK_TELE1);
                objDB.AddParameter("@bk_tele2", objEL.BK_TELE2);
                objDB.AddParameter("@bk_fax", objEL.BK_FAX);
                objDB.AddParameter("@bk_email", objEL.BK_EMAIL);
                objDB.AddParameter("@bk_conname", objEL.BK_CONNAME);
                objDB.AddParameter("@bk_condesg", objEL.BK_CONDESG);
                objDB.AddParameter("@Mode", objEL.BK_Mode);
                j = objDB.executeNonQuerySP("usp_Finapp_Single_Bank_Master_Insert_Update_Select");
            }
            catch
            {
                j = 0;
            }
            return j;
        }
        public void SearchDataByVoucherNo()
        {
            if(txtVoucher.Text.Trim() != "")
            {
                DataSet ds = null;
                DBHelper objDB = new DBHelper();
                objDB.AddParameter("@rc_voucherno", txtVoucher.Text.Trim());
                ds = objDB.executeDataSetSP("dbo.getPaymentRecievedData");
                if (ds != null)
                {
                    cmbCom.SelectedValue = "";
                    ddlYear.SelectedValue = "";
                    cmbBank.SelectedValue = "";
                    txtClFrom.Text = "";
                    txtAmount.Text = "";
                    txtParticular.Text = "";
                    txtTotal.Text = "";
                    txtChqNo.Text = "";
                    txtNewBalance.Text = "";
                    txtMicr.Text = "";
                    txtBal_T.Text = "";
                    txtcost.Text = "";
                        //ds.Tables[0].Columns[0].ColumnName;
                }

            }
        }
 public void FillGridView()
 {
     DataSet ds = null;
     DBHelper objDB = new DBHelper();
     ds = objDB.executeDataSetSP("dbo.getPaymentRecievedData");
     GrdReceipt.DataSource = ds;
     GrdReceipt.DataBind();
 }
 public void LoadGrid()
 {
     //select  ie_lotno,ie_slipno,ie_cmcd,ie_execdt,ie_nooftrx,ie_noofcert,ie_rejected,ie_trxtype,ie_instno,ie_mode,ie_remark,ie_charge,ie_pri_key from Inward_entry
     string Str_Query = "select ie_lotno,ie_slipno,ie_cmcd,ie_execdt,ie_nooftrx,ie_noofcert,ie_rejected,ie_trxtype,ie_instno,ie_mode,ie_remark,ie_charge,ie_pri_key from Inward_entry";
     DBHelper db = new DBHelper();
     DataSet ds = db.executeDataSet(Str_Query);
     grdReceipts.DataSource = ds;
     grdReceipts.DataBind();
 }
        protected void btnfetch_Click(object sender, EventArgs e)
        {
            string filterType = cmbfilter.SelectedValue;
            string userGroup = Session["UserGroup"].ToString();
            string filter = "";
            if (filterType == "S")
            {
                filter = " AND id_settlementno like '%" + txtfiltername.Text.Trim() + "%'";
            }
            else if(filterType =="E" || filterType == "T")
            {
                filter = " AND rtrim(convert(char,convert(datetime,id_trxdate),103)) = '" + txtfilterDate.Text.Trim() + "'";

            }

            string strquery = "select top 10 cc_id,rtrim(ltrim(cc_settle_no)) cc_settle_no,cc_mkt_type,";
            strquery += " rtrim(convert(char,convert(datetime,cc_settle_periodfrom),103)) cc_settle_periodfrom,";
            strquery += " rtrim(convert(char,convert(datetime,cc_settle_periodto),103)) cc_settle_periodto, ";
            strquery += " rtrim(convert(char,convert(datetime,cc_nsdl_deadlinedt),103)) cc_nsdl_deadlinedt, ";
            strquery += " left(cc_nsdl_deadlinett,2)+':'+right(cc_nsdl_deadlinett,2) as cc_nsdl_deadlinett,";
            strquery += " rtrim(convert(char,convert(datetime,cc_payin_dt),103)) cc_payin_dt,";
            strquery += " rtrim(convert(char,convert(datetime,cc_payout_dt),103)) cc_payout_dt,";
            strquery += " mt_description from Market_type inner join Cc_Calender on cc_mkt_type = mt_code where 1=1";

            strquery = "Select cm_name as cname,id_instcd as instcd,"
            + "ltrim(rtrim(id_otherclientid)) + case ltrim(rtrim(id_settlementno))  when '' then '' else ' / ' "
            + "+ id_settlementno end + case ltrim(rtrim(id_otherdpid))  when '' then '' else ' / ' + id_otherdpid end as otherclid,"
            + "id_trxtype as trxtype,id_internalrefno as irn,id_pri_key as prikey,id_trxdate as trxdate,id_clientid as  client,"
            + "id_isin as isin,id_branchcd as  branch,id_qty as qty ,id_allow allow,"
            + "isnull(id_authuserid1,'') authid1, isnull(id_authuserid2,'') authid2,isnull(id_authuserid3,'') authid3,"
            + "sc_isinname as isinname,'' othercmbpid,isnull(id_settlementno,'') stlmnt"
            + ",case isnull(id_authuserid1,'') when '' then (select min(am_amount) from Auth_master where am_code = id_trxtype and ltrim(rtrim(am_group1)) = '01')"
            + "Else case isnull(id_authuserid2,'') when '' then (select min(am_amount) from Auth_master where am_code = id_trxtype and ltrim(rtrim(am_group2)) = '01')"
            + "Else case isnull(id_authuserid3,'') when '' then  (select min(am_amount) from Auth_master where am_code = id_trxtype and ltrim(rtrim(am_group3)) = '01') end end end as minamount, "
            + "case isnull(id_authuserid1,'') when '' then  (select min(am_amount) from Auth_master where am_code = id_trxtype and am_group1 <> '' and "
            + "am_amount > (select max(am_amount) from Auth_master where am_code = id_trxtype and am_group1 =  '01'))"
            + "Else case isnull(id_authuserid2,'') when '' then  (select min(am_amount) from Auth_master where am_code = id_trxtype and am_group2 <> '' and "
            + "am_amount > (select max(am_amount) from Auth_master where am_code = id_trxtype and am_group2 =  '01'))"
            + "Else  case isnull(id_authuserid3,'') when '' then (select min(am_amount) from Auth_master where am_code = id_trxtype and am_group3 <> '' and "
            + "am_amount > (select max(am_amount) from Auth_master where am_code = id_trxtype and am_group3 =  '01'))"
            + "end end end as maxamount, case isnull(id_authuserid1,'') when '' then '1' Else case isnull(id_authuserid2,'') when '' then '2' Else  case isnull(id_authuserid3,'') when '' then '3' end end end as authlevel,(sc_rate * id_qty) as value "
            + "from Interdepository a,Security,Client_master1 where cm_cd = id_clientid and sc_isincode = id_isin and id_trxtype = '925'";

            if (filter != "")
                strquery += filter;
            strquery += " order by id_settlementno";

            //SingleEntities db = new SingleEntities();
            //List<Classes.SettlementGrid> res = db.Database.SqlQuery<Classes.SettlementGrid>(strquery).ToList();

            DBHelper db = new DBHelper();
            DataSet ds = db.executeDataSet(strquery);

            Gridview1.DataSource = ds;
            Gridview1.DataBind();
        }
 public void FillRecievedInDD()
 {
     DataSet ds = null;
     DBHelper objDB = new DBHelper();
     ds = objDB.executeDataSetSP("dbo.GetRecievedIn");
     cmbBank.DataSource = ds;
     cmbBank.DataValueField = "cm_cd";
     cmbBank.DataTextField = "cm_name";
     cmbBank.DataBind();
 }
Exemple #8
0
        public DataSet getMenu_On_groupid(string strUser)
        {
            DataSet j = null;
            try
            {
                DBHelper db = new DBHelper();
                j = db.executeDataSet("USP_FINAPP_MENU_MASTER_SELECT_MENU_TO_DISPLAY '" + db.getSessionValue("UserId") + "'");
            }
            catch
            {

                j = null;
            }
            return j;
        }
Exemple #9
0
 public int isValidUser(string user,string password)
 {
     try
     {
         string strQuery = "select count(um_user_id) from User_master where um_user_id ='" + user + "' and um_passwd='" + password + "'";
         DBHelper db = new DBHelper();
         //string result = db.executeScalar(strQuery);
         int res = Convert.ToInt32(db.executeScalar(strQuery));
         if (res > 0)
             db.setSessionValue("UserId", user.Trim());
         return res;
     }
     catch (Exception)
     {
         return 0;
     }
 }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                if (string.IsNullOrWhiteSpace(Session["UserId"] as string))
                {
                    Response.Redirect("~/Login.aspx");
                }
                else {
                string code1 = Request.QueryString["code1"];
                string code2 = Request.QueryString["code2"];
                if (!string.IsNullOrWhiteSpace(code1) && !string.IsNullOrWhiteSpace(code2))
                {
                    string strUser = "******"
                                    +" id_settlementno,id_cc_id,cm_name,id_dqty,id_qty,id_executiondate,id_remarks,id_entrymode"
                                    +" from Interdepository left join Client_master1 on id_cc_id = Client_master1.cm_cd"
                                    + " where id_instcd=" + code1 + " and id_pri_key=" + code2 ;

                    DBHelper db = new DBHelper();
                    DataTable dt = db.executeQuery(strUser);
                    lbl_set_date.Text = db.GetDtValue(dt, "id_trxdate");
                    lbl_set_scrollNo.Text = db.GetDtValue(dt, "id_scrollno");
                    lbl_set_insType.Text = db.GetDtValue(dt, "id_instcd");
                    lbl_set_avblLot.Text = db.GetDtValue(dt, "id_lotno");
                    lbl_set_lotSize.Text = db.GetDtValue(dt, "lotsize");
                    lbl_set_slipNo.Text = db.GetDtValue(dt, "id_settlementno");
                    lbl_set_clientCode.Text = db.GetDtValue(dt, "id_cc_id");
                    lbl_set_clientName.Text = db.GetDtValue(dt, "cm_name");
                    lbl_set_instructions.Text = db.GetDtValue(dt, "id_dqty");
                    lbl_set_noofcerts.Text = db.GetDtValue(dt, "id_qty");
                    lbl_set_execDate.Text = db.GetDtValue(dt, "id_executiondate");
                    lbl_set_charges.Text ="";
                    lbl_set_remarks.Text = db.GetDtValue(dt, "id_remarks");
                    lbl_set_mod.Text = db.GetDtValue(dt, "id_entrymode");
                }
                }
            }
        }
Exemple #11
0
        public object Search_Duplicate_Micr(object Parameter)
        {
            // DataSet ds;
            object j;
            try
            {
                DBHelper objDB = new DBHelper();
                ELBankMaster objEL = new ELBankMaster();
                objDB.AddParameter("@bk_micr", objEL.BK_MICR);
                objDB.AddParameter("@Mode", objEL.BK_Mode);
                // objDB.AddParameter("@bk_micr", objEL.BK_MICR);
                objDB.AddParameter("@bk_name", objEL.BK_NAME);
                objDB.AddParameter("@bk_branch", objEL.BK_BRANCH);
                objDB.AddParameter("@bk_add1", objEL.BK_ADD1);
                objDB.AddParameter("@bk_add2", objEL.BK_ADD2);
                objDB.AddParameter("@bk_add3", objEL.BK_ADD3);
                objDB.AddParameter("@bk_city", objEL.BK_CITY);
                objDB.AddParameter("@bk_state", objEL.BK_STATE);
                objDB.AddParameter("@bk_country", objEL.BK_COUNTRY);
                objDB.AddParameter("@bk_pin", objEL.BK_PIN);
                objDB.AddParameter("@bk_tele1", objEL.BK_TELE1);
                objDB.AddParameter("@bk_tele2", objEL.BK_TELE2);
                objDB.AddParameter("@bk_fax", objEL.BK_FAX);
                objDB.AddParameter("@bk_email", objEL.BK_EMAIL);
                objDB.AddParameter("@bk_conname", objEL.BK_CONNAME);
                objDB.AddParameter("@bk_condesg", objEL.BK_CONDESG);

                j = objDB.executeScalar("usp_Finapp_Single_Bank_Master_Insert_Update_Select");
            }
            catch
            {
                j = null;
            }
            //j = objDB.ExecuteDataSet();
            return j;
        }
Exemple #12
0
        public SqlDataReader select_BK_for_Update(object parameter)
        {
            SqlDataReader dr = null;
            try
            {
                DBHelper objDB = new DBHelper();
                ELBankMaster objEL = new ELBankMaster();
                objDB.AddParameter("@Mode", objEL.BK_Mode);
                objDB.AddParameter("@bank_micr", objEL.BK_MICR);

                dr = (SqlDataReader)objDB.ExecuteReaderSP("FinancaApp_Bank_Master_Bank_Select");

            }
            catch
            {
                dr = null;
            }

            return dr;
        }
Exemple #13
0
        public DataSet Search_Master(object Parameter)
        {
            //    if( )
            DataSet ds = null;
            //FinancialDatabaseLayer.DataBase objDB = new DataBase(ConfigurationManager.ConnectionStrings["FinancialConnectionString"].ConnectionString);
            DBHelper objDB = new DBHelper();
            SearchEntity objEL = (SearchEntity)Parameter;
            //FinancialEntityLayer.Search objEL = (FinancialEntityLayer.Search)Parameter;

            switch (objEL.Selection.ToString())
            {

                case "Courrier":
                    objDB.AddParameter("@cum_courrier_id ", objEL.Courrier);
                    objDB.AddParameter("@Mode", objEL.BK_Mode);
                    objDB.AddParameter("@cum_courrier_name", objEL.Courrier);
                    ds = objDB.executeDataSetSP("usp_single_Courrier_Master_Search");
                    break;

                case "Client":
                    objDB.AddParameter("@cm_cd", objEL.StrClient);
                    objDB.AddParameter("@cm_name", objEL.StrClient);
                    objDB.AddParameter("@cb_panno", objEL.StrClient);
                    objDB.AddParameter("@cm_lastname", objEL.StrClient);
                    objDB.AddParameter("@cm_opendate", objEL.StrClient);
                    objDB.AddParameter("@bk_off_cd", objEL.StrClient);
                    objDB.AddParameter("@Mode", objEL.BK_Mode);
                    ds = objDB.executeDataSetSP("usp_client_master_Search");
                    break;

                case "User":
                    objDB.AddParameter("@um_user_id", objEL.UserId);
                    objDB.AddParameter("@um_user_name", objEL.UserName);
                    //  objDB.AddParameter("@bk_branch", objEL.BK_BRANCH);
                    objDB.AddParameter("@Mode", objEL.BK_Mode);
                    ds = objDB.executeDataSetSP("usp_single_user_master_search");

                    break;

                case "Bank":
                    objDB.AddParameter("@bk_micr", objEL.BK_MICR);
                    objDB.AddParameter("@bk_name", objEL.BK_NAME);
                    objDB.AddParameter("@bk_branch", objEL.BK_BRANCH);
                    objDB.AddParameter("@Mode", objEL.BK_Mode);
                    // objDB.AddParameter("@Selection", objEL.Selection);
                    ds = objDB.executeDataSetSP("usp_Single_Bank_Master_Search");

                    break;
                case "Banned":
                    objDB.AddParameter("@be_panno", objEL.Strpanno);
                    objDB.AddParameter("@Mode", objEL.BK_Mode);

                    // objDB.AddParameter("@Selection", objEL.Selection);
                    ds = objDB.executeDataSetSP("usp_single_banned_enity_Search");

                    break;

                case "Family":
                    objDB.AddParameter("@fm_desc", objEL.strFamilyName);
                    objDB.AddParameter("@fm_cd", objEL.ChrFamilyCode);
                    objDB.AddParameter("@Mode", objEL.BK_Mode);
                    ds = objDB.executeDataSetSP("usp_Single_Family_Master_search");

                    break;
                case "BPMaster":
                    objDB.AddParameter("@bp_id", objEL.BpCode);
                    objDB.AddParameter("@bp_name", objEL.StrBpName);
                    objDB.AddParameter("@Mode", objEL.BK_Mode);
                    ds = objDB.executeDataSetSP("Usp_Single_BpMaster_Search");
                    break;

                case "GroupMaster":
                    objDB.AddParameter("@gr_desc", objEL.StrGroupName);
                    objDB.AddParameter("@gr_cd", objEL.GroupCode);
                    objDB.AddParameter("@Mode", objEL.BK_Mode);
                    ds = objDB.executeDataSetSP("usp_Single_Group_Master_Search");

                    break;

                case "BranchMaster":
                    objDB.AddParameter("@bm_branchname", objEL.StrBrName);
                    objDB.AddParameter("@bm_branchcd", objEL.ChrBrCode);
                    objDB.AddParameter("@bm_contact", objEL.StrBrContact);
                    objDB.AddParameter("@Mode", objEL.BK_Mode);
                    ds = objDB.executeDataSetSP("usp_single_branch_master_search");
                    break;
                case "StateMaster":
                    objDB.AddParameter("@SrNo", objEL.intSrNo);
                    objDB.AddParameter("@State", objEL.StrStateName);
                    objDB.AddParameter("@Mode", objEL.BK_Mode);
                    ds = objDB.executeDataSetSP("usp_single_State_Master_Search");
                    break;
                case "UserGroup":
                    objDB.AddParameter("@ug_cd", objEL.ChrUGCode);
                    objDB.AddParameter("@ug_desc", objEL.StrUG_Desc);
                    objDB.AddParameter("@Mode", objEL.BK_Mode);
                    ds = objDB.executeDataSetSP("usp_Single_UserGroup_Search");
                    break;
                case "Region":
                    objDB.AddParameter("@reg_cd", objEL.StrRegCd);
                    objDB.AddParameter("@reg_desc", objEL.StrRegDesc);
                    objDB.AddParameter("@Mode", objEL.BK_Mode);
                    ds = objDB.executeDataSetSP("usp_single_region__master_Search");
                    break;
                //  objDB.AddParameter();
                case "SubBroker":
                    objDB.AddParameter("@rm_cd", objEL.ChrBrokerCd);
                    objDB.AddParameter("@rm_name", objEL.StrBrokerName);
                    objDB.AddParameter("@Mode", objEL.BK_Mode);
                    objDB.AddParameter("@rm_ledgercd", objEL.ChrLedgercd);
                    ds = objDB.executeDataSetSP("Usp_Single_Remisser_Master_Search");
                    break;
                //case "banklist":
                //  objDB.AddParameter("@COLUMN", objEL.Control);
                //objDB.AddParameter("@VALUE", objEL.Value);
                // objDB.AddParameter("@Mode", objEL.BK_Mode);
                //ds = objDB.executeDataSetSP("usp_Single_Bank_Master_Searchs");
                // break;
                case "Isinlist":
                    objDB.AddParameter("@sc_isincode", objEL.strscisincode);
                    objDB.AddParameter("@sc_isinname", objEL.strscisinname);
                    objDB.AddParameter("@Mode", objEL.BK_Mode);
                    ds = objDB.executeDataSetSP("usp_Single_Isin_Search");
                    break;
                case "NominationMaster":
                    objDB.AddParameter("@nd_regno", objEL.strndregno);
                    objDB.AddParameter("@nd_name", objEL.strndname);
                    objDB.AddParameter("@Mode", objEL.BK_Mode);
                    ds = objDB.executeDataSetSP("usp_single_nominee_master_search");
                    break;
                case "Beneficiary":
                    objDB.AddParameter("@bs_code", objEL.chrbs_code);
                    objDB.AddParameter("@bs_description", objEL.strbs_description);
                    objDB.AddParameter("@Mode", objEL.BK_Mode);
                    ds = objDB.executeDataSetSP("usp_single_master_beneficary_search");
                    break;
                case "Settlementcalender":
                    objDB.AddParameter("@cc_id", objEL.chrcc_id);
                    objDB.AddParameter("@cc_settle_no", objEL.chrcc_settle_no);
                    objDB.AddParameter("@Mode", objEL.BK_Mode);
                    ds = objDB.executeDataSetSP("usp_single_master_settlement_calender_search");
                    break;
                case "POA":
                    objDB.AddParameter("@cpd_poaid", objEL.Strcpd_poaid);
                    objDB.AddParameter("@Mode", objEL.BK_Mode);
                    ds = objDB.executeDataSetSP("usp_single_master_POA_search");
                    break;
                case "ChargesMaster":
                    objDB.AddParameter("@cg_code", objEL.chrcg_code);
                    objDB.AddParameter("@cg_name", objEL.strcg_name);
                    objDB.AddParameter("@Mode", objEL.BK_Mode);
                    ds = objDB.executeDataSetSP("usp_single_charges_master_search");
                    break;
                case "BatchDetail":
                    objDB.AddParameter("@bd_type", objEL.chrbd_type);
                    objDB.AddParameter("@bd_batchno", objEL.decbd_batchno);
                    objDB.AddParameter("@Mode", objEL.BK_Mode);
                    ds = objDB.executeDataSetSP("usp_single_master_batchdetails_search");
                    break;
                case "BpStatus":
                    objDB.AddParameter("@bps_code", objEL.chrbps_code);
                    objDB.AddParameter("@bps_description", objEL.strbps_description);
                    objDB.AddParameter("@Mode", objEL.BK_Mode);
                    ds = objDB.executeDataSetSP("usp_single_master_bpstatus_search");
                    break;
                case "MarketType":
                    objDB.AddParameter("@mt_code", objEL.chrmt_code);
                    objDB.AddParameter("@mt_description", objEL.strmt_description);
                    objDB.AddParameter("@Mode", objEL.BK_Mode);
                    ds = objDB.executeDataSetSP("usp_single_master_markettype_search");
                    break;
                case "Narration":
                    objDB.AddParameter("@nr_code", objEL.chrnr_code);
                    objDB.AddParameter("@nr_description", objEL.strnr_description);
                    objDB.AddParameter("@Mode", objEL.BK_Mode);
                    ds = objDB.executeDataSetSP("usp_single_master_narration_search");
                    break;
                case "AccountNarration":
                    objDB.AddParameter("@an_cd", objEL.intan_cd);
                    objDB.AddParameter("@an_desc", objEL.stran_desc);
                    objDB.AddParameter("@Mode", objEL.BK_Mode);
                    ds = objDB.executeDataSetSP("usp_single_master_accountnarration_search");
                    break;
                case "CostcenterMaster":
                    objDB.AddParameter("@co_cd", objEL.chrco_cd);
                    objDB.AddParameter("@co_desc", objEL.strco_desc);
                    objDB.AddParameter("@Mode", objEL.BK_Mode);
                    ds = objDB.executeDataSetSP("usp_single_master_costcenter_search");
                    break;
                case "BankAccount":
                    objDB.AddParameter("@ba_code", objEL.chrba_code);
                    objDB.AddParameter("@ba_description", objEL.strba_description);
                    objDB.AddParameter("@Mode", objEL.BK_Mode);
                    ds = objDB.executeDataSetSP("usp_single_master_Bankaccount_type_search");
                    break;
                case "Reasonmaster":
                    objDB.AddParameter("@rm_code", objEL.strrm_code);
                    objDB.AddParameter("@rm_description", objEL.strrm_description);
                    objDB.AddParameter("@Mode", objEL.BK_Mode);
                    ds = objDB.executeDataSetSP("usp_single_reason_master_search");
                    break;
                case "ObjectionReason":
                    objDB.AddParameter("@or_code", objEL.stror_code);
                    objDB.AddParameter("@or_name", objEL.stror_name);
                    objDB.AddParameter("@Mode", objEL.BK_Mode);
                    ds = objDB.executeDataSetSP("usp_single_master_Objection_reason_search");
                    break;
                case "Status_of_Transaction":
                    objDB.AddParameter("sx_code", objEL.strsx_code);
                    objDB.AddParameter("sx_description", objEL.strsx_description);
                    objDB.AddParameter("@Mode", objEL.BK_Mode);
                    ds = objDB.executeDataSetSP("usp_single_master_Statusof_trx_search");
                    break;
                case "Othersubmaster":
                    objDB.AddParameter("@cs_code", objEL.chrcs_code);
                    objDB.AddParameter("@cs_desc", objEL.strcs_desc);
                    objDB.AddParameter("@Mode", objEL.BK_Mode);
                    ds = objDB.executeDataSetSP("usp_single_master_Clientsub_master_search");
                    break;
                case "ShortClient":
                    objDB.AddParameter("@cm_cd", objEL.strClient_code);
                    objDB.AddParameter("@cm_name", objEL.strClient_name);
                    objDB.AddParameter("@Mode", objEL.BK_Mode);
                    ds = objDB.executeDataSetSP("usp_client_master_Search_c");
                    break;

                case "InterDPSearch":
                    objDB.AddParameter("@internal_ref_no", objEL.str_internal_ref_no);
                    objDB.AddParameter("@scroll_no", objEL.str_scroll_no);
                    objDB.AddParameter("@Mode", objEL.BK_Mode);
                    ds = objDB.executeDataSetSP("usp_search_interdp");
                    break;
            }
            return ds;
        }
Exemple #14
0
 public DataSet Search_Master(object Parameter)
 {
     DataSet ds;
     DBHelper objDB = new DBHelper();
     ELBankMaster objEL = new ELBankMaster();
     objDB.AddParameter("@bk_micr", objEL.BK_MICR);
     objDB.AddParameter("@bk_name", objEL.BK_NAME);
     objDB.AddParameter("@bk_branch", objEL.BK_BRANCH);
     objDB.AddParameter("@Mode", objEL.BK_Mode);
     ds = objDB.executeDataSetSP("usp_Single_Bank_Master_Search");
     return ds;
 }
Exemple #15
0
 public DataSet SelectState_MasteForLoad()
 {
     DataSet ds;
     DBHelper objDB = new DBHelper();
     // FinancialEntityLayer.ComboElement objEL = (ComboElement) Parameter;
     // objDB.AddParameter(("",objEL.intselectedvalue);
     ds = objDB.executeDataSetSP("usp_FinnacApp_State_Master_Select");
     return ds;
 }
Exemple #16
0
        public DataSet Select_code_desc()
        {
            DataSet ds = null; ;
            try
            {
                DBHelper objDB = new DBHelper();
                //  FinancialEntityLayer.ELBankMaster objEL = (ELBankMaster)parameter;
                // objDB.AddParameter("", objEL.BK_NAME);

                ds = objDB.executeDataSetSP("usp_Single_User_Group_Select");

            }
            catch
            {
                ds = null;
            }
            return ds;
        }
Exemple #17
0
        public DataSet Select_BK_Name_Micr_IFSC()
        {
            DataSet ds = null; ;
            try
            {
                DBHelper objDB = new DBHelper();
                ds = objDB.executeDataSetSP("usp_FinnaceApp_Bank_Select_bkname_micr_ifsc");

            }
            catch
            {
                ds = null;
            }
            return ds;
        }
Exemple #18
0
        public DataSet Select_BK_Name(object parameter)
        {
            DataSet ds = null; ;
            try
            {
                DBHelper objDB = new DBHelper();
                ELBankMaster objEL = new ELBankMaster();
                objDB.AddParameter("@bank_name", objEL.BK_NAME);
                ds = objDB.executeDataSetSP("usp_FinnaceApp_Bank_Select_bkname");

            }
            catch
            {
                ds = null;
            }
            return ds;
        }
Exemple #19
0
 public DbDataReader Select_All_Bank_Master_Update(object parameter)
 {
     DbDataReader ds = null; ;
     try
     {
         DBHelper objDB = new DBHelper();
         ELBankMaster objEL = new ELBankMaster();
         objDB.AddParameter("@bk_micr", objEL.BK_MICR);
         ds = objDB.ExecuteReaderSP("usp_Finapp_Single_Bank_Master_Select");
     }
     catch
     {
         ds = null;
     }
     return ds;
 }