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;
}
