protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { DropDownList2.Items.Clear(); DropDownList2.Items.Add(new ListItem("--Select--", "0")); int wardId = Convert.ToInt32(DropDownList1.SelectedValue); GetWardNumberBL objGetWardNumberBL = new GetWardNumberBL(); DropDownList2.DataSource = objGetWardNumberBL.GetWardNumber(wardId); DropDownList2.DataTextField = "WARD_NUMBER"; DropDownList2.DataBind(); }
protected void DropDownList3_SelectedIndexChanged(object sender, EventArgs e) { int wardId = Convert.ToInt32(DropDownList3.Text); GetWardNumberBL objGetWardNumberBL = new GetWardNumberBL(); DropDownList5.Items.Clear(); DropDownList5.Items.Add(new ListItem("--Select--", "0")); DropDownList5.DataSource = objGetWardNumberBL.GetWardNumber(wardId); DropDownList5.DataTextField = "WARD_NUMBER"; DropDownList5.DataBind(); }
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { int wardId = Convert.ToInt32(DropDownList1.SelectedValue); GetWardNumberBL objGetWardNumberBL = new GetWardNumberBL(); DataSet ds = new DataSet(); ds = objGetWardNumberBL.GetWardNumber(wardId); switch (wardId) { case 1: ds = objGetWardNumberBL.GetWardNumber(wardId); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { int emptyWardNumber = Convert.ToInt32(ds.Tables[0].Rows[i]["WARD_NUMBER"].ToString()); int rows = (emptyWardNumber - 100) / 6; int x = ((emptyWardNumber - 1) % 100); Table1.Rows[rows].Cells[x % 5].BackColor = System.Drawing.Color.LightGreen; } MultiView1.ActiveViewIndex = 0; break; case 3: ds = objGetWardNumberBL.GetWardNumber(3); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { int emptyWardNumber = Convert.ToInt32(ds.Tables[0].Rows[i]["WARD_NUMBER"].ToString()); int rows = (emptyWardNumber - 200) / 6; int x = ((emptyWardNumber - 1) % 200); Table2.Rows[rows].Cells[x % 5].BackColor = System.Drawing.Color.LightGreen; } MultiView1.ActiveViewIndex = 1; break; case 4: for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { int emptyWardNumber = Convert.ToInt32(ds.Tables[0].Rows[i]["WARD_NUMBER"].ToString()); int rows = (emptyWardNumber - 300) / 6; int x = ((emptyWardNumber - 1) % 300); Table3.Rows[rows].Cells[x % 5].BackColor = System.Drawing.Color.LightGreen; } MultiView1.ActiveViewIndex = 2; break; case 5: for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { int emptyWardNumber = Convert.ToInt32(ds.Tables[0].Rows[i]["WARD_NUMBER"].ToString()); int rows = (emptyWardNumber - 400) / 6; int x = ((emptyWardNumber - 1) % 400); Table4.Rows[rows].Cells[x % 5].BackColor = System.Drawing.Color.LightGreen; } MultiView1.ActiveViewIndex = 3; break; case 6: for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { int emptyWardNumber = Convert.ToInt32(ds.Tables[0].Rows[i]["WARD_NUMBER"].ToString()); int rows = ((emptyWardNumber - 1) % 500) / 5; int x = ((emptyWardNumber - 1) % 500); Table5.Rows[rows].Cells[x % 5].BackColor = System.Drawing.Color.LightGreen; } MultiView1.ActiveViewIndex = 4; break; } }
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { int wardId = Convert.ToInt32(DropDownList1.SelectedValue); GetWardNumberBL objGetWardNumberBL = new GetWardNumberBL(); DataSet ds = new DataSet(); ds = objGetWardNumberBL.GetWardNumber(wardId); switch (wardId) { case 1: ds = objGetWardNumberBL.GetWardNumber(wardId); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { int emptyWardNumber = Convert.ToInt32(ds.Tables[0].Rows[i]["WARD_NUMBER"].ToString()); int rows = (emptyWardNumber - 100) / 6; int x = ((emptyWardNumber - 1) % 100); Table1.Rows[rows].Cells[x%5].BackColor = System.Drawing.Color.LightGreen; } MultiView1.ActiveViewIndex = 0; break; case 3: ds = objGetWardNumberBL.GetWardNumber(3); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { int emptyWardNumber = Convert.ToInt32(ds.Tables[0].Rows[i]["WARD_NUMBER"].ToString()); int rows = (emptyWardNumber - 200) / 6; int x = ((emptyWardNumber - 1) % 200); Table2.Rows[rows].Cells[x%5].BackColor = System.Drawing.Color.LightGreen; } MultiView1.ActiveViewIndex = 1; break; case 4: for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { int emptyWardNumber = Convert.ToInt32(ds.Tables[0].Rows[i]["WARD_NUMBER"].ToString()); int rows = (emptyWardNumber - 300)/6; int x = ((emptyWardNumber - 1) % 300); Table3.Rows[rows].Cells[x % 5].BackColor = System.Drawing.Color.LightGreen; } MultiView1.ActiveViewIndex = 2; break; case 5: for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { int emptyWardNumber = Convert.ToInt32(ds.Tables[0].Rows[i]["WARD_NUMBER"].ToString()); int rows = (emptyWardNumber - 400) / 6; int x = ((emptyWardNumber - 1) % 400); Table4.Rows[rows].Cells[x % 5].BackColor = System.Drawing.Color.LightGreen; } MultiView1.ActiveViewIndex = 3; break; case 6: for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { int emptyWardNumber = Convert.ToInt32(ds.Tables[0].Rows[i]["WARD_NUMBER"].ToString()); int rows = ((emptyWardNumber - 1) % 500) /5; int x = ((emptyWardNumber - 1) % 500); Table5.Rows[rows].Cells[x % 5].BackColor = System.Drawing.Color.LightGreen; } MultiView1.ActiveViewIndex = 4; break; } }