public void dllFilename()
{
DataSet ds = new DataSet();
OracleParameter[] parms = new OracleParameter[3];
parms[0] = _dbConfig.Oracle_Param("p_company_code", OracleType.VarChar, ParameterDirection.Input, ddlCompanyCode.SelectedValue.ToString());
parms[1] = _dbConfig.Oracle_Param("data_resultset", OracleType.Cursor, ParameterDirection.Output, "");
parms[2] = _dbConfig.Oracle_Param("v_retval", OracleType.VarChar, ParameterDirection.Output, "");
ds = _dbConfig.Oracle_GetDataSetSP("sp_data_segregation_lov_a2a", parms);
if (ds.Tables[0].Rows.Count > 0)
{
ddlFile.DataSource = ds.Tables[0];
ddlFile.DataValueField = "file_name";
ddlFile.DataTextField = "file_name";
ddlFile.DataBind();
ViewState["dataset"] = ds;
lblTotalRecord.Text = ds.Tables[0].Rows[0]["total_records"].ToString();
lblTotalRecord.Attributes.Add("style", "visibility:visible;");
lblTotalFile.Attributes.Add("style", "visibility:visible;");
}
else
{
ddlFile.DataSource = "";
ddlFile.DataValueField = "";
ddlFile.DataTextField = "";
ddlFile.DataBind();
GridView1.DataSource = null;
GridView1.DataBind();
lblTotalRecord.Attributes.Add("style", "visibility:hidden;");
lblTotalFile.Attributes.Add("style", "visibility:hidden;");
lblTransaction.Attributes.Add("style", "visibility:hidden;");
lblFieldTrans.Attributes.Add("style", "visibility:hidden;");
}
}
public DataSet GetPRIForSymbol(string company_code, string bank_code)
{
if (Session["U_NAME"].ToString() == "")
{
lbl_msg.Text = "User session has been expired, Please Re-Login.";
return(null);
}
DataSet DS = new DataSet();
OracleParameter[] PR = new OracleParameter[3];
PR[0] = _dbConfig.Oracle_Param("p_company_code", OracleType.VarChar, ParameterDirection.Input, company_code);
PR[1] = _dbConfig.Oracle_Param("p_bank_code", OracleType.VarChar, ParameterDirection.Input, bank_code);
PR[2] = _dbConfig.Oracle_Param("p_dataset", OracleType.Cursor, ParameterDirection.Output, "");
DS = _dbConfig.Oracle_GetDataSetSP("sp_get_pri_postforsymbol", PR);
if (DS.Tables[0].Rows.Count > 0)
{
GridView1.DataSource = DS.Tables[0];
GridView1.DataBind();
}
else
{
lbl_msg.Text = "Data not found";
btnSubmit.Visible = false;
}
return(DS);
}
public void dllFilename()
{
DataSet ds = new DataSet();
OracleParameter[] parms = new OracleParameter[3];
parms[0] = _dbConfig.Oracle_Param("p_company_code", OracleType.VarChar, ParameterDirection.Input, ddlCompanyCode.SelectedValue.ToString());
parms[1] = _dbConfig.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, "");
parms[2] = _dbConfig.Oracle_Param("v_retval", OracleType.VarChar, ParameterDirection.Output, "");
ds = _dbConfig.Oracle_GetDataSetSP("SP_Data_Segregation_LOV", parms);
if (ds.Tables[0].Rows.Count > 0)
{
ddlFile.DataSource = ds;
ddlFile.DataValueField = "FILE_NAME";
ddlFile.DataTextField = "FILE_NAME";
ddlFile.DataBind();
ViewState["dataset"] = ds;
lblTotalRecord.Text = ds.Tables[0].Rows[0]["total_records"].ToString();
lblTotalRecord.Attributes.Add("style", "visibility:visible;");
lblTotalFile.Attributes.Add("style", "visibility:visible;");
}
else
{
ddlFile.DataSource = string.Empty;
ddlFile.DataValueField = "";
ddlFile.DataTextField = "";
ddlFile.DataBind();
btnSubmit.Attributes.Add("style", "visibility:hidden;");
grdTransaction.DataSource = null;
grdTransaction.DataBind();
}
}
private void loadGridView1()
{
if (ddlFile.SelectedValue.ToString() != "")
{
DataSet ds = new DataSet();
OracleParameter[] parms = new OracleParameter[3];
parms[0] = _dbConfig.Oracle_Param("p_company_code", OracleType.VarChar, ParameterDirection.Input, ddlCompanyCode.SelectedValue.ToString());
parms[1] = _dbConfig.Oracle_Param("p_file_name", OracleType.VarChar, ParameterDirection.Input, ddlFile.SelectedItem.ToString());
parms[2] = _dbConfig.Oracle_Param("p_data_set", OracleType.Cursor, ParameterDirection.Output, "");
ds = _dbConfig.Oracle_GetDataSetSP("sp_get_acc_completion_publish", parms);
if (ds.Tables[0].Rows.Count > 0)
{
GridView1.DataSource = ds;
GridView1.DataBind();
lblMessage.Text = "";
lblTransaction.Text = ds.Tables[0].Rows.Count.ToString();
btnSubmit.Attributes.Add("style", "visibility:visible;");
lblFieldTrans.Attributes.Add("style", "visibility:visible;");
lblTransaction.Attributes.Add("style", "visibility:visible;");
Panel1.Visible = true;
}
else
{
Panel1.Visible = true;
}
}
}
public void dllFilename()
{
DataSet ds = new DataSet();
DataRow dr = null;
OracleParameter[] parms = new OracleParameter[3];
parms[0] = _dbConfig.Oracle_Param("p_company_code", OracleType.VarChar, ParameterDirection.Input, ddlCompanyCode.SelectedValue.ToString());
parms[1] = _dbConfig.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, "");
parms[2] = _dbConfig.Oracle_Param("v_retval", OracleType.VarChar, ParameterDirection.Output, "");
ds = _dbConfig.Oracle_GetDataSetSP("SP_Data_Segregation_LOV_a2a", parms);
if (ds.Tables[0].Rows.Count > 0)
{
DataTable dt = new DataTable();
dr = ds.Tables[0].NewRow();
dr[0] = "AAA";
dr[1] = "Select";
dr[2] = "Select";
dr[3] = "0";
ds.Tables[0].Rows.Add(dr);
dt = ds.Tables[0];
dt.DefaultView.Sort = "Company_Code ASC";
dt = dt.DefaultView.ToTable();
ddlFile.DataSource = dt;
ddlFile.DataValueField = "FILE_NAME";
ddlFile.DataTextField = "FILE_NAME";
ddlFile.DataBind();
ViewState["dataset"] = dt;
lblTotalRecord.Text = dt.Rows[0]["total_records"].ToString();
lblTotalRecord.Attributes.Add("style", "visibility:visible;");
lblTotalFile.Attributes.Add("style", "visibility:visible;");
}
else
{
ddlFile.DataSource = "";
ddlFile.DataValueField = "";
ddlFile.DataTextField = "";
ddlFile.DataBind();
btnSubmit.Attributes.Add("style", "visibility:hidden;");
GridView1.DataSource = null;
GridView1.DataBind();
lblTotalRecord.Attributes.Add("style", "visibility:hidden;");
lblTotalFile.Attributes.Add("style", "visibility:hidden;");
lblTransaction.Attributes.Add("style", "visibility:hidden;");
lblFieldTrans.Attributes.Add("style", "visibility:hidden;");
lblStart.Attributes.Add("style", "visibility:hidden;");
lblStartTrans.Attributes.Add("style", "visibility:hidden;");
lblEnd.Attributes.Add("style", "visibility:hidden;");
lblEndTrans.Attributes.Add("style", "visibility:hidden;");
}
}
public string GetCustomerFilePath(string ID)
{
OracleParameter[] PR = new OracleParameter[2];
PR[0] = DataTransform.Oracle_Param("v_ID", OracleType.VarChar, ParameterDirection.Input, ID);
PR[1] = DataTransform.Oracle_Param("cv_1", OracleType.Cursor, ParameterDirection.Output, "");
DS = DataTransform.Oracle_GetDataSetSP("GetCustomerFilePath", PR);
//return DS;
//DS = DataTransform.ReteriveDataMultiple("EXEC GetCustomerFilePath " + ID , "GET_ALL_USER");
return(DS.Tables[0].Rows[0][0].ToString());
}
public DataSet GetPRITransForUnpaid(string draftno, string cust_refno, string action)
{
if (Session["U_NAME"].ToString() == "")
{
lbl_msg.Text = "User session has been expired, Please Re-Login.";
return(null);
}
DataSet DS = new DataSet();
OracleParameter[] PR = new OracleParameter[4];
PR[0] = _dbConfig.Oracle_Param("p_draftno", OracleType.VarChar, ParameterDirection.Input, draftno);
PR[1] = _dbConfig.Oracle_Param("p_cust_refno", OracleType.VarChar, ParameterDirection.Input, cust_refno);
PR[2] = _dbConfig.Oracle_Param("p_action", OracleType.VarChar, ParameterDirection.Input, action);
PR[3] = _dbConfig.Oracle_Param("p_dataset", OracleType.Cursor, ParameterDirection.Output, "");
DS = _dbConfig.Oracle_GetDataSetSP("sp_get_pri_trans_for_unpaid", PR);
if (DS.Tables[0].Rows.Count > 0)
{
GridView1.DataSource = DS.Tables[0];
GridView1.DataBind();
}
else
{
GridView1.DataSource = null;
GridView1.DataBind();
btnUnpaid.Visible = false;
}
return(DS);
}
public DBProcess()
{
OracleParameter[] PR = new OracleParameter[2];
PR[0] = DataTransform.Oracle_Param("P_TABLE_NAME", OracleType.VarChar, ParameterDirection.Input, "filelog");
PR[1] = DataTransform.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, "");
ds = DataTransform.Oracle_GetDataSetSP("SP_GET_TABLE_STRUCT", PR);
}
private void loadGrid(string draftno, string customerRef, string account_no)
{
int pno = 0;
DataSet ds = new DataSet();
OracleParameter[] parms = new OracleParameter[7];
parms[pno] = _dbConfig.Oracle_Param("p_DRAFTNO", OracleType.VarChar, ParameterDirection.Input, draftno); pno++;
parms[pno] = _dbConfig.Oracle_Param("p_CUSTREFNUMBER", OracleType.VarChar, ParameterDirection.Input, customerRef); pno++;
parms[pno] = _dbConfig.Oracle_Param("p_account_no", OracleType.VarChar, ParameterDirection.Input, account_no); pno++;
parms[pno] = _dbConfig.Oracle_Param("P_USER_ID", OracleType.VarChar, ParameterDirection.Input, Session["U_NAME"].ToString()); pno++;
parms[pno] = _dbConfig.Oracle_Param("p_rowid", OracleType.VarChar, ParameterDirection.Input, ""); pno++;
parms[pno] = _dbConfig.Oracle_Param("v_retval", OracleType.VarChar, ParameterDirection.Output, ""); pno++;
parms[pno] = _dbConfig.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, "");
ds = _dbConfig.Oracle_GetDataSetSP("sp_Trans_Enquiry", parms);
if (ds.Tables[0].Rows.Count > 0)
{
DataTable dt = new DataTable();
dt = ds.Tables[0];
ViewState["TaskTable"] = dt;
GridView1.DataSource = ds;
GridView1.DataBind();
lblRecord.Text = ds.Tables[0].Rows.Count.ToString() + " Record(s) found.";
//btnPrint.Attributes.Add("style", "visibility:visible;");
btnPrint.Attributes.Add("style", "visibility:visible;");
}
else
{
btnPrint.Attributes.Add("style", "visibility:hidden;");
GridView1.DataSource = null;
GridView1.DataBind();
lblMessage.Text = "";
//lblMessage.Text = "No data found.";
lblRecord.Text = "";
}
}
public TABLE_SPDS_DataLoadCofiguration()
{
OracleParameter[] PR = new OracleParameter[2];
PR[0] = DataTransform.Oracle_Param("P_TABLE_NAME", OracleType.VarChar, ParameterDirection.Input, "CONFIG_DEF_MASTER");
PR[1] = DataTransform.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, "");
SPDS_DataLoadCofiguration_DATASET = DataTransform.Oracle_GetDataSetSP("SP_GET_TABLE_STRUCT", PR);
}
private void loadGrid()
{
string p_return = "";
DataTable dt = new DataTable();
OracleParameter[] parms = new OracleParameter[5];
parms[0] = _dbConfig.Oracle_Param("p_custnic", OracleType.VarChar, ParameterDirection.Input, txtCNIC.Text);
parms[1] = _dbConfig.Oracle_Param("p_branch_cd", OracleType.VarChar, ParameterDirection.Input, txtBranchCode.Text);
parms[2] = _dbConfig.Oracle_Param("p_accno", OracleType.VarChar, ParameterDirection.Input, txtAccNo.Text);
parms[3] = _dbConfig.Oracle_Param("p_iban", OracleType.VarChar, ParameterDirection.Input, txbIBAN.Text);
parms[4] = _dbConfig.Oracle_Param("data_resultset", OracleType.Cursor, ParameterDirection.Output, "");
dt = _dbConfig.Oracle_GetDataSetSP("sp_core_bank_acc_enquiry", parms).Tables[0];
if (dt.Rows.Count > 0)
{
ViewState["TaskTable"] = dt;
GridView1.DataSource = dt;
GridView1.DataBind();
}
else
{
ViewState["TaskTable"] = null;
GridView1.DataSource = null;
GridView1.DataBind();
lblMessage.Text = "No record found.";
}
}
private void loadGrid(string check)
{
DataSet ds = new DataSet();
OracleParameter[] parms = new OracleParameter[3];
int pno = 0;
parms[pno] = new OracleParameter();
parms[pno] = _dbConfig.Oracle_Param("p_account_no", OracleType.VarChar, ParameterDirection.Input, txtAccountNo.Text);
pno++;
parms[pno] = new OracleParameter();
parms[pno] = _dbConfig.Oracle_Param("p_branch_code", OracleType.VarChar, ParameterDirection.Input, txtBranchCode.Text);
pno++;
parms[pno] = new OracleParameter();
parms[pno] = _dbConfig.Oracle_Param("DATA_SET", OracleType.Cursor, ParameterDirection.Output, "");
ds = _dbConfig.Oracle_GetDataSetSP("sp_depository_fetch", parms);
if (ds.Tables[0].Rows.Count > 0)
{
DataTable dt = new DataTable();
dt = ds.Tables[0];
GridView1.DataSource = ds;
GridView1.DataBind();
btnSubmit.Attributes.Add("style", "visibility:visible");
if (check != "S")
{
lblMessage.Text = "";
}
}
else if (check == "S")
{
GridView1.DataSource = null;
GridView1.DataBind();
}
else
{
GridView1.DataSource = null;
GridView1.DataBind();
lblMessage.Text = "No data found.";
}
#region
//if (grdTransaction.Rows.Count <= 0)
//{
// DataRow dr = ds.Tables[0].NewRow();
// ds.Tables[0].Rows.Add(dr);
// this.grdTransaction.DataSource = ds.Tables[0];
// this.grdTransaction.DataBind();
// this.grdTransaction.Rows[0].Cells.Clear();
// this.grdTransaction.Rows[0].Cells.Add(new TableCell());
// this.grdTransaction.Rows[0].Cells[0].ColumnSpan = grdTransaction.Rows[0].Cells.Count;
// this.grdTransaction.Rows[0].Cells[0].Text = "No Record found.";
//}
#endregion
}
protected void btnRollBack_Click(object sender, EventArgs e)
{
try
{
string p_return = "";
DataSet ds = new DataSet();
OracleParameter[] parms = new OracleParameter[10];
parms[0] = _dbConfig.Oracle_Param("P_company_code", OracleType.VarChar, ParameterDirection.Input, ddlCompanyCode.SelectedValue.ToString());
parms[1] = _dbConfig.Oracle_Param("P_FILE_NAME", OracleType.VarChar, ParameterDirection.Input, ViewState["fileName"].ToString());
parms[2] = _dbConfig.Oracle_Param("P_Trans_type", OracleType.VarChar, ParameterDirection.Input, "");
parms[3] = _dbConfig.Oracle_Param("P_Rowid", OracleType.VarChar, ParameterDirection.Input, "");
parms[4] = _dbConfig.Oracle_Param("p_bank_code", OracleType.VarChar, ParameterDirection.Input, "");
parms[5] = _dbConfig.Oracle_Param("p_branch_code", OracleType.VarChar, ParameterDirection.Input, "");
parms[6] = _dbConfig.Oracle_Param("P_Userid", OracleType.VarChar, ParameterDirection.Input, Session["U_NAME"].ToString());
parms[7] = _dbConfig.Oracle_Param("P_type", OracleType.VarChar, ParameterDirection.Input, "16");
parms[8] = _dbConfig.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, "");
parms[9] = _dbConfig.Oracle_Param("v_retval", OracleType.VarChar, ParameterDirection.Output, "");
ds = _dbConfig.Oracle_GetDataSetSP("SP_Data_Segregation", parms);
p_return = ds.Tables[0].Rows[0][0].ToString().Split(';').GetValue(1).ToString();
lbl_Message.Text = p_return;
Databind(ddlCompanyCode.SelectedValue, ViewState["fileName"].ToString());
lblIBFT.Text = "";
lblA2A.Text = "";
lblPRI.Text = "";
lblCOC.Text = "";
lblDD.Text = "";
lblDuplicateRecords.Text = "";
lblInvalidIBANRecords.Text = "";
lblTotalRecord.Text = "";
lblTotalAmount.Text = "";
lblIBFTTOT.Text = "";
lblA2ATOT.Text = "";
lblPRITOT.Text = "";
lblCOCTOT.Text = "";
lblDDTOT.Text = "";
lblDUPTOT.Text = "";
lblIBANTOT.Text = "";
}
catch (Exception ex)
{
lbl_Message.Text = ex.Message;
}
}
public TABLE_CMN_CUST_BAL()
{
DataSet DS = new DataSet();
OracleParameter[] PR = new OracleParameter[2];
PR[0] = DataTransform.Oracle_Param("P_TABLE_NAME", OracleType.VarChar, ParameterDirection.Input, "RPS_CUSTOMER_BALANCE");
PR[1] = DataTransform.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, "");
dsResult = DataTransform.Oracle_GetDataSetSP("SP_GET_TABLE_STRUCT", PR);
}
private void GetStatusCodeBind()
{
DataSet dsReport = new DataSet();
OracleParameter[] parm = new OracleParameter[3];
parm[0] = _dbConfig.Oracle_Param("v_StatusCode", OracleType.VarChar, ParameterDirection.Input, "%");
parm[1] = _dbConfig.Oracle_Param("v_Description", OracleType.VarChar, ParameterDirection.Input, "%");
parm[2] = _dbConfig.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, "");
DataSet ds = _dbConfig.Oracle_GetDataSetSP("SP_RPS_DetailStatus_LOV", parm);
if (ds.Tables[0].Rows.Count > 0)
{
ddlCancelCode.DataSource = ds.Tables[0];
ddlCancelCode.DataTextField = "DESCRIPTION";
ddlCancelCode.DataValueField = "code";
ddlCancelCode.DataBind();
}
}
protected DataSet Fetch_DPAGE()
{
DatabaseConnection_Util db = new DatabaseConnection_Util();
DataSet ds = new DataSet();
OracleParameter[] param = new OracleParameter[1];
param[0] = db.Oracle_Param("data_resultset", OracleType.Cursor, ParameterDirection.Output, "");
ds = db.Oracle_GetDataSetSP("sp_web_setup_getdpage", param);
return(ds);
}
public DataTable get_data_cust_fund(string p_batch_no)
{
DataSet ds = new DataSet();
OracleParameter[] param = new OracleParameter[2];
param[0] = _dbConfig.Oracle_Param("p_batch_no", OracleType.VarChar, ParameterDirection.Input, p_batch_no);
param[1] = _dbConfig.Oracle_Param("p_dataset", OracleType.Cursor, ParameterDirection.Output, "");
ds = _dbConfig.Oracle_GetDataSetSP("sp_get_cust_funding_upd", param);
return(ds.Tables[0]);
}
public TABLE_SPDS_AuthorizationMatrix()
{
//SPDS_AuthorizationMatrix_DATASET = DataTransform.ReteriveDataMultiple
// ("EXEC SP_GET_TABLE_STRUCT SPDS_AuthorizationMatrix", "NEW_USER_INFO");
OracleParameter[] PR = new OracleParameter[2];
PR[0] = DataTransform.Oracle_Param("P_TABLE_NAME", OracleType.VarChar, ParameterDirection.Input, "SPDS_AuthorizationMatrix");
PR[1] = DataTransform.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, "");
SPDS_AuthorizationMatrix_DATASET = DataTransform.Oracle_GetDataSetSP("SP_GET_TABLE_STRUCT", PR);
}
public DataSet Get_DuplicateData(string CompanyCode, string filename)
{
OracleParameter[] PR = new OracleParameter[3];
PR[0] = _dbConfig.Oracle_Param("P_company_code", OracleType.VarChar, ParameterDirection.Input, CompanyCode);
PR[1] = _dbConfig.Oracle_Param("P_FILE_NAME", OracleType.VarChar, ParameterDirection.Input, filename);
PR[2] = _dbConfig.Oracle_Param("data_set", OracleType.Cursor, ParameterDirection.Output, "");
ds = _dbConfig.Oracle_GetDataSetSP("sp_get_duplicate_records", PR);
ViewState["TaskTable"] = ds.Tables[0];
return(ds);
}
public TABLE_SPDS_UniversalUploadCofigurationDetail()
{
// SPDS_UniversalUploadCofigurationDetail_DATASET = DataTransform.ReteriveDataMultiple
// ("EXEC SP_GET_TABLE_STRUCT SPDS_UniversalUploadCofigurationDetail","NEW_USER_INFO");
OracleParameter[] PR = new OracleParameter[2];
PR[0] = DataTransform.Oracle_Param("P_TABLE_NAME", OracleType.VarChar, ParameterDirection.Input, "SPDS_UNIVUploadCofiguration");
PR[1] = DataTransform.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, "");
SPDS_UniversalUploadCofigurationDetail_DATASET = DataTransform.Oracle_GetDataSetSP("SP_GET_TABLE_STRUCT", PR);
}
public TABLE_RPS_MoneyGramRemittance()
{
//RPS_MoneyGramRemittance_DATASET = DataTransform.ReteriveDataMultiple
// ("EXEC SP_GET_TABLE_STRUCT RPS_MoneyGramRemittance","NEW_USER_INFO");
OracleParameter[] PR = new OracleParameter[2];
PR[0] = DataTransform.Oracle_Param("P_TABLE_NAME", OracleType.VarChar, ParameterDirection.Input, "RPS_MoneyGramRemittance");
PR[1] = DataTransform.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, "");
RPS_MoneyGramRemittance_DATASET = DataTransform.Oracle_GetDataSetSP("SP_GET_TABLE_STRUCT", PR);
}
private void loadGrid(string type)
{
DataSet ds = new DataSet();
OracleParameter[] parms = new OracleParameter[6];
parms[0] = new OracleParameter();
parms[0] = _dbConfig.Oracle_Param("p_DRAFTNO", OracleType.VarChar, ParameterDirection.Input, txtDraftNo.Text);
parms[1] = new OracleParameter();
parms[1] = _dbConfig.Oracle_Param("p_CUSTREFNUMBER", OracleType.VarChar, ParameterDirection.Input, txtCustomerRef.Text);
parms[2] = new OracleParameter();
parms[2] = _dbConfig.Oracle_Param("P_USER_ID", OracleType.VarChar, ParameterDirection.Input, Session["U_NAME"].ToString());
parms[3] = new OracleParameter();
parms[3] = _dbConfig.Oracle_Param("p_rowid", OracleType.VarChar, ParameterDirection.Input, "");
parms[4] = new OracleParameter();
parms[4] = _dbConfig.Oracle_Param("v_retval", OracleType.VarChar, ParameterDirection.Output, "");
parms[5] = new OracleParameter();
parms[5] = _dbConfig.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, "");
ds = _dbConfig.Oracle_GetDataSetSP("sp_afterPublish_fetch", parms);
if (ds.Tables[0].Rows.Count > 0)
{
DataTable dt = new DataTable();
dt = ds.Tables[0];
ViewState["TaskTable"] = dt;
GridView1.DataSource = ds;
GridView1.DataBind();
lblRecord.Text = dt.Rows.Count.ToString() + " Record(s) found.";
if (type == "E")
{
lblMessage.Text = lblMessage.Text;
}
else
{
lblMessage.Text = "";
}
//btnPrint.Attributes.Add("style", "visibility:visible;");
//btnPrint.Attributes.Add("style", "visibility:visible;");
}
else
{
//btnPrint.Attributes.Add("style", "visibility:hidden;");
GridView1.DataSource = null;
GridView1.DataBind();
lblRecord.Text = "";
lblMessage.Text = "No data found.";
}
}
public TABLE_PRIFileSetup()
{
//PRIFileSetup_DATASET = DataTransform.ReteriveDataMultiple
// ("EXEC SP_GET_TABLE_STRUCT PRIFileSetup", "NEW_USER_INFO");
DataSet DS = new DataSet();
OracleParameter[] PR = new OracleParameter[2];
PR[0] = DataTransform.Oracle_Param("P_TABLE_NAME", OracleType.VarChar, ParameterDirection.Input, "PRIFileSetup");
PR[1] = DataTransform.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, "");
PRIFileSetup_DATASET = DataTransform.Oracle_GetDataSetSP("SP_GET_TABLE_STRUCT", PR);
}
private void loadGrid()
{
DataSet ds = new DataSet();
OracleParameter[] parms = new OracleParameter[8];
parms[0] = new OracleParameter();
parms[0] = _dbConfig.Oracle_Param("P_Accountnumber", OracleType.VarChar, ParameterDirection.Input, txtAccountNo.Text);
parms[1] = new OracleParameter();
parms[1] = _dbConfig.Oracle_Param("P_custnic", OracleType.VarChar, ParameterDirection.Input, txtCNIC.Text);
parms[2] = new OracleParameter();
parms[2] = _dbConfig.Oracle_Param("P_accounttitle", OracleType.VarChar, ParameterDirection.Input, txtAccountTitle.Text);
parms[3] = new OracleParameter();
parms[3] = _dbConfig.Oracle_Param("P_branch_code", OracleType.VarChar, ParameterDirection.Input, txtBranchCode.Text);
parms[4] = new OracleParameter();
parms[4] = _dbConfig.Oracle_Param("p_branch_loc", OracleType.VarChar, ParameterDirection.Input, txtBrLocation.Text);
parms[5] = new OracleParameter();
parms[5] = _dbConfig.Oracle_Param("p_branch_city", OracleType.VarChar, ParameterDirection.Input, txtCity.Text);
parms[6] = new OracleParameter();
parms[6] = _dbConfig.Oracle_Param("p_type", OracleType.VarChar, ParameterDirection.Input, ViewState["TYPE"].ToString());
parms[7] = new OracleParameter();
parms[7] = _dbConfig.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, "");
ds = _dbConfig.Oracle_GetDataSetSP("ENQUIRY_DATA", parms);
if (ds.Tables[0].Rows.Count > 0)
{
DataTable dt = new DataTable();
dt = ds.Tables[0];
ViewState["TaskTable"] = dt;
GridView1.DataSource = ds;
GridView1.DataBind();
lblRecord.Text = ds.Tables[0].Rows.Count.ToString() + " Record(s) found.";
//btnPrint.Attributes.Add("style", "visibility:visible;");
btnPrint.Attributes.Add("style", "visibility:visible;");
}
else
{
btnPrint.Attributes.Add("style", "visibility:hidden;");
GridView1.DataSource = null;
GridView1.DataBind();
lblMessage.Text = "";
//lblMessage.Text = "No data found.";
lblRecord.Text = "";
}
}
private void loadGrid(string file_name)
{
int pno = 0;
DataSet ds = new DataSet();
OracleParameter[] parms = new OracleParameter[10];
parms[pno] = _dbConfig.Oracle_Param("P_company_code", OracleType.VarChar, ParameterDirection.Input, ddlCompanyCode.SelectedValue); pno++;
parms[pno] = _dbConfig.Oracle_Param("P_FILE_NAME", OracleType.VarChar, ParameterDirection.Input, file_name); pno++;
parms[pno] = _dbConfig.Oracle_Param("P_Trans_type", OracleType.VarChar, ParameterDirection.Input, ""); pno++;
parms[pno] = _dbConfig.Oracle_Param("P_Rowid", OracleType.VarChar, ParameterDirection.Input, ""); pno++;
parms[pno] = _dbConfig.Oracle_Param("p_bank_code", OracleType.VarChar, ParameterDirection.Input, ""); pno++;
parms[pno] = _dbConfig.Oracle_Param("p_branch_code", OracleType.VarChar, ParameterDirection.Input, ""); pno++;
parms[pno] = _dbConfig.Oracle_Param("P_Userid", OracleType.VarChar, ParameterDirection.Input, ""); pno++;
parms[pno] = _dbConfig.Oracle_Param("P_type", OracleType.VarChar, ParameterDirection.Input, "09"); pno++;
parms[pno] = _dbConfig.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, ""); pno++;
parms[pno] = _dbConfig.Oracle_Param("v_retval", OracleType.VarChar, ParameterDirection.Output, "");
ds = _dbConfig.Oracle_GetDataSetSP("SP_Data_Segregation", parms);
if (parms[pno].Value.ToString() == "")
{
if (ds.Tables[0].Rows.Count > 0)
{
DataTable dt = new DataTable();
dt = ds.Tables[0];
GridView1.DataSource = ds;
GridView1.DataBind();
lblMessage.Text = "";
}
else
{
GridView1.EmptyDataText = "DATA NOT FOUND";
GridView1.DataSource = null;
GridView1.DataBind();
}
}
else
{
lblMessage.Text = parms[pno].Value.ToString();
}
}
private void loadGrid(string draft_no, string reference_no, string account_no, string user_id, string company_code)
{
int pno = 0;
DataSet ds = new DataSet();
OracleParameter[] parms = new OracleParameter[7];
parms[pno] = _dbConfig.Oracle_Param("p_DRAFTNO", OracleType.VarChar, ParameterDirection.Input, draft_no); pno++;
parms[pno] = _dbConfig.Oracle_Param("p_CUSTREFNUMBER", OracleType.VarChar, ParameterDirection.Input, reference_no); pno++;
parms[pno] = _dbConfig.Oracle_Param("p_account_no", OracleType.VarChar, ParameterDirection.Input, account_no); pno++;
parms[pno] = _dbConfig.Oracle_Param("P_USER_ID", OracleType.VarChar, ParameterDirection.Input, user_id); pno++;
parms[pno] = _dbConfig.Oracle_Param("p_rowid", OracleType.VarChar, ParameterDirection.Input, company_code); pno++;
parms[pno] = _dbConfig.Oracle_Param("v_retval", OracleType.VarChar, ParameterDirection.Output, ""); pno++;
parms[pno] = _dbConfig.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, "");
ds = _dbConfig.Oracle_GetDataSetSP("sp_Trans_Enquiry", parms);
if (ds.Tables[0].Rows.Count > 0)
{
lbl_CompanyCode.Text = ds.Tables[0].Rows[0]["company_code"].ToString();
lbl_CompanyName.Text = ds.Tables[0].Rows[0]["company_name"].ToString();
lbl_DraftNo.Text = ds.Tables[0].Rows[0]["draftno"].ToString();
lbl_Amount.Text = ds.Tables[0].Rows[0]["draftamount"].ToString();
lbl_TransNo.Text = ds.Tables[0].Rows[0]["trans_no"].ToString();
lbl_TransactionDate.Text = ds.Tables[0].Rows[0]["draftdate"].ToString();
lbl_CustomerRef.Text = ds.Tables[0].Rows[0]["CUSTREFNUMBER"].ToString();
lbl_PaymentDate.Text = ds.Tables[0].Rows[0]["E_DATETIME"].ToString();
lbl_TransType.Text = ds.Tables[0].Rows[0]["trans_type"].ToString();
lbl_TransferMethod.Text = ds.Tables[0].Rows[0]["transfer_method"].ToString();
lbl_BeneficiaryName.Text = ds.Tables[0].Rows[0]["bene_name"].ToString();
lbl_BeneficiaryAddress.Text = ds.Tables[0].Rows[0]["bene_address"].ToString();
lbl_AccountNo.Text = ds.Tables[0].Rows[0]["ACCOUNTNO"].ToString();
lbl_CNIC.Text = ds.Tables[0].Rows[0]["NICNO"].ToString();
lbl_ContactNo.Text = ds.Tables[0].Rows[0]["PHONENO"].ToString();
lbl_PayeeBranch.Text = ds.Tables[0].Rows[0]["paybranchid"].ToString();
lbl_BankCode.Text = ds.Tables[0].Rows[0]["correspondingbankid"].ToString();
lbl_BankName.Text = ds.Tables[0].Rows[0]["bank_name"].ToString();
lbl_BranchCode.Text = ds.Tables[0].Rows[0]["branchid"].ToString();
lbl_BranchName.Text = ds.Tables[0].Rows[0]["branch_name"].ToString();
lbl_RemitterName.Text = ds.Tables[0].Rows[0]["rem_name"].ToString();
lbl_Status.Text = ds.Tables[0].Rows[0]["STATUS"].ToString();
lbl_CancelDate.Text = ds.Tables[0].Rows[0]["canceldate"].ToString();
lbl_Remarks.Text = ds.Tables[0].Rows[0]["remarks"].ToString();
}
//DataTable dt = new DataTable();
//dt = ds.Tables[0];
//ViewState["TaskTable"] = dt;
//GridView1.DataSource = ds;
//GridView1.DataBind();
//lblRecord.Text = ds.Tables[0].Rows.Count.ToString() + " Record(s) found.";
//btnPrint.Attributes.Add("style", "visibility:visible;");
}
public void GridBind()
{
try
{
DataSet DS = new DataSet();
OracleParameter[] PR = new OracleParameter[1];
PR[0] = DataTransform.Oracle_Param("data_resultset", OracleType.Cursor, ParameterDirection.Output, "");
DS = DataTransform.Oracle_GetDataSetSP("sp_getpridatafodownload", PR);
if (DS.Tables[0].Rows.Count > 0)
{
GridView1.DataSource = DS;
GridView1.DataBind();
}
else
{
GridView1.DataSource = null;
GridView1.DataBind();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void ddlCompanyName()
{
DataSet ds = new DataSet();
DatabaseConnection_Util DataTransform = new DatabaseConnection_Util();
OracleParameter[] PR = new OracleParameter[1];
PR[0] = DataTransform.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, "");
ds = DataTransform.Oracle_GetDataSetSP("GetCompanyName", PR);
if (ds.Tables[0].Rows.Count > 0)
{
ddlCompanyCode.DataSource = ds.Tables[0];
ddlCompanyCode.DataTextField = "COMPANY_NAME";
ddlCompanyCode.DataValueField = "COMPANY_CODE";
ddlCompanyCode.DataBind();
}
ddlCompanyCode.Items.Insert(0, new ListItem("All", ""));
}
public DataTable GridDataSource()
{
DataTable dt = new DataTable();
try
{
OracleParameter[] PR = new OracleParameter[4];
PR[0] = _dbConfig.Oracle_Param("p_company_code", OracleType.VarChar, ParameterDirection.Input, ViewState["CompanyCode"].ToString() == "" ? "" : ViewState["CompanyCode"].ToString());
PR[1] = _dbConfig.Oracle_Param("p_from_dt", OracleType.VarChar, ParameterDirection.Input, txtFormDate.Text);
PR[2] = _dbConfig.Oracle_Param("p_to_dt", OracleType.VarChar, ParameterDirection.Input, txtToDate.Text);
PR[3] = _dbConfig.Oracle_Param("data_set", OracleType.Cursor, ParameterDirection.Output, "");
dt = _dbConfig.Oracle_GetDataSetSP("sp_core_nr_ac_satmnt_rpt", PR).Tables[0];
}
catch (Exception ex)
{
lblMessage.Text = ex.Message;
}
return(dt);
}
public void executeStatusData(string filename)
{
DataSet ds = new DataSet();
OracleParameter[] parms = new OracleParameter[2];
parms[0] = db.Oracle_Param("P_FILE_NAME", OracleType.VarChar, ParameterDirection.Input, filename);
parms[1] = db.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, "");
ds = db.Oracle_GetDataSetSP("sp_cancelwhoxpin_status", parms);
if (ds.Tables[0].Rows.Count > 0)
{
GridView1.DataSource = ds;
GridView1.DataBind();
}
else
{
GridView1.DataSource = null;
GridView1.DataBind();
}
}