protected void btnGenerate_Click(object sender, EventArgs e)
{
CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global();
SqlConnection conn = null;
SqlCommand cmd = null;
DataTable dtDataByfilter = null;
string query = string.Empty;
conn = new SqlConnection(obj.GetConnectionString());
conn.Open();
cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandTimeout = 3600;
cmd.CommandType = CommandType.StoredProcedure;
query = "[dbo].[ACX_GETUSERDETAILS]";
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@State", ddlState.SelectedItem.Value);
if (ddlSiteId.SelectedItem.Value == "All")
{
cmd.Parameters.AddWithValue("@SITECODE", "");
}
else
{
cmd.Parameters.AddWithValue("@SITECODE", ddlSiteId.SelectedItem.Value);
}
if (rdoDistributor.Checked == true)
{
cmd.Parameters.AddWithValue("@USERTYPE", "DISTRIBUTOR");
}
else
{
cmd.Parameters.AddWithValue("@USERTYPE", "PSRVRS");
}
dtDataByfilter = new DataTable();
dtDataByfilter.Load(cmd.ExecuteReader());
DataTable dt = new DataTable();
dt = dtDataByfilter;
if (dt.Rows.Count > 0)
{
gridLoginDetails.DataSource = dt;
gridLoginDetails.DataBind();
LblMessage.Text = "Total Records : " + dt.Rows.Count.ToString();
}
else
{
gridLoginDetails.DataSource = dt;
gridLoginDetails.DataBind();
LblMessage.Text = string.Empty;
}
}
