//对绑定已经勾选的评审人 private void BindSelectReviewer() { string myid = chId; string check_select = "select CM_PID from TBCM_PSVIEW where CM_ID='" + myid + "' and CM_PIDTYPE!='0'"; DataTable sele = DBCallCommon.GetDTUsingSqlText(check_select); for (int i = 0; i < 6; i++) { if (i != 1) { { CheckBoxList ck = (CheckBoxList)Panel2.FindControl("cki" + i.ToString()); for (int j = 0; j < sele.Rows.Count; j++) { for (int k = 0; k < ck.Items.Count; k++) { if (ck.Items[k].Value == sele.Rows[j][0].ToString()) { ck.Items[k].Selected = true; } } } } } } }
private void bindReviewer() { List <string> list = new List <string>(); foreach (Control item in Panel2.Controls) { list.Add(item.ID); } int count = 0; for (int i = 0; i < 6; i++) { CheckBoxList ck = (CheckBoxList)Panel2.FindControl("cki" + i.ToString()); Label lb = (Label)Panel2.FindControl("dep" + i.ToString()); if (ck != null) { for (int j = 0; j < ck.Items.Count; j++) { if (ck.Items[j].Selected == true) { reviewer.Add(lb.Text + ck.Items[j].Value.ToString(), ck.Items[j].Value.ToString());//字典,绑定部门领导的编号 count++; } } } } }
private void BindSelectReviewer() { string csr = HidCSR.Value; string[] str = csr.Split(','); for (int i = 0; i < 6; i++) { if (i != 1)//没有采购部 { { CheckBoxList ck = (CheckBoxList)Panel2.FindControl("cki" + i.ToString()); for (int j = 0; j < str.Length; j++) { for (int k = 0; k < ck.Items.Count; k++) { if (ck.Items[k].Value == str[j].ToString()) { ck.Items[k].Selected = true; } } } } } } }
protected void btnSave_Click(object sender, EventArgs e) { OnlineSchoolEntities km = new OnlineSchoolEntities(); Week week = (from k in km.Weeks where k.Id == 1 select k).FirstOrDefault(); // week.startDate = Convert.ToDateTime(txtStartDate.Text); if (MyDate.getDateCulture() == "ar-EG") { week.startDate = DateTime.ParseExact(txtStartDate.Text, "yyyy/MM/dd", new CultureInfo("ar-EG")); } else { week.startDate = MyDate.convertHijriToGregorian(txtStartDate.Text); } for (int i = 2; i <= 21; ++i) { var lblname = "lblDateWeek" + (i); Label lbl = (Label)Panel2.FindControl(lblname); DropDownList ddl = (DropDownList)Panel2.FindControl("DropDownList" + i); week = (from k in km.Weeks where k.Id == i select k).FirstOrDefault(); if (MyDate.getDateCulture() == "ar-EG") { week.startDate = DateTime.ParseExact(lbl.Text, "yyyy/MM/dd", new CultureInfo("ar-EG")); } else { week.startDate = MyDate.convertHijriToGregorian(lbl.Text); } week.type = int.Parse(ddl.SelectedValue); } km.SaveChanges(); }
private void Bokabtn_Click(object sender, EventArgs e) { seattable.Visible = true; panel3.Visible = true; string query = "Select * from Booked where((Date = '" + date_box.Text.Trim() + "') and(Station = '" + dest_from.Value.Trim() + "'))"; con = new SqlConnection(c.con); cmd = new SqlCommand(); con.Open(); cmd.Connection = con; cmd.CommandText = query; dr = cmd.ExecuteReader(); if (dr.HasRows == true) { while (dr.Read()) { for (int j = 1; j <= 31; j++) { string s = "s" + j; if (dr[s.ToString()].ToString() == "b") { ImageButton img = (ImageButton)Panel2.FindControl(s.ToString()); img.ImageUrl = "../images/booked_seat_img.gif"; img.Enabled = false; } } } } }
protected bool CheckPs(bool n, List <string> id) { for (int i = 0; i < id.Count; i++) { CheckBoxList cbl = (CheckBoxList)Panel2.FindControl(id[i]); if (cbl != null) { for (int j = 0; j < cbl.Items.Count; j++) { if (cbl.Items[j].Selected) { n = false; } } } } return(n); }
protected void imgbtnFemale_Click2(object sender, EventArgs e) { Session.Add("genderFlag", "false"); labelGender3.Text += "female" + ","; Button4.Visible = true; Session.Add("gender", labelGender3.Text); Session.Add("whichSeat", label14.Text); Session.Add("busCapasity", "31"); Session.Add("hour", Label8.Text); if (Label13.Text == "Hiç koltuk seçmediniz") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Lütfen önce koltuk seçiniz!')", true); } else { ImageButton img = (ImageButton)Panel2.FindControl("ImageButton_" + Label13.Text); img.ImageUrl = "~/Images/ladies_seat_img.gif"; } }
//对绑定已经勾选的评审人 private void BindSelectReviewer() { string check_select = "select pc_pid from PC_PurInformCommit_Email where PC_PFT_ID='" + PC_PFT_ID_code + "' "; DataTable sele = DBCallCommon.GetDTUsingSqlText(check_select); for (int i = 0; i < 4; i++) { CheckBoxList ck = (CheckBoxList)Panel2.FindControl("cki" + i.ToString()); for (int j = 0; j < sele.Rows.Count; j++) { for (int k = 0; k < ck.Items.Count; k++) { if (ck.Items[k].Value == sele.Rows[j][0].ToString()) { ck.Items[k].Selected = true; } } } } }
protected void btnAllWeek_Click(object sender, EventArgs e) { DateTime dt = new DateTime(); if (MyDate.getDateCulture() == "ar-EG") { dt = DateTime.ParseExact(txtStartDate.Text, "yyyy/MM/dd", new CultureInfo("ar-EG")); } else { dt = MyDate.convertHijriToGregorian(txtStartDate.Text); // dt = DateTime.ParseExact(txtStartDate.Text, "yyyy/MM/dd", new CultureInfo("ar-SA")); } for (int i = 1; i <= 20; ++i) { var lblname = "lblDateWeek" + (i + 1); Label lbl = (Label)Panel2.FindControl(lblname); lbl.Text = MyDate.getDate(dt.AddDays(7 * i).ToString()); } // PlaceHolderSuccess.Visible = false; }
//to get the camper answers from the database void getCamperAnswers() { string strFJCID; DataSet dsAnswers; DataView dv; RadioButton rb; string strFilter; strFJCID = hdnFJCIDStep2_2.Value; if (!strFJCID.Equals(string.Empty)) { dsAnswers = CamperAppl.getCamperAnswers(strFJCID, "3", "8", "N"); if (dsAnswers.Tables[0].Rows.Count > 0) //if there are records for the current FJCID { dv = dsAnswers.Tables[0].DefaultView; //to display answers for the QuestionId 3,6,7 and 8 for step 2_2_Midsex for (int i = 3; i <= 8; i++) { strFilter = "QuestionId = '" + i.ToString() + "'"; switch (i) { case 3: //assigning the answer for question 3 foreach (DataRow dr in dv.Table.Select(strFilter)) { if (!dr["OptionID"].Equals(DBNull.Value)) { rb = (RadioButton)Panel2.FindControl("RadioBtnQ3" + dr["OptionID"].ToString()); rb.Checked = true; } } break; case 6: // assigning the answer for question 6 foreach (DataRow dr in dv.Table.Select(strFilter)) { if (!dr["Answer"].Equals(DBNull.Value)) { ddlGrade.SelectedValue = dr["Answer"].ToString(); } } break; case 7: // assigning the answer for question 7 foreach (DataRow dr in dv.Table.Select(strFilter)) { if (!dr["OptionID"].Equals(DBNull.Value)) { RadioButtionQ5.SelectedValue = dr["OptionID"].ToString(); } } break; case 8: // assigning the answer for question 8 int intSchool; DataSet dsSchool = new DataSet(); foreach (DataRow dr in dv.Table.Select(strFilter)) { if (!dr["OptionID"].Equals(DBNull.Value)) { if (!dr["Answer"].Equals(DBNull.Value)) { Int32.TryParse(dr["Answer"].ToString(), out intSchool); if (intSchool > 0) { dsSchool = CamperAppl.GetSchool(intSchool); txtCamperSchool.Text = dsSchool.Tables[0].Rows[0]["Answer"].ToString(); } else { txtCamperSchool.Text = dr["Answer"].ToString(); } } } else { if (!dr["Answer"].Equals(DBNull.Value)) { txtCamperSchool.Text = dr["Answer"].ToString(); } } } break; } } } //to set the school text box to enable / disable based on the school type selected setTextBoxStatus(); } //end if for null check of fjcid }
//to get the camper answers from the database void getCamperAnswers() { string strFilter, strFJCID, strModifiedBy; DataSet dsAnswers; DataView dv; RadioButtonList rb; //DataRow dr; DataRow[] drows; HiddenField hdnval; DropDownList ddl; TextBox tb; strFJCID = hdnFJCID.Value; strModifiedBy = Master.UserId; if (!strFJCID.Equals(string.Empty)) { dsAnswers = CamperAppl.getCamperAnswers(strFJCID, "3", "32", "N"); if (dsAnswers.Tables[0].Rows.Count > 0) //if there are records for the current FJCID { dv = dsAnswers.Tables[0].DefaultView; //to display answers for the Questions 3 -11 for (int i = 3; i <= 11; i++) { //to get the QuestionId for the Questions hdnval = (HiddenField)PnlHidden.FindControl("hdnQ" + i.ToString() + "Id"); strFilter = "QuestionId = '" + hdnval.Value + "'"; tb = null; ddl = null; rb = null; switch (i) { case 3: //assigning the answer for question 3 rb = (RadioButtonList)Panel2.FindControl("RadioBtnQ" + i.ToString()); goto default; case 4: // assigning the answer for question 4 rb = (RadioButtonList)Panel2.FindControl("RadioBtnQ" + i.ToString()); goto default; case 5: // assigning the answer for question 5 rb = (RadioButtonList)Panel2.FindControl("RadioBtnQ" + i.ToString()); goto default; case 6: // assigning the answer for question 6 ddl = ddlGrade; goto default; case 7: // assigning the answer for question 7 //rb = (RadioButtonList)Panel2.FindControl("RadioBtnQ" + i.ToString()); //goto default; foreach (DataRow dr1 in dv.Table.Select(strFilter)) { if (!dr1["OptionID"].Equals(DBNull.Value)) { int value = Convert.ToInt32(dr1["OptionID"].ToString()); switch (value) { case 2: { chkNo.Checked = true; Pnl9a.Enabled = Pnl10a.Enabled = false; break; } case 1: { chkSynagogue.Checked = true; Pnl9a.Enabled = true; break; } case 3: { chkJCC.Checked = Pnl10a.Enabled = true; break; } default: chkNo.Checked = false; break; } } } break; case 8: // assigning the answer for question 8 foreach (DataRow dr in dv.Table.Select(strFilter)) { if (!dr["OptionID"].Equals(DBNull.Value)) { if (dr["OptionID"].ToString().Equals("1")) { ddlSynagogue.SelectedValue = dr["Answer"] != DBNull.Value ? dr["Answer"].ToString() : "0"; } else if (dr["OptionID"].ToString().Equals("2")) { txtOtherSynagogue.Text = dr["Answer"] != DBNull.Value ? dr["Answer"].ToString() : string.Empty; } } } drows = dv.Table.Select(strFilter); if (drows.Length > 0) //if there are rows for the filter { //dr = (DataRow)drows.GetValue(0); foreach (DataRow dr1 in drows) { if (!dr1["OptionID"].Equals(DBNull.Value)) { if (dr1["OptionID"].ToString().Equals("3")) { if (!dr1["Answer"].Equals(DBNull.Value)) { ddlJCC.SelectedValue = dr1["Answer"].ToString(); } } } if (!dr1["OptionID"].Equals(DBNull.Value)) { if (dr1["OptionID"].ToString().Equals("4")) { if (!dr1["Answer"].Equals(DBNull.Value)) { txtJCC.Text = dr1["Answer"].ToString(); } } } } } goto default; case 9: // assigning the answer for question 11 tb = txtSynagogueReferral; goto default; case 10: // assigning the answer for question 9 rb = (RadioButtonList)Panel2.FindControl("RadioBtnQ9"); goto default; case 11: // assigning the answer for question 11 tb = txtCamperSchool; goto default; default: //to implement the common logic drows = dv.Table.Select(strFilter); if (drows.Length > 0) //if there are rows for the filter { foreach (DataRow dr in drows) //dr = (DataRow)drows.GetValue(0); { //for dropdownlist if (ddl != null) { if (ddl == ddlGrade) //for the grade question the value is stored in "Answer" { if (!dr["Answer"].Equals(DBNull.Value)) { ddl.SelectedValue = dr["Answer"].ToString(); } } else if (!dr["OptionID"].Equals(DBNull.Value)) { ddl.SelectedValue = dr["OptionID"].ToString(); } } //for text box if (tb != null) { if (!dr["Answer"].Equals(DBNull.Value) && tb.ClientID != "txtOtherSynagogue") { tb.Text = dr["Answer"].ToString(); } } //for radio buttonlist if (rb != null) { if (!dr["OptionID"].Equals(DBNull.Value)) { rb.SelectedValue = dr["OptionID"].ToString(); } } } } break; } } } //to set the status of the panel based on the radio button selected setPanelStatus(); } //end if for null check of fjcid }
//to get the camper answers from the database void getCamperAnswers() { string strFJCID; DataSet dsAnswers; DataView dv; RadioButton rb; string strFilter; DataRow[] drows; strFJCID = hdnFJCIDStep2_2.Value; if (!strFJCID.Equals(string.Empty)) { dsAnswers = CamperAppl.getCamperAnswers(strFJCID, "3", "31", "N"); if (dsAnswers.Tables[0].Rows.Count > 0) //if there are records for the current FJCID { dv = dsAnswers.Tables[0].DefaultView; //to display answers for the QuestionId 3,6,7,8,30 and 31 for step 2_2_Kansas for (int i = 3; i <= 31; i++) { strFilter = "QuestionId = '" + i.ToString() + "'"; DataRow[] drow = dv.Table.Select(strFilter); if (drow == null) { continue; } switch (i) { case 3: //assigning the answer for question 3 foreach (DataRow dr in dv.Table.Select(strFilter)) { if (!dr["OptionID"].Equals(DBNull.Value)) { rb = (RadioButton)Panel2.FindControl("RadioBtnQ3" + dr["OptionID"].ToString()); rb.Checked = true; } } break; case 6: // assigning the answer for question 6 foreach (DataRow dr in dv.Table.Select(strFilter)) { if (!dr["Answer"].Equals(DBNull.Value)) { ddlGrade.SelectedValue = dr["Answer"].ToString(); } } break; case 7: // assigning the answer for question 7 foreach (DataRow dr in dv.Table.Select(strFilter)) { if (!dr["OptionID"].Equals(DBNull.Value)) { RadioButtionQ6.SelectedValue = dr["OptionID"].ToString(); } } break; case 8: // assigning the answer for question 8 foreach (DataRow dr in dv.Table.Select(strFilter)) { if (!dr["Answer"].Equals(DBNull.Value)) { txtCamperSchool.Text = dr["Answer"].ToString(); } } break; case 30: // assigning the answer for question 30 foreach (DataRow dr in dv.Table.Select(strFilter)) { //if (!dr["OptionID"].Equals(DBNull.Value)) //{ // RadioBtnQ4.SelectedValue = dr["OptionID"].ToString(); //} if (!dr["OptionID"].Equals(DBNull.Value)) { int value = Convert.ToInt32(dr["OptionID"].ToString()); //if (value > 0) // chklistQ8.Items[(value - 1)].Selected = true; switch (value) { case 2: { chkNo.Checked = true; Pnl9a.Enabled = Pnl10a.Enabled = false; break; } case 1: { chkSynagogue.Checked = true; Pnl9a.Enabled = true; break; } case 3: { chkJCC.Checked = Pnl10a.Enabled = true; break; } default: chkNo.Checked = false; break; } } } break; case 31: // assigning the answer for question 31 foreach (DataRow dr in dv.Table.Select(strFilter)) { if (!dr["OptionID"].Equals(DBNull.Value)) { if (dr["OptionID"].ToString().Equals("1")) { ddlSynagogue.SelectedValue = dr["Answer"] != DBNull.Value ? dr["Answer"].ToString() : "0"; } else if (dr["OptionID"].ToString().Equals("2")) { txtOtherSynagogue.Text = dr["Answer"] != DBNull.Value ? dr["Answer"].ToString() : string.Empty; } } } drows = dv.Table.Select(strFilter); if (drows.Length > 0) //if there are rows for the filter { //dr = (DataRow)drows.GetValue(0); foreach (DataRow dr in drows) { if (!dr["OptionID"].Equals(DBNull.Value)) { if (dr["OptionID"].ToString().Equals("3")) { if (!dr["Answer"].Equals(DBNull.Value)) { ddlJCC.SelectedValue = dr["Answer"].ToString(); } } } if (!dr["OptionID"].Equals(DBNull.Value)) { if (dr["OptionID"].ToString().Equals("4")) { if (!dr["Answer"].Equals(DBNull.Value)) { txtJCC.Text = dr["Answer"].ToString(); } } } } } break; } } } SetPanelStatus(); } //end if for null check of fjcid }
protected void Page_Load(object sender, EventArgs e) { string databaseStr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("App_Data/Booking.mdb"); OleDbConnection con = new OleDbConnection(databaseStr); OleDbCommand cmd4 = new OleDbCommand("SELECT Booking.[BusCapacity] FROM Booking WHERE Booking.[PassengerBusHour] = '9:00'", con); con.Open(); OleDbDataReader dr4 = cmd4.ExecuteReader(); OleDbCommand cmd = new OleDbCommand("SELECT Booking.[PassengerSeatID] FROM Booking WHERE Booking.[PassengerBusHour] = '9:00'", con); OleDbDataReader dr = cmd.ExecuteReader(); ArrayList filledSeats = new ArrayList(); while (dr.Read()) { string[] parcalar = dr["PassengerSeatID"].ToString().Split(','); for (int i = 0; i < parcalar.Length; i++) { filledSeats.Add(parcalar[i]); } } string strRead = ""; int difference = 0; while (dr4.Read()) { strRead = dr4["BusCapacity"].ToString(); } if (strRead != "") { if (int.Parse(strRead) != 31) { difference = 31 - int.Parse(strRead); } for (int i = 1; i < difference + 1; i++) { int temp = 32; string str = "s" + (temp - i); ImageButton img = (ImageButton)pnl1.FindControl(str); img.Visible = false; } } foreach (var item in filledSeats) { string str = "s" + item; ImageButton img = (ImageButton)pnl1.FindControl(str); img.ImageUrl = "~/Images/booked_seat_img.gif"; img.Enabled = false; } con.Close(); string databaseStr2 = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("App_Data/Booking.mdb"); OleDbConnection con2 = new OleDbConnection(databaseStr2); OleDbCommand cmd6 = new OleDbCommand("SELECT Booking.[BusCapacity] FROM Booking WHERE Booking.[PassengerBusHour] = '03:15'", con2); con2.Open(); OleDbCommand cmd2 = new OleDbCommand("SELECT Booking.[PassengerSeatID] FROM Booking WHERE Booking.[PassengerBusHour]='03:15'", con2); OleDbDataReader dr6 = cmd6.ExecuteReader(); OleDbDataReader dr2 = cmd2.ExecuteReader(); ArrayList filledSeats1 = new ArrayList(); while (dr2.Read()) { string[] parcalar = dr2["PassengerSeatID"].ToString().Split(','); for (int i = 0; i < parcalar.Length; i++) { filledSeats1.Add(parcalar[i]); } } string strRead1 = ""; int difference1 = 0; while (dr6.Read()) { strRead1 = dr6["BusCapacity"].ToString(); } if (strRead1 != "") { if (int.Parse(strRead1) != 31) { difference1 = 31 - int.Parse(strRead1); } for (int i = 1; i < difference1 + 1; i++) { int temp = 32; string str = "ImageButton" + (temp - i); ImageButton img = (ImageButton)Panel1.FindControl(str); img.Visible = false; } } foreach (var item in filledSeats1) { string str = "ImageButton" + item; ImageButton img = (ImageButton)Panel1.FindControl(str); img.ImageUrl = "~/Images/booked_seat_img.gif"; img.Enabled = false; } con.Close(); string databaseStr3 = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("App_Data/Booking.mdb"); OleDbConnection con3 = new OleDbConnection(databaseStr3); OleDbCommand cmd7 = new OleDbCommand("SELECT Booking.[BusCapacity] FROM Booking WHERE Booking.[PassengerBusHour] = '08:15'", con3); con3.Open(); OleDbCommand cmd3 = new OleDbCommand("SELECT Booking.[PassengerSeatID] FROM Booking WHERE Booking.[PassengerBusHour]='08:15'", con3); OleDbDataReader dr3 = cmd3.ExecuteReader(); OleDbDataReader dr7 = cmd7.ExecuteReader(); ArrayList filledSeats3 = new ArrayList(); while (dr3.Read()) { string[] parcalar = dr3["PassengerSeatID"].ToString().Split(','); for (int i = 0; i < parcalar.Length; i++) { filledSeats3.Add(parcalar[i]); } } string strRead2 = ""; int difference2 = 0; while (dr7.Read()) { strRead2 = dr7["BusCapacity"].ToString(); } if (strRead2 != "") { if (int.Parse(strRead2) != 31) { difference2 = 31 - int.Parse(strRead2); } for (int i = 1; i < difference2 + 1; i++) { int temp = 32; string str = "ImageButton_" + (temp - i); ImageButton img = (ImageButton)Panel1.FindControl(str); img.Visible = false; } } foreach (var item in filledSeats3) { string str = "ImageButton_" + item; ImageButton img = (ImageButton)Panel2.FindControl(str); img.ImageUrl = "~/Images/booked_seat_img.gif"; img.Enabled = false; } con.Close(); }
//to get the camper answers from the database void getCamperAnswers() { string strFilter, strFJCID, strModifiedBy; DataSet dsAnswers; DataView dv; RadioButtonList rb; DataRow dr; DataRow[] drows; HiddenField hdnval; DropDownList ddl; TextBox tb; DataSet dsSchool = new DataSet(); strFJCID = hdnFJCID.Value; strModifiedBy = Master.UserId; if (!strFJCID.Equals(string.Empty)) { dsAnswers = CamperAppl.getCamperAnswers(strFJCID, "3", "33", "N"); if (dsAnswers.Tables[0].Rows.Count > 0) //if there are records for the current FJCID { dv = dsAnswers.Tables[0].DefaultView; //to display answers for the Questions 3 -11 for (int i = 3; i <= 9; i++) { //to get the QuestionId for the Questions hdnval = (HiddenField)PnlHidden.FindControl("hdnQ" + i.ToString() + "Id"); strFilter = "QuestionId = '" + hdnval.Value + "'"; tb = null; ddl = null; rb = null; switch (i) { case 3: //assigning the answer for question 3 rb = (RadioButtonList)Panel2.FindControl("RadioBtnQ" + i.ToString()); goto default; case 4: // assigning the answer for question 4 rb = (RadioButtonList)Panel2.FindControl("RadioBtnQ" + i.ToString()); goto default; case 5: // assigning the answer for question 5 rb = (RadioButtonList)Panel2.FindControl("RadioBtnQ" + i.ToString()); goto default; case 6: // assigning the answer for question 6 ddl = ddlGrade; goto default; case 7: // assigning the answer for question 9 rb = (RadioButtonList)Panel2.FindControl("RadioBtnQ9"); goto default; case 8: // assigning the answer for question 10 //ddl = ddlQ10; //tb = txtJewishSchool; goto default; case 9: // assigning the answer for question 11 tb = txtCamperSchool; goto default; default: //to implement the common logic drows = dv.Table.Select(strFilter); int intSchool; if (drows.Length > 0) //if there are rows for the filter { dr = (DataRow)drows.GetValue(0); if (!dr["OptionID"].Equals(DBNull.Value)) { if (!dr["Answer"].Equals(DBNull.Value)) { Int32.TryParse(dr["Answer"].ToString(), out intSchool); if (intSchool > 0) { dsSchool = CamperAppl.GetSchool(intSchool); dr = (DataRow)dsSchool.Tables[0].Rows[0]; } else if (intSchool == -1) { if (drows.Length > 1) { dr = (DataRow)drows.GetValue(1); } } } } //for dropdownlist if (ddl != null) { if (ddl == ddlGrade) //for the grade question the value is stored in "Answer" { if (!dr["Answer"].Equals(DBNull.Value)) { ddl.SelectedValue = dr["Answer"].ToString(); } } else if (!dr["OptionID"].Equals(DBNull.Value)) { ddl.SelectedValue = dr["OptionID"].ToString(); } } //for text box if (tb != null) { if (!dr["Answer"].Equals(DBNull.Value)) { tb.Text = dr["Answer"].ToString(); } } //for radio buttonlist if (rb != null) { if (!dr["OptionID"].Equals(DBNull.Value)) { rb.SelectedValue = dr["OptionID"].ToString(); } } } break; } } } //to set the status of the panel based on the radio button selected setPanelStatus(); } //end if for null check of fjcid }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { OnlineSchoolEntities km = new OnlineSchoolEntities(); var yearH = (from k in km.Semesters orderby k.Id descending select k.YearH).FirstOrDefault(); txtYear.Text = yearH + "-" + (yearH + 1) + " هـ "; var yearM = (from k in km.Semesters orderby k.Id descending select k.YearM).FirstOrDefault(); txtYearM.Text = yearM + "-" + (yearM + 1) + " م "; DDLSemester.SelectedValue = MyDate.getCurrentSemesterNumber().ToString(); ddlSemesters.SelectedValue = MyDate.getCurrentSemesterNumber().ToString(); ddlYear.SelectedValue = txtYear.Text; Calendar1.DataBind(); Calendar2.DataBind(); Calendar3.DataBind(); var start = MyDate.getCurrentSemesteStartDate().Split(' ').FirstOrDefault(); if (start != null) { txtStart.Text = start; } var culture = MyDate.getDateCulture(); if (culture == "ar-EG") { radioDate.SelectedValue = "False"; } else { radioDate.SelectedValue = "True"; } lstSemesters.DataBind(); ddlYear.DataBind(); var end = MyDate.getCurrentSemesteEndDate(); if (end != null) { txtEnd.Text = end; } Week week = (from k in km.Weeks where k.Id == 1 select k).FirstOrDefault(); txtStartDate.Text = MyDate.getDate(week.startDate.ToString()); for (int i = 2; i <= 21; ++i) { var lblname = "lblDateWeek" + (i); Label lbl = (Label)Panel2.FindControl(lblname); DropDownList ddl = (DropDownList)Panel2.FindControl("DropDownList" + i); ddl.DataBind(); week = (from k in km.Weeks where k.Id == i select k).FirstOrDefault(); lbl.Text = MyDate.getDate(week.startDate.ToString()); ddl.SelectedValue = week.type.ToString(); } } if (Request.QueryString["Date"] == "Ok") { ClientScript.RegisterStartupScript(this.GetType(), "openModal", "<script> addSuccess(' تم تعديل التاريخ بنجاح'); </script>", false); } }
//to get the camper answers from the database void getCamperAnswers() { string strFJCID; DataSet dsAnswers; DataView dv; RadioButton rb; string strFilter; strFJCID = hdnFJCIDStep2_2.Value; if (!strFJCID.Equals(string.Empty)) { dsAnswers = CamperAppl.getCamperAnswers(strFJCID, "3", "1024", "N"); if (dsAnswers.Tables[0].Rows.Count > 0) //if there are records for the current FJCID { dv = dsAnswers.Tables[0].DefaultView; //to display answers for the QuestionId 3,6,7 and 8 for step 2_2_CMART for (int i = 0; i < dsAnswers.Tables[0].Rows.Count; i++) { int qID = Int32.Parse(dsAnswers.Tables[0].Rows[i]["QuestionID"].ToString()); strFilter = "QuestionId = '" + qID.ToString() + "'"; switch (qID) { case 3: //assigning the answer for question 1 foreach (DataRow dr in dv.Table.Select(strFilter)) { if (!dr["OptionID"].Equals(DBNull.Value)) { RadioBtnQ3.SelectedValue = dr["OptionID"].ToString(); } } break; case 13: //assigning the answer for question 2 foreach (DataRow dr in dv.Table.Select(strFilter)) { if (!dr["OptionID"].Equals(DBNull.Value)) { RadioBtnQ4.SelectedValue = dr["OptionID"].ToString(); } } break; case 1024: //assigning the answer for question 3 foreach (DataRow dr in dv.Table.Select(strFilter)) { if (!dr["OptionID"].Equals(DBNull.Value)) { RadioBtnQ5.SelectedValue = dr["OptionID"].ToString(); } } break; case 6: // assigning the answer for question 6 foreach (DataRow dr in dv.Table.Select(strFilter)) { if (!dr["Answer"].Equals(DBNull.Value)) { ddlGrade.SelectedValue = dr["Answer"].ToString(); } } break; case 7: // assigning the answer for question 7 foreach (DataRow dr in dv.Table.Select(strFilter)) { if (!dr["OptionID"].Equals(DBNull.Value)) { RadioButtionQ5.SelectedValue = dr["OptionID"].ToString(); } } break; case 8: // assigning the answer for question 8 foreach (DataRow dr in dv.Table.Select(strFilter)) { if (!dr["Answer"].Equals(DBNull.Value)) { txtCamperSchool.Text = dr["Answer"].ToString(); } } break; case 1014: foreach (DataRow dr in dv.Table.Select(strFilter)) { if (!dr["OptionID"].Equals(DBNull.Value)) { rb = (RadioButton)Panel2.FindControl("rdbtnQ7" + dr["OptionID"].ToString()); rb.Checked = true; } } break; } } } //to set the school text box to enable / disable based on the school type selected setTextBoxStatus(); } //end if for null check of fjcid }