protected void ddlFile_SelectedIndexChanged(object sender, EventArgs e)
{
DataSet ds = new DataSet();
ds = (DataSet)ViewState["dataset"];
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
if (ddlFile.SelectedValue.ToString() == ds.Tables[0].Rows[i]["FILE_NAME"].ToString())
{
lblTotalRecord.Text = ds.Tables[0].Rows[i]["total_records"].ToString();
lblTotalFile.Attributes.Add("style", "visibility:visible;");
lblTotalRecord.Attributes.Add("style", "visibility:visible;");
}
}
}
GridView1.DataSource = null;
GridView1.DataBind();
GV_TransInfo.DataSource = null;
GV_TransInfo.DataBind();
GV_AvalilableMatch.DataSource = null;
GV_AvalilableMatch.DataBind();
Panel1.Visible = false;
Panel2.Visible = false;
Panel3.Visible = false;
// btnSubmit.Attributes.Add("style", "visibility:hidden;");
lblTransaction.Attributes.Add("style", "visibility:hidden;");
lblFieldTrans.Attributes.Add("style", "visibility:hidden;");
lblMessage.Text = "";
}
private void loadGV_AvalilableMatch()
{
DataSet ds = new DataSet();
OracleParameter[] parms = new OracleParameter[10];
parms[0] = new OracleParameter();
parms[0] = _dbConfig.Oracle_Param("P_company_code", OracleType.VarChar, ParameterDirection.Input, ddlCompanyCode.SelectedValue.ToString());
parms[1] = new OracleParameter();
parms[1] = _dbConfig.Oracle_Param("P_FILE_NAME", OracleType.VarChar, ParameterDirection.Input, ddlFile.SelectedItem.ToString());
parms[2] = new OracleParameter();
parms[2] = _dbConfig.Oracle_Param("P_Trans_type", OracleType.VarChar, ParameterDirection.Input, "");
parms[3] = new OracleParameter();
parms[3] = _dbConfig.Oracle_Param("P_Rowid", OracleType.VarChar, ParameterDirection.Input, ROWID);
parms[4] = new OracleParameter();
parms[4] = _dbConfig.Oracle_Param("p_bank_code", OracleType.VarChar, ParameterDirection.Input, "");
parms[5] = new OracleParameter();
parms[5] = _dbConfig.Oracle_Param("p_branch_code", OracleType.VarChar, ParameterDirection.Input, "");
parms[6] = new OracleParameter();
parms[6] = _dbConfig.Oracle_Param("P_Userid", OracleType.VarChar, ParameterDirection.Input, Session["U_NAME"].ToString());//Session["U_NAME"].ToString()
parms[7] = new OracleParameter();
parms[7] = _dbConfig.Oracle_Param("P_type", OracleType.VarChar, ParameterDirection.Input, "11");
parms[8] = new OracleParameter();
parms[8] = _dbConfig.Oracle_Param("DATA_RESULTSET", OracleType.Cursor, ParameterDirection.Output, "");
parms[9] = new OracleParameter();
parms[9] = _dbConfig.Oracle_Param("v_retval", OracleType.VarChar, ParameterDirection.Output, "");
ds = _dbConfig.Oracle_GetDataSetSP("SP_Data_Segregation", parms);
if (parms[9].Value.ToString() == "")
{
if (ds.Tables[0].Rows.Count > 0)
{
//DataTable dt = new DataTable();
//dt = ds.Tables[0];
// ViewState["TaskTable"] = dt;
GV_AvalilableMatch.DataSource = ds;
//// GridView1.PageSize = 20;
GV_AvalilableMatch.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;");
Panel3.Visible = true;
}
else
{
DataRow dr = ds.Tables[0].NewRow();
ds.Tables[0].Rows.Add(dr);
GV_AvalilableMatch.DataSource = ds.Tables[0];
GV_AvalilableMatch.DataBind();
int Newcell = GV_AvalilableMatch.Rows[0].Cells.Count;
GV_AvalilableMatch.Rows[0].Cells.Clear();
GV_AvalilableMatch.Rows[0].Cells.Add(new TableCell());
GV_AvalilableMatch.Rows[0].Cells[0].ColumnSpan = Newcell;
GV_AvalilableMatch.Rows[0].Cells[0].HorizontalAlign = HorizontalAlign.Center;
GV_AvalilableMatch.Rows[0].Cells[0].Text = "No data found.";
Panel3.Visible = true;
//btnSubmit.Attributes.Add("style", "visibility:hidden;");
//GV_AvalilableMatch.DataSource = null;
//GV_AvalilableMatch.DataBind();
//lblMessage.Text = "No data found.";
// lblTransaction.Text = ds.Tables[0].Rows.Count.ToString();
// lblFieldTrans.Attributes.Add("style", "visibility:hidden;");
// lblTransaction.Attributes.Add("style", "visibility:hidden;");
}
}
}
