private void bindMSATranHistoryGrd()
{
try
{
grdMSATranReport.DataSource = null;
grdMSATranReport.DataBind();
bool Status = g.CheckSuperAdmin(Convert.ToInt32(Session["User_ID"]));
// Check super Admin condition
#region supper Admin wise
string searchValue = txtsearchValue.Text.Trim();
searchValue = Regex.Replace(searchValue, @"\s+", " ");
string stprocedure = "spMSATransactionReport";
DataTable dt = new DataTable();
if (Status == true)
{
if (ddlcust.SelectedIndex == 0)
{
DataSet ds = q.ProcdureWith7Param(stprocedure, 1, 0, 0, "", "", "", "");
dt = ds.Tables[0];
}
if (ddlcust.SelectedIndex > 0)
{
int custId = Convert.ToInt32(ddlcust.SelectedValue);
if (ddlsortby.SelectedItem.Text == "All")
{
DataSet ds = q.ProcdureWith7Param(stprocedure, 2, custId, 0, "", "", "", "");
dt = ds.Tables[0];
}
else if (ddlsortby.SelectedItem.Text == "Gauge Id-Wise")
{
try
{
int gaugeId = Convert.ToInt32(searchValue);
DataSet ds = q.ProcdureWith7Param(stprocedure, 3, custId, gaugeId, "", "", "", "");
dt = ds.Tables[0];
}
catch (Exception ex)
{
g.ShowMessage(this.Page, "Gauge Id is accept only numeric value. " + ex.Message);
}
}
else if (ddlsortby.SelectedItem.Text == "Gauge Name-Wise")
{
DataSet ds = q.ProcdureWith7Param(stprocedure, 4, custId, 0, searchValue, "", "", "");
dt = ds.Tables[0];
}
else if (ddlsortby.SelectedItem.Text == "Gauge Sr.No.-Wise")
{
DataSet ds = q.ProcdureWith7Param(stprocedure, 5, custId, 0, "", searchValue, "", "");
dt = ds.Tables[0];
}
else if (ddlsortby.SelectedItem.Text == "Manufacture Id-Wise")
{
DataSet ds = q.ProcdureWith7Param(stprocedure, 6, custId, 0, "", "", searchValue, "");
dt = ds.Tables[0];
}
else if (ddlsortby.SelectedItem.Text == "Gauge Type-Wise")
{
DataSet ds = q.ProcdureWith7Param(stprocedure, 7, custId, 0, "", "", "", searchValue);
dt = ds.Tables[0];
}
}
grdMSATranReport.DataSource = dt;
grdMSATranReport.DataBind();
}
#endregion
#region employee wise
else
{
int custId = Convert.ToInt32(Session["Customer_ID"]);
if (ddlsortby.SelectedItem.Text == "All")
{
DataSet ds = q.ProcdureWith7Param(stprocedure, 2, custId, 0, "", "", "", "");
dt = ds.Tables[0];
}
else if (ddlsortby.SelectedItem.Text == "Gauge Id-Wise")
{
try
{
int gaugeId = Convert.ToInt32(searchValue);
DataSet ds = q.ProcdureWith7Param(stprocedure, 3, custId, gaugeId, "", "", "", "");
dt = ds.Tables[0];
}
catch (Exception ex)
{
g.ShowMessage(this.Page, "Gauge Id is accept only numeric value. " + ex.Message);
}
}
else if (ddlsortby.SelectedItem.Text == "Gauge Name-Wise")
{
DataSet ds = q.ProcdureWith7Param(stprocedure, 4, custId, 0, searchValue, "", "", "");
dt = ds.Tables[0];
}
else if (ddlsortby.SelectedItem.Text == "Gauge Sr.No.-Wise")
{
DataSet ds = q.ProcdureWith7Param(stprocedure, 5, custId, 0, "", searchValue, "", "");
dt = ds.Tables[0];
}
else if (ddlsortby.SelectedItem.Text == "Manufacture Id-Wise")
{
DataSet ds = q.ProcdureWith7Param(stprocedure, 6, custId, 0, "", "", searchValue, "");
dt = ds.Tables[0];
}
else if (ddlsortby.SelectedItem.Text == "Gauge Type-Wise")
{
DataSet ds = q.ProcdureWith7Param(stprocedure, 7, custId, 0, "", "", "", searchValue);
dt = ds.Tables[0];
}
grdMSATranReport.DataSource = dt;
grdMSATranReport.DataBind();
}
#endregion
checkAuthority();
}
catch (Exception ex)
{
g.ShowMessage(this.Page, ex.Message);
}
}