private void GetStates(string Location)
{
try
{
int locationid = 0;
if (Location.Trim() == "INDG" || Location.Trim() == "INBH")
{
locationid = 1;
}
else
{
locationid = 2;
}
Attendance.BAL.Report obj = new Report();
DataTable dt = obj.GetAllStates(locationid);
ddlEmpState.DataSource = dt;
ddlEmpState.DataTextField = "StateName";
ddlEmpState.DataValueField = "StateID";
ddlEmpState.DataBind();
ddlCn1State.DataSource = dt;
ddlCn1State.DataTextField = "StateName";
ddlCn1State.DataValueField = "StateID";
ddlCn1State.DataBind();
ddlCn2State.DataSource = dt;
ddlCn2State.DataTextField = "StateName";
ddlCn2State.DataValueField = "StateID";
ddlCn2State.DataBind();
ddlCn3State.DataSource = dt;
ddlCn3State.DataTextField = "StateName";
ddlCn3State.DataValueField = "StateID";
ddlCn3State.DataBind();
}
catch (Exception ex)
{
}
}