private DataTable GetReportData()
{
MCBReportClass RptObj = new MCBReportClass();
DataSet dsReport = RptObj.Local_GetDataSetSP1("SP_BalancesSummaryOfAgents_rpt");
return(dsReport.Tables[0]);
}
private DataTable GetData(string date)
{
MCBReportClass RptObj = new MCBReportClass();
DataSet dsReport = new DataSet();
OracleParameter[] parm = new OracleParameter[2];
parm[0] = RptObj.OracleDBParameter("p_date", date, "String", "In");
parm[1] = RptObj.OracleDBParameter("dataset", "", "Cursor", "Out");
dsReport = RptObj.Oracle_GetDataSetSP("sp_other_bank_trans_report", parm);
string totalstub = dsReport.Tables[0].Rows.Count.ToString();
return(dsReport.Tables[0]);
}
private DataTable GetData(string Month)
{
MCBReportClass RptObj = new MCBReportClass();
DataSet dsReport = new DataSet();
OracleParameter[] parm = new OracleParameter[2];
parm[0] = RptObj.OracleDBParameter("p_month", Month, "String", "In");
parm[1] = RptObj.OracleDBParameter("dataset", "", "Cursor", "Out");
dsReport = RptObj.Oracle_GetDataSetSP("sp_ins_status_sumry_rpt", parm);
string totalstub = dsReport.Tables[0].Rows.Count.ToString();
return(dsReport.Tables[0]);
}
private DataTable GetData(string month)
{
MCBReportClass RptObj = new MCBReportClass();
DataSet dsReport = new DataSet();
OracleParameter[] parm = new OracleParameter[2];
parm[0] = RptObj.OracleDBParameter("p_month", month, "String", "In");
parm[1] = RptObj.OracleDBParameter("DATA_RESULTSET", "", "Cursor", "Out");
dsReport = RptObj.Oracle_GetDataSetSP("sp_sbp_claim", parm);
string totalstub = dsReport.Tables[0].Rows.Count.ToString();
return(dsReport.Tables[0]);
}
private DataTable GetReportData(string[] whereFilter)
{
MCBReportClass RptObj = new MCBReportClass();
OracleParameter[] spParams = new OracleParameter[3];
spParams[0] = RptObj.OracleDBParameter("p_company_code", whereFilter[0], "String", "In");
spParams[1] = RptObj.OracleDBParameter("p_file", whereFilter[1], "String", "In");
spParams[2] = RptObj.OracleDBParameter("data_resultset", "", "Cursor", "Out");
DataSet dsReport = RptObj.Oracle_GetDataSetSP("SP_DraftTransaction_rpt", spParams);
return(dsReport.Tables[0]);
}
private DataTable GetData(string date, string CompanyCode)
{
MCBReportClass RptObj = new MCBReportClass();
DataSet dsReport = new DataSet();
OracleParameter[] parm = new OracleParameter[3];
parm[0] = RptObj.OracleDBParameter("p_company_code", CompanyCode, "String", "In");
parm[1] = RptObj.OracleDBParameter("p_date", date, "String", "In");
parm[2] = RptObj.OracleDBParameter("data_set", "", "Cursor", "Out");
dsReport = RptObj.Oracle_GetDataSetSP("sp_NON_RES_ACCOUNTS", parm);
string totalstub = dsReport.Tables[0].Rows.Count.ToString();
return(dsReport.Tables[0]);
}
private DataTable GetData(string PinCode)
{
MCBReportClass RptObj = new MCBReportClass();
DataSet dsReport = new DataSet();
OracleParameter[] parm = new OracleParameter[2];
parm[0] = RptObj.OracleDBParameter("p_pin_id", PinCode, "String", "In");
parm[1] = RptObj.OracleDBParameter("dataset", "", "Cursor", "Out");
dsReport = RptObj.Oracle_GetDataSetSP("sp_ws_auditlog_rpt", parm);
string totalstub = dsReport.Tables[0].Rows.Count.ToString();
return(dsReport.Tables[0]);
}
public string GetBankName()
{
MCBReportClass RptObj = new MCBReportClass();
DataSet dsReport = new DataSet();
OracleParameter[] parm = new OracleParameter[1];
parm[0] = RptObj.OracleDBParameter("DATA_RESULTSET", "", "Cursor", "Out");
dsReport = RptObj.Oracle_GetDataSetSP("SP_System_setup", parm);
if (dsReport.Tables[0].Rows.Count > 0)
{
return(dsReport.Tables[0].Rows[0][0].ToString());
}
return("");
}
private DataTable GetData(string fromdate, string todate)
{
MCBReportClass RptObj = new MCBReportClass();
DataSet dsReport = new DataSet();
OracleParameter[] parm = new OracleParameter[3];
parm[0] = RptObj.OracleDBParameter("p_fromdate", fromdate, "String", "In");
parm[1] = RptObj.OracleDBParameter("p_todate", todate, "String", "In");
parm[2] = RptObj.OracleDBParameter("DATA_RESULTSET", "", "Cursor", "Out");
dsReport = RptObj.Oracle_GetDataSetSP("sp_DD_EXE_SUMMARY_REPORT", parm);
string totalstub = dsReport.Tables[0].Rows.Count.ToString();
return(dsReport.Tables[0]);
}
private DataTable GetData(string month, string company_code)
{
MCBReportClass RptObj = new MCBReportClass();
DataSet dsReport = new DataSet();
OracleParameter[] parm = new OracleParameter[3];
parm[0] = RptObj.OracleDBParameter("p_month", month, "String", "In");
parm[1] = RptObj.OracleDBParameter("p_company_code", company_code, "String", "In");
parm[2] = RptObj.OracleDBParameter("dataset", "", "Cursor", "Out");
dsReport = RptObj.Oracle_GetDataSetSP("sp_home_rem_sum_Rpt", parm);
string totalstub = dsReport.Tables[0].Rows.Count.ToString();
return(dsReport.Tables[0]);
}
private DataTable GetData(string p_account_no, string p_ref_no, string from_date, string to_date)
{
MCBReportClass RptObj = new MCBReportClass();
DataSet dsReport = new DataSet();
OracleParameter[] parm = new OracleParameter[5];
parm[0] = RptObj.OracleDBParameter("p_account_no", p_account_no, "String", "In");
parm[1] = RptObj.OracleDBParameter("p_ref_no", p_ref_no, "String", "In");
parm[2] = RptObj.OracleDBParameter("p_from_dt", from_date, "String", "In");
parm[3] = RptObj.OracleDBParameter("p_to_dt", to_date, "String", "In");
parm[4] = RptObj.OracleDBParameter("p_dataset", "", "Cursor", "Out");
dsReport = RptObj.Oracle_GetDataSetSP("sp_payment_prc_rpt", parm);
return(dsReport.Tables[0]);
}
public string GetReportName()
{
MCBReportClass RptObj = new MCBReportClass();
DataSet dsReport = new DataSet();
OracleParameter[] parm = new OracleParameter[2];
parm[0] = RptObj.OracleDBParameter("v_Report_Code", "R12", "String", "In");
parm[1] = RptObj.OracleDBParameter("DATA_RESULTSET", "", "Cursor", "Out");
dsReport = RptObj.Oracle_GetDataSetSP("SP_REPORT_HEADER", parm);
if (dsReport.Tables[0].Rows.Count > 0)
{
return(dsReport.Tables[0].Rows[0][1].ToString());
}
return("");
}
private DataTable GetData(string p_usr_name, string fromDate, string toDate)
{
MCBReportClass RptObj = new MCBReportClass();
DataSet dsReport = new DataSet();
OracleParameter[] parm = new OracleParameter[4];
parm[0] = RptObj.OracleDBParameter("p_usr_name", p_usr_name, "String", "In");
parm[1] = RptObj.OracleDBParameter("p_from_dt", fromDate, "String", "In");
parm[2] = RptObj.OracleDBParameter("p_to_dt", toDate, "String", "In");
parm[3] = RptObj.OracleDBParameter("data_set", "", "Cursor", "Out");
dsReport = RptObj.Oracle_GetDataSetSP("sp_core_nr_ac_satmnt_rpt", parm);
string totalstub = dsReport.Tables[0].Rows.Count.ToString();
return(dsReport.Tables[0]);
}
private DataTable GetData(string companycode, string companyType, string fromDate, string toDate)
{
MCBReportClass RptObj = new MCBReportClass();
DataSet dsReport = new DataSet();
OracleParameter[] parm = new OracleParameter[5];
parm[0] = RptObj.OracleDBParameter("p_from_date", fromDate, "String", "In");
parm[1] = RptObj.OracleDBParameter("p_to_date", toDate, "String", "In");
parm[2] = RptObj.OracleDBParameter("p_company_code", companycode, "String", "In");
parm[3] = RptObj.OracleDBParameter("p_company_type", companyType, "String", "In");
parm[4] = RptObj.OracleDBParameter("DATA_RESULTSET", "", "Cursor", "Out");
dsReport = RptObj.Oracle_GetDataSetSP("sp_dd_branchwise_report", parm);
string totalstub = dsReport.Tables[0].Rows.Count.ToString();
return(dsReport.Tables[0]);
}
private DataTable GetData(string FromDate, string ToDate, string CompanyName)
{
MCBReportClass RptObj = new MCBReportClass();
DataSet dsReport = new DataSet();
OracleParameter[] parm = new OracleParameter[4];
parm[0] = RptObj.OracleDBParameter("p_from_date", FromDate, "String", "In");
parm[1] = RptObj.OracleDBParameter("p_to_date", ToDate, "String", "In");
parm[2] = RptObj.OracleDBParameter("p_company_name", CompanyName, "String", "In");
// parm[3] = RptObj.OracleDBParameter("P_commission", commission, "String", "In");
parm[3] = RptObj.OracleDBParameter("DATA_RESULTSET", "", "Cursor", "Out");
dsReport = RptObj.Oracle_GetDataSetSP("sp_rpt_rda", parm);
string totalstub = dsReport.Tables[0].Rows.Count.ToString();
return(dsReport.Tables[0]);
}
private DataTable GetData(string FromDate, string ToDate, string USRate, string fc_saudiRiyal, string CompanyName)
{
MCBReportClass RptObj = new MCBReportClass();
DataSet dsReport = new DataSet();
OracleParameter[] parm = new OracleParameter[6];
parm[0] = RptObj.OracleDBParameter("p_from_date", Convert.ToDateTime(FromDate).ToString("dd-MM-yyyy"), "String", "In");
parm[1] = RptObj.OracleDBParameter("p_to_date", ToDate, "String", "In");
parm[2] = RptObj.OracleDBParameter("p_us_rate", USRate, "Double", "In");
parm[3] = RptObj.OracleDBParameter("P_fc_saudi_riyal", fc_saudiRiyal, "Double", "In");
parm[4] = RptObj.OracleDBParameter("p_company_name", CompanyName, "String", "In");
parm[5] = RptObj.OracleDBParameter("DATA_RESULTSET", "", "Cursor", "Out");
dsReport = RptObj.Oracle_GetDataSetSP("sp_rptstatebankrebate_summary", parm);
string totalstub = dsReport.Tables[0].Rows.Count.ToString();
return(dsReport.Tables[0]);
}
private DataTable GetData(string companycode, string fromDate, string toDate)
{
MCBReportClass RptObj = new MCBReportClass();
DataSet dsReport = new DataSet();
OracleParameter[] parm = new OracleParameter[4];
parm[0] = RptObj.OracleDBParameter("p_companycode", companycode, "String", "In");
// parm[1] = RptObj.OracleDBParameter("p_status", status, "String", "In");
parm[1] = RptObj.OracleDBParameter("p_fromdate", fromDate, "String", "In");
parm[2] = RptObj.OracleDBParameter("p_todate", toDate, "String", "In");
// parm[4] = RptObj.OracleDBParameter("p_trans_type", trans_type, "String", "In");
parm[3] = RptObj.OracleDBParameter("DATA_RESULTSET", "", "Cursor", "Out");
dsReport = RptObj.Oracle_GetDataSetSP("SP_CUSTOMER_FUNDING", parm);
string totalstub = dsReport.Tables[0].Rows.Count.ToString();
return(dsReport.Tables[0]);
}
private DataTable GetData(string companycode, string fromDate, string toDate, string companytype)
{
MCBReportClass RptObj = new MCBReportClass();
DataSet dsReport = new DataSet();
OracleParameter[] parm = new OracleParameter[6];
parm[0] = RptObj.OracleDBParameter("p_companycode", companycode, "String", "In");
parm[1] = RptObj.OracleDBParameter("p_fromdate", fromDate, "String", "In");
parm[2] = RptObj.OracleDBParameter("p_todate", toDate, "String", "In");
parm[3] = RptObj.OracleDBParameter("p_companytype", companytype, "String", "In");
parm[4] = RptObj.OracleDBParameter("p_user_id", Session["U_NAME"].ToString(), "String", "In");
parm[5] = RptObj.OracleDBParameter("DATA_RESULTSET", "", "Cursor", "Out");
dsReport = RptObj.Oracle_GetDataSetSP("sp_filelog_report", parm);
string totalstub = dsReport.Tables[0].Rows.Count.ToString();
return(dsReport.Tables[0]);
}
private DataTable GetData(string CompanyName, string TransType, string AgentType, string FromDate, string ToDate)
{
MCBReportClass RptObj = new MCBReportClass();
DataSet dsReport = new DataSet();
OracleParameter[] parm = new OracleParameter[6];
parm[0] = RptObj.OracleDBParameter("p_company_code", CompanyName, "String", "In");
parm[1] = RptObj.OracleDBParameter("p_trans_type", TransType, "String", "In");
parm[2] = RptObj.OracleDBParameter("p_COMPANY_TYPE", AgentType, "String", "In");
parm[3] = RptObj.OracleDBParameter("p_from_dt", FromDate, "String", "In");
parm[4] = RptObj.OracleDBParameter("p_to_dt", ToDate, "String", "In");
parm[5] = RptObj.OracleDBParameter("dataset", "", "Cursor", "Out");
dsReport = RptObj.Oracle_GetDataSetSP("sp_daily_post_summ_rpt", parm);
string totalstub = dsReport.Tables[0].Rows.Count.ToString();
return(dsReport.Tables[0]);
}
private DataTable GetData(string company_code, string status, string fromDate, string toDate, string trans_type, string selecttype, string p_companytype)
{
MCBReportClass RptObj = new MCBReportClass();
OracleParameter[] parm = new OracleParameter[9];
parm[0] = RptObj.OracleDBParameter("p_companycode", company_code, "String", "In");
parm[1] = RptObj.OracleDBParameter("p_status", status, "String", "In");
parm[2] = RptObj.OracleDBParameter("p_fromdate", fromDate, "String", "In");
parm[3] = RptObj.OracleDBParameter("p_todate", toDate, "String", "In");
parm[4] = RptObj.OracleDBParameter("p_trans_type", trans_type, "String", "In");
parm[5] = RptObj.OracleDBParameter("p_selecttype", selecttype, "String", "In");
parm[6] = RptObj.OracleDBParameter("p_companytype", p_companytype, "String", "In");
parm[7] = RptObj.OracleDBParameter("p_usr_name", Session["U_NAME"].ToString(), "String", "In");
parm[8] = RptObj.OracleDBParameter("DATA_RESULTSET", "", "Cursor", "Out");
dt = RptObj.Oracle_GetDataSetSP("sp_mispayment", parm).Tables[0];
return(dt);
}
//= new DatabaseConnection_Util();
//public DataSet BalancesSummaryOfAgents()
//{
// OracleParameter[] PR = new OracleParameter[1];
// //PR[0] = DataTransform.Oracle_Param("v_FromDate", OracleType.VarChar, ParameterDirection.Input, FromDate);
// //PR[1] = DataTransform.Oracle_Param("v_ToDate", OracleType.VarChar, ParameterDirection.Input, ToDate);
// PR[0] = DataTransform.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, "");
// DataSet DS = DataTransform.Oracle_GetDataSetSP("SP_BalancesSummaryOfAgents_rpt", PR);
// return DS;
//}
//public DataSet CompanyBalance()
//{
// DataSet dsResult = null;
// OracleParameter[] param = new OracleParameter[1];
// try
// {
// param[0] = DataTransform.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, "");
// dsResult= DataTransform.Oracle_GetDataSetSP("PAY_SP_RPTCOMPANYBALANCE", param);
// }
// catch (Exception ex) { }
// return dsResult;
//}
public static string GetOrgName()
{
string companyName = "";
try
{
MCBReportClass RptObj = new MCBReportClass();
DataSet dsReport = RptObj.Local_GetDataSetSP1("SP_SYSTEM_SETUP");
if (dsReport.Tables[0].Rows.Count > 0)
{
companyName = dsReport.Tables[0].Rows[0]["company_name"].ToString();
}
}
catch (Exception ex)
{ }
return(companyName);
}
private DataTable GetData(string branch_id, string status, string fromDate, string toDate, string selecttype)
{
MCBReportClass RptObj = new MCBReportClass();
DataSet dsReport = new DataSet();
OracleParameter[] parm = new OracleParameter[5];
parm[0] = RptObj.OracleDBParameter("p_branch_id", branch_id, "String", "In");
parm[1] = RptObj.OracleDBParameter("p_status", status, "String", "In");
parm[2] = RptObj.OracleDBParameter("p_fromdate", fromDate, "String", "In");
parm[3] = RptObj.OracleDBParameter("p_todate", toDate, "String", "In");
//parm[4] = RptObj.OracleDBParameter("p_trans_type", trans_type, "String", "In");
//parm[5] = RptObj.OracleDBParameter("p_selecttype", selecttype, "String", "In");
parm[4] = RptObj.OracleDBParameter("DATA_RESULTSET", "", "Cursor", "Out");
dsReport = RptObj.Oracle_GetDataSetSP("sp_mispayment_branchwise", parm);
string totalstub = dsReport.Tables[0].Rows.Count.ToString();
return(dsReport.Tables[0]);
}
public void Get_BusinessNature()
{
ddl_BusinessNature.Items.Clear();
MCBReportClass RptObj = new MCBReportClass();
DataTable dt = new DataTable();
OracleParameter[] parm = new OracleParameter[2];
parm[0] = RptObj.OracleDBParameter("p_type", "", "String", "In");
parm[1] = RptObj.OracleDBParameter("p_dataset", "", "Cursor", "Out");
dt = RptObj.Oracle_GetDataSetSP("sp_get_companyType", parm).Tables[0];
if (dt.Rows.Count > 0)
{
ddl_BusinessNature.DataSource = dt;
ddl_BusinessNature.DataValueField = "business_nature";
ddl_BusinessNature.DataTextField = "business_desc";
ddl_BusinessNature.DataBind();
}
ddl_BusinessNature.Items.Insert(0, new ListItem("All", ""));
}
private DataTable GetData(string companycode, string status, string fromDate, string toDate, string trans_type, string selecttype, string Branchid, string Userid)
{
MCBReportClass RptObj = new MCBReportClass();
DataSet dsReport = new DataSet();
OracleParameter[] parm = new OracleParameter[9];
parm[0] = RptObj.OracleDBParameter("p_companycode", companycode, "String", "In");
parm[1] = RptObj.OracleDBParameter("p_status", status, "String", "In");
parm[2] = RptObj.OracleDBParameter("p_fromdate", fromDate, "String", "In");
parm[3] = RptObj.OracleDBParameter("p_todate", toDate, "String", "In");
parm[4] = RptObj.OracleDBParameter("p_trans_type", trans_type, "String", "In");
parm[5] = RptObj.OracleDBParameter("p_selecttype", selecttype, "String", "In");
parm[6] = RptObj.OracleDBParameter("p_BRANCHID", Branchid, "String", "In");
parm[7] = RptObj.OracleDBParameter("p_USERID", Userid, "String", "In");
parm[8] = RptObj.OracleDBParameter("DATA_RESULTSET", "", "Cursor", "Out");
dsReport = RptObj.Oracle_GetDataSetSP("sp_mispayment_CPD", parm);
string totalstub = dsReport.Tables[0].Rows.Count.ToString();
return(dsReport.Tables[0]);
}
public static string GetReportHeader(string reportCode)
{
string headingName = "";
try
{
MCBReportClass RptObj = new MCBReportClass();
OleDbParameter[] param = new OleDbParameter[1];
param[0] = RptObj.OleDbParameter("@v_Report_Code", reportCode, "String", "In");
DataSet dsReport = RptObj.Local_GetDataSetSP1("SP_REPORT_HEADER", param);
if (dsReport.Tables[0].Rows.Count > 0)
{
headingName = dsReport.Tables[0].Rows[0]["HEADING1"].ToString();
}
}
catch (Exception ex)
{ }
return(headingName);
}
//private DataTable GetData(string company_code, string status, string fromDate, string toDate,
//string trans_type, string selecttype)
//{
// MCBReportClass RptObj = new MCBReportClass();
// OracleParameter[] parm = new OracleParameter[8];
// parm[0] = RptObj.OracleDBParameter("p_companycode", companycode, "String", "In");
// parm[1] = RptObj.OracleDBParameter("p_status", status, "String", "In");
// parm[2] = RptObj.OracleDBParameter("p_fromdate", fromDate, "String", "In");
// parm[3] = RptObj.OracleDBParameter("p_todate", toDate, "String", "In");
// parm[4] = RptObj.OracleDBParameter("p_trans_type", trans_type, "String", "In");
// parm[5] = RptObj.OracleDBParameter("p_selecttype", selecttype, "String", "In");
// parm[6] = RptObj.OracleDBParameter("p_usr_name", Session["U_NAME"].ToString(), "String", "In");
// parm[7] = RptObj.OracleDBParameter("DATA_RESULTSET", "", "Cursor", "Out");
// dt = RptObj.Oracle_GetDataSetSP("sp_mispayment", parm).Tables[0];
// return dt;
//}
private DataTable GetData(string companycode, string status, string fromDate, string toDate, string trans_type, string selecttype, string beneAddress, string RemitterName, string FileName)
{
MCBReportClass RptObj = new MCBReportClass();
DataSet dsReport = new DataSet();
OracleParameter[] parm = new OracleParameter[11];
parm[0] = RptObj.OracleDBParameter("p_companycode", "WHO", "String", "In");
parm[1] = RptObj.OracleDBParameter("p_status", status, "String", "In");
parm[2] = RptObj.OracleDBParameter("p_fromdate", fromDate, "String", "In");
parm[3] = RptObj.OracleDBParameter("p_todate", toDate, "String", "In");
parm[4] = RptObj.OracleDBParameter("p_trans_type", trans_type, "String", "In");
parm[5] = RptObj.OracleDBParameter("p_selecttype", selecttype, "String", "In");
parm[6] = RptObj.OracleDBParameter("p_usr_name", Session["U_NAME"].ToString(), "String", "In");
parm[7] = RptObj.OracleDBParameter("p_remitter_name", RemitterName, "String", "In");
parm[8] = RptObj.OracleDBParameter("p_bene_address", beneAddress, "String", "In");
parm[9] = RptObj.OracleDBParameter("p_file_name", FileName, "String", "In");
parm[10] = RptObj.OracleDBParameter("DATA_RESULTSET", "", "Cursor", "Out");
dt = RptObj.Oracle_GetDataSetSP("sp_mispayment_who", parm).Tables[0];
string totalstub = dt.Rows.Count.ToString();
return(dt);
}