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"); } }
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(); }
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; }
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"); } } } }
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; }
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; }
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; }
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; }
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; }
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; }
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; }
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; }
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; }