protected void Function_LoadCarGrid()
{
try
{
SqlCommand cmd = new SqlCommand("mts_Select_Carriers", Connection);
cmd.CommandType = CommandType.StoredProcedure;
if (Session["role"].ToString() == "1")
{
cmd.Parameters.Add("@role", SqlDbType.NVarChar).Value = int.Parse(Session["role"].ToString());
cmd.Parameters.Add("@fk_CompanyID", SqlDbType.NVarChar).Value = DBNull.Value;
cmd.Parameters.Add("@fk_OrgID", SqlDbType.NVarChar).Value = DBNull.Value;
}
else if (Session["role"].ToString() == "10")
{
cmd.Parameters.Add("@role", SqlDbType.NVarChar).Value = int.Parse(Session["role"].ToString());
cmd.Parameters.Add("@fk_CompanyID", SqlDbType.NVarChar).Value = int.Parse(Session["fk_CompanyID"].ToString());
cmd.Parameters.Add("@fk_OrgID", SqlDbType.NVarChar).Value = DBNull.Value;
}
else
{
cmd.Parameters.Add("@role", SqlDbType.NVarChar).Value = int.Parse(Session["role"].ToString());
cmd.Parameters.Add("@fk_CompanyID", SqlDbType.NVarChar).Value = DBNull.Value;
cmd.Parameters.Add("@fk_OrgID", SqlDbType.NVarChar).Value = int.Parse(Session["fk_OrgID"].ToString());
}
SqlDataAdapter dap = new SqlDataAdapter(cmd);
DataSet DS = new DataSet();
dap.Fill(DS);
if (DS != null)
{
if (DS.Tables[0].Rows.Count != 0)
{
CarGrid.Visible = true;
CarGrid.DataSource = DS.Tables[0];
CarGrid.DataBind();
if (int.Parse(Session["role"].ToString()) != 1)
{
Telerik.Web.UI.GridColumn gd = CarGrid.Columns.FindByUniqueName("Status");
gd.Visible = false;
}
else
{
Telerik.Web.UI.GridColumn gd = CarGrid.Columns.FindByUniqueName("StatusCol");
gd.Visible = true;
}
}
else
{
CarGrid.Visible = false;
lblmsg.Text = "No Records Found..";
}
}
}
catch (Exception ex)
{
}
}
