protected void WarehouseDropDownList_SelectedIndexChanged(object sender, EventArgs e)
{
BatchDropDownList.SelectedIndex = -1;
LocationDropDownList.SelectedIndex = -1;
InventoryQuantityTextBox.Text = String.Empty;
PhysicalQuantityTextBox.Text = String.Empty;
ReconciledDateTextBox.Text = String.Empty;
InventoryQuantityTextBox.Text = string.Empty;
ListItem first = BatchDropDownList.Items[0];
LocationDropDownList.Items.Clear();
LocationDropDownList.Items.Add(first);
LocationDropDownList.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Panel3.Visible = false;
Panel2.Visible = false;
Panel1.Visible = true;
string CS = ConfigurationManager.ConnectionStrings["EnrollInJob"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
/**creating SqlCommand for Category DropDown list to sotre category name from database */
SqlCommand cmd1 = new SqlCommand();
cmd1.CommandText = "Select CategoryId, CategoryName from JobCategory";
cmd1.Connection = con;
con.Open();//open connection for all
SqlDataReader rdr1 = cmd1.ExecuteReader();
CategoryDropDown.DataTextField = "CategoryName";
CategoryDropDown.DataValueField = "CategoryId";
CategoryDropDown.DataSource = rdr1;
CategoryDropDown.DataBind();
ListItem l1 = new ListItem("Select Category", "-1");
CategoryDropDown.Items.Insert(0, l1);
rdr1.Close();//close rdr1 SqlDataReader to write another new Query
/*******************************************************/
/** creating SqlCommand for Location dropdown to store city name from database */
SqlCommand cmd2 = new SqlCommand();
cmd2.CommandText = "Select PinCode,CityName from cities";
cmd2.Connection = con;
SqlDataReader rdr2 = cmd2.ExecuteReader();
LocationDropDownList.DataTextField = "CityName";
LocationDropDownList.DataValueField = "PinCode";
LocationDropDownList.DataSource = rdr2;
LocationDropDownList.DataBind();
ListItem selectLocation = new ListItem("Select Location", "-1");
LocationDropDownList.Items.Insert(0, selectLocation);
rdr2.Close();
/***************************************************************/
}
}
}