//对绑定已经勾选的评审人
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
}
