private void loadRoutine()
{
try
{
STD_RoutineTime routineTime = new STD_RoutineTime();
routineTime.RoomID = Request.QueryString["RoomID"] == null ? 0 : int.Parse(Request.QueryString["RoomID"]);
routineTime.RoutineID = Request.QueryString["RoutineID"] == null ? 0 : int.Parse(Request.QueryString["RoutineID"]);
routineTime.ClassID = Request.QueryString["ClassID"] == null ? 0 : int.Parse(Request.QueryString["ClassID"]);
routineTime.SubjectID = Request.QueryString["SubjectID"] == null ? 0 : int.Parse(Request.QueryString["SubjectID"]);
routineTime.EmployeeID = Request.QueryString["EmployeeID"] == null ? "" : Request.QueryString["EmployeeID"];
string StudentID = Request.QueryString["StudentID"] == null ? "" : Request.QueryString["StudentID"];
lblRoutineDisplay.Text= STD_RoutineTimeManager.getRoutineTextDayTop(routineTime, StudentID);
lblRoutineDisplay.Text = lblRoutineDisplay.Text.Replace("id='tblRoutineDisplay'", "border='1'");
lblRoutineDisplay.Text = lblRoutineDisplay.Text.Replace("id='tblRoutineDisplayTeacher'", "border='1'");
if (Request.QueryString["Archive"] != null)
{
STD_Archive sTD_Archive = new STD_Archive();
sTD_Archive.Archive = lblRoutineDisplay.Text;
sTD_Archive.AddedDate = DateTime.Now;
int resutl = STD_ArchiveManager.InsertSTD_Archive(sTD_Archive);
}
}
catch (Exception ex)
{ }
}
protected void btnPrint_Click(object sender, EventArgs e)
{
STD_RoutineTime routineTime = new STD_RoutineTime();
routineTime.RoomID = 0;
routineTime.RoutineID = ddlCampus.SelectedValue == "0" ? 0 : int.Parse(ddlRoutineID.SelectedValue);
routineTime.ClassID = int.Parse(ddlClassID.SelectedValue);
routineTime.SubjectID = int.Parse(ddlSubjectID.SelectedValue);
routineTime.EmployeeID = ddlEmployeeID.SelectedValue == "0" ? "" : ddlEmployeeID.SelectedValue;
//string StudentID = "";
Response.Redirect("~/Class/RoutineDisplay.aspx?RoutineID=" + routineTime.RoutineID.ToString() + "&ClassID=" + routineTime.ClassID.ToString() + "&SubjectID=" + routineTime.SubjectID.ToString() + "&EmployeeID=" + routineTime.EmployeeID);
//if (Session["tblRoutineTemplate"] != null)
//{
// Response.Redirect("~/Class/Class_Display_Routine.aspx");
// Session["tblRoutineTemplate"] = null;
//}
//else
//{
// StringBuilder sb = new StringBuilder();
// sb.Append("alert('No Record Found')");
// ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "showalert", sb.ToString(), true);
//}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
STD_RoutineTime sTD_RoutineTime = new STD_RoutineTime();
sTD_RoutineTime.RoutineTimeID = int.Parse(Request.QueryString["ID"].ToString());
sTD_RoutineTime.RoutineTimeName = txtRoutineTimeName.Text;
sTD_RoutineTime.RoomID = int.Parse(ddlRoomID.SelectedValue);
sTD_RoutineTime.SubjectID = int.Parse(ddlSubjectID.SelectedValue);
sTD_RoutineTime.EmployeeID = ddlEmployeeID.SelectedValue;
sTD_RoutineTime.ClassID = int.Parse(ddlClassID.SelectedValue);
//sTD_RoutineTime.ClassDayID = int.Parse(ddlClassDayID.SelectedValue);
//sTD_RoutineTime.ClassTimeID = int.Parse(ddlClassTimeID.SelectedValue);
sTD_RoutineTime.RoutineID = int.Parse(ddlRoutineID.SelectedValue);
sTD_RoutineTime.AddedBy = Profile.card_id;
sTD_RoutineTime.AddedDate = DateTime.Now;
sTD_RoutineTime.UpdatedBy = Profile.card_id;
sTD_RoutineTime.UpdateDate = DateTime.Now;
bool resutl = STD_RoutineTimeManager.UpdateSTD_RoutineTime(sTD_RoutineTime);
Response.Redirect("AdminDisplaySTD_RoutineTime.aspx");
}
catch (Exception ex)
{
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
string[] ids = ddlClassSubjectEmployeeID.SelectedValue.Split(',');
STD_RoutineTime sTD_RoutineTime = new STD_RoutineTime ();
// sTD_RoutineTime.RoutineTimeID= int.Parse(ddlRoutineTimeID.SelectedValue);
sTD_RoutineTime.RoutineTimeName = ddlClassSubjectEmployeeID.SelectedItem.Text + " - " + ddlRoomID.SelectedItem.Text;
sTD_RoutineTime.RoomID= int.Parse(ddlRoomID.SelectedValue);
sTD_RoutineTime.SubjectID= int.Parse(ids[1]);
sTD_RoutineTime.EmployeeID= ids[2];
sTD_RoutineTime.ClassID = int.Parse(ids[0]);
sTD_RoutineTime.ClassDayID= int.Parse(ddlClassDayID.SelectedValue);
sTD_RoutineTime.ClassTimeID= int.Parse(ddlClassTimeID.SelectedValue);
sTD_RoutineTime.RoutineID= int.Parse(ddlRoutineID.SelectedValue);
sTD_RoutineTime.AddedBy= Profile.card_id;
sTD_RoutineTime.AddedDate= DateTime.Now;
sTD_RoutineTime.UpdatedBy= Profile.card_id;
sTD_RoutineTime.UpdateDate= DateTime.Now;
/*
we have to have the checking
* DayID - TimeID - Room --------No RoutineTimeID
* DayID - TimeID - Teacher -----No RoutineTimeID
* DayID - TimeID - ClassID -----No RoutineTimeID
*/
int resutl =STD_RoutineTimeManager.InsertSTD_RoutineTime(sTD_RoutineTime);
Response.Redirect("AdminDisplaySTD_RoutineTime.aspx");
}
protected void btnPrintnArchive_Click(object sender, EventArgs e)
{
STD_RoutineTime routineTime = new STD_RoutineTime();
routineTime.RoomID = 0;
routineTime.RoutineID = ddlCampus.SelectedValue == "0" ? 0 : int.Parse(ddlRoutineID.SelectedValue);
routineTime.ClassID = int.Parse(ddlClassID.SelectedValue);
routineTime.SubjectID = int.Parse(ddlSubjectID.SelectedValue);
routineTime.EmployeeID = ddlEmployeeID.SelectedValue == "0" ? "" : ddlEmployeeID.SelectedValue;
//string StudentID = "";
Response.Redirect("~/Class/RoutineDisplay.aspx?Archive=1&RoutineID=" + routineTime.RoutineID.ToString() + "&ClassID=" + routineTime.ClassID.ToString() + "&SubjectID=" + routineTime.SubjectID.ToString() + "&EmployeeID=" + routineTime.EmployeeID);
}
public static String getRoutineText(STD_RoutineTime routineTime, string StudentID)
{
try
{
DataSet dsRoutineTime = STD_RoutineTimeManager.STD_SearchRoutineTime(routineTime, StudentID);
DataSet dsClassTime = STD_ClassTimeManager.GetAllSTD_ClassTimes();
DataSet dsClassDay = STD_ClassDayManager.GetAllSTD_ClassDaies();
int width = 200;
int widthDay = 50;
string routine = "<table border='1' style='width:" + ((dsClassTime.Tables[0].Rows.Count * width) + widthDay).ToString() + "px'>";
for (int row = 0; row < dsClassDay.Tables[0].Rows.Count; row++)
{
if (row == 0)
{
routine += "<tr ><td></td>";
for (int col = 0; col < dsClassTime.Tables[0].Rows.Count; col++)
{
routine += "<td>";
routine += dsClassTime.Tables[0].Rows[col]["ClassTimeName"].ToString();
routine += "</td>";
}
routine += "</tr>";
}
routine += "<tr>";
for (int col = 0; col < dsClassTime.Tables[0].Rows.Count; col++)
{
if (col == 0)
{
routine += "<td style='min-width:" + widthDay + "px'>";
routine += dsClassDay.Tables[0].Rows[row]["ClassDayName"].ToString();
routine += "</td>";
}
routine += "<td style='min-width:" + width + "px;'>";
routine += GetClassName(routineTime,dsRoutineTime, dsClassTime.Tables[0].Rows[col]["ClassTimeID"].ToString(), dsClassDay.Tables[0].Rows[row]["ClassDayID"].ToString());
routine += "</td>";
}
routine += "</tr>";
}
routine += "</table>";
return routine;
}
catch (Exception ex)
{
return "";
}
}
public static string GetClassName(STD_RoutineTime routineTime, DataSet dsRoutineTime, string ClassTimeID, string ClassDayID)
{
string className = "";
foreach (DataRow dr in dsRoutineTime.Tables[0].Rows)
{
if (dr["ClassTimeID"].ToString() == ClassTimeID && dr["ClassDayID"].ToString() == ClassDayID)
{
//if (className != "") className += "</br>";
//className += "Subject( " + dr["SubjectName"].ToString() + " ) Class( " + dr["ClassName"].ToString() + " ) Teacher( " + dr["EmployeeName"].ToString() + " )";
className += "<div style='border:1px solid black;'>(" + dr["ClassName"].ToString() + ") (" + dr["SubjectName"].ToString() + ") (" + dr["EmployeeSortName"].ToString() + ") (" + dr["RoomName"].ToString() + ")" ;
className += "<a href='Class_Display_RoutineTime_ByValues.aspx?IsDelete=1&CampusID=" + dr["CampusID"].ToString() + "&RoutineID=" + routineTime.RoutineID.ToString() + "&ClassID=" + routineTime.ClassID.ToString() + "&SubjectID=" + routineTime.SubjectID.ToString() + "&EmployeeID=" + routineTime.EmployeeID.ToString() + "&RoutineTimeID=" + dr["RoutineTimeID"].ToString() + "' style='display:none;'><img src='../App_Themes/CoffeyGreen/images/icon-delete.png' /></a></div>";
//className +="<img src='../App_Themes/CoffeyGreen/images/icon-delete.png' />";
}
}
return className;
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
string[] ids = ddlClassSubjectEmployeeID.SelectedValue.Split(',');
STD_RoutineTime sTD_RoutineTime = new STD_RoutineTime ();
sTD_RoutineTime.RoutineTimeID= int.Parse(Request.QueryString["ID"].ToString());
sTD_RoutineTime.RoutineTimeName= ddlClassSubjectEmployeeID.SelectedItem.Text + " - " + ddlRoomID.SelectedItem.Text;
sTD_RoutineTime.RoomID= int.Parse(ddlRoomID.SelectedValue);
sTD_RoutineTime.SubjectID = int.Parse(ids[1]);
sTD_RoutineTime.EmployeeID = ids[2];
sTD_RoutineTime.ClassID = int.Parse(ids[0]);
sTD_RoutineTime.ClassDayID= int.Parse(ddlClassDayID.SelectedValue);
sTD_RoutineTime.ClassTimeID= int.Parse(ddlClassTimeID.SelectedValue);
sTD_RoutineTime.RoutineID= int.Parse(ddlRoutineID.SelectedValue);
sTD_RoutineTime.AddedBy= Profile.card_id;
sTD_RoutineTime.AddedDate= DateTime.Now;
sTD_RoutineTime.UpdatedBy= Profile.card_id;
sTD_RoutineTime.UpdateDate= DateTime.Now;
bool resutl =STD_RoutineTimeManager.UpdateSTD_RoutineTime(sTD_RoutineTime);
Response.Redirect("AdminDisplaySTD_RoutineTime.aspx");
}
public String getRoutineText(int classID,int SubjectID)
{
try
{
STD_RoutineTime routineTime = new STD_RoutineTime();
routineTime.RoomID = 0;
routineTime.ClassID = classID;
routineTime.SubjectID = SubjectID;
routineTime.EmployeeID = "";
string StudentID = "";
DataSet dsRoutineTimeByClassnSubject = STD_RoutineTimeManager.STD_SearchRoutineTime(routineTime, StudentID);
routineTime = new STD_RoutineTime();
routineTime.RoomID = 0;
routineTime.ClassID = 0;
routineTime.SubjectID = 0;
routineTime.EmployeeID = "";
StudentID = hfStudentID.Value == "0" ? "" : hfStudentID.Value;
DataSet dsRoutineTimeByStudent = STD_RoutineTimeManager.STD_SearchRoutineTime(routineTime, StudentID);
DataSet dsClassTime = STD_ClassTimeManager.GetAllSTD_ClassTimes();
DataSet dsClassDay = STD_ClassDayManager.GetAllSTD_ClassDaies();
int width = 120;
int widthDay = 70;
string routine = "<table id='tblRoutineDisplay' style='font-size:10px;width:" + ((dsClassTime.Tables[0].Rows.Count * width) + widthDay).ToString() + "px'>";
string classTimeGroupID = dsClassTime.Tables[0].Rows[0]["ClassTimeGroupID"].ToString();
for (int row = 0; row < dsClassTime.Tables[0].Rows.Count; row++)
{
if (classTimeGroupID != dsClassTime.Tables[0].Rows[row]["ClassTimeGroupID"].ToString())
{
routine += "<tr><td colspan='" + (dsClassDay.Tables[0].Rows.Count + 1) + "'> </br></br></br></td></tr>";
//routine += "<tr><td colspan='" + (dsClassDay.Tables[0].Rows.Count + 1) + "'> </td></tr>";
classTimeGroupID = dsClassTime.Tables[0].Rows[row]["ClassTimeGroupID"].ToString();
}
if (row == 0)
{
routine += "<tr style='border-top:1px solid Black;'><td></td>";
for (int col = 0; col < dsClassDay.Tables[0].Rows.Count; col++)
{
routine += "<td>";
routine += dsClassDay.Tables[0].Rows[col]["ClassDayName"].ToString();
routine += "</td>";
}
routine += "</tr>";
}
routine += "<tr>";
for (int col = 0; col < dsClassDay.Tables[0].Rows.Count; col++)
{
if (col == 0)
{
routine += "<td style='min-width:" + widthDay + "px'>";
routine += dsClassTime.Tables[0].Rows[row]["ClassTimeName"].ToString();
routine += "</td>";
}
routine += "<td style='min-width:" + width + "px;'>";
routine += GetClassName(dsRoutineTimeByClassnSubject, dsRoutineTimeByStudent, dsClassTime.Tables[0].Rows[row]["ClassTimeID"].ToString(), dsClassDay.Tables[0].Rows[col]["ClassDayID"].ToString());
routine += "</td>";
}
routine += "</tr>";
}
routine += "</table>";
routine += STD_RoutineTimeManager.GetTeacherName(dsRoutineTimeByClassnSubject);
return routine;
}
catch (Exception ex)
{
return "";
}
}
protected void btnVarify_OnClick(object sender, EventArgs e)
{
hfSubjects.Value = "-";
txtStudentCode.Text = txtStudentCode.Text.Trim();
ddlClassID.SelectedIndex = 0;
ddlClassID_SelectedIndexChanged(this, new EventArgs());
STD_Student student = new STD_Student();
student = STD_StudentManager.GetHR_StudnetByStudentCode(txtStudentCode.Text);
txtAccARegistrationNo.Text = student.RegistrationNo;
if (student.RegistrationNo != "")
{
txtAccARegistrationNo.Enabled = false;
btnSaveRegistrationNo.Visible = false;
}
if (student == null)
{
lblMessage.Text = "<br/>There is no Student with this student Id";
return;
}
else
{
lblMessage.Text = "!!! Valid ID !!!";
hfStudentID.Value = student.StudentID;
StudentCodeVarification(student);
//load routine for that student;
STD_RoutineTime routineTime = new STD_RoutineTime();
routineTime.RoomID = Request.QueryString["RoomID"] == null ? 0 : int.Parse(Request.QueryString["RoomID"]);
routineTime.RoutineID = Request.QueryString["RoutineID"] == null ? 0 : int.Parse(Request.QueryString["RoutineID"]);
routineTime.ClassID = Request.QueryString["ClassID"] == null ? 0 : int.Parse(Request.QueryString["ClassID"]);
routineTime.SubjectID = Request.QueryString["SubjectID"] == null ? 0 : int.Parse(Request.QueryString["SubjectID"]);
routineTime.EmployeeID = Request.QueryString["EmployeeID"] == null ? "" : Request.QueryString["EmployeeID"];
string StudentID = hfStudentID.Value;
lblVerifyRoutine.Text = STD_RoutineTimeManager.getRoutineTextDayTop(routineTime, StudentID);
lblVerifyRoutine.Text = lblVerifyRoutine.Text.Replace("id='tblRoutineDisplay'", "border='1'");
lblVerifyRoutine.Text = lblVerifyRoutine.Text.Replace("id='tblRoutineDisplayTeacher'", "border='1'");
//lblVerifyRoutine.Text = //getRoutineText(0,0);
}
loadHistory(student);
}
private void loadRoutine()
{
try
{
STD_RoutineTime routineTime = new STD_RoutineTime();
routineTime.RoomID = 0;
routineTime.ClassID = 0;
routineTime.SubjectID = 0;
routineTime.EmployeeID = "";
string StudentID = hfStudentID.Value == "0" ? "" : hfStudentID.Value;
lblRoutineDisplayForStudent.Text = STD_RoutineTimeManager.getRoutineTextDayTop(routineTime, StudentID);
}
catch (Exception ex)
{ }
}
public static STD_RoutineTime GetSTD_ClassDayByClassDayID(int ClassDayID)
{
STD_RoutineTime sTD_RoutineTime = new STD_RoutineTime();
SqlSTD_RoutineTimeProvider sqlSTD_RoutineTimeProvider = new SqlSTD_RoutineTimeProvider();
sTD_RoutineTime = sqlSTD_RoutineTimeProvider.GetSTD_RoutineTimeByClassDayID(ClassDayID);
return sTD_RoutineTime;
}
private void loadRoutine()
{
STD_RoutineTime routineTime = new STD_RoutineTime();
routineTime.RoomID = 0;
routineTime.RoutineID = ddlCampus.SelectedValue == "0" ? 0 : int.Parse(ddlRoutineID.SelectedValue);
routineTime.ClassID = int.Parse(ddlClassID.SelectedValue);
routineTime.SubjectID = int.Parse(ddlSubjectID.SelectedValue);
routineTime.EmployeeID = ddlEmployeeID.SelectedValue == "0" ? "" : ddlEmployeeID.SelectedValue;
string StudentID = "";
lblRoutineDisplay.Text = STD_RoutineTimeManager.getRoutineTextDayTop(routineTime, StudentID).Replace(" style='display:none;'", "");
}
protected void btnAdd_Click(object sender, EventArgs e)
{
try
{
lblMessage.Text= varifyConfict();
if (lblMessage.Text != "")
return;
STD_RoutineTime sTD_RoutineTime = new STD_RoutineTime();
sTD_RoutineTime.RoutineTimeName = "(" + ddlSubjectID.SelectedItem.Text.Split('(')[0] + ")(" + ddlClassID.SelectedItem.Text + ")(" + ddlEmployeeID.SelectedItem.Text + ")(" + ddlRoomID.SelectedItem.Text.Split('(')[0] + ")";
sTD_RoutineTime.RoomID = int.Parse(ddlRoomID.SelectedValue);
sTD_RoutineTime.SubjectID = int.Parse(ddlSubjectID.SelectedValue);
sTD_RoutineTime.EmployeeID = ddlEmployeeID.SelectedValue;
sTD_RoutineTime.ClassID = int.Parse(ddlClassID.SelectedValue);
//sTD_RoutineTime.ClassDayID = int.Parse(ddlClassDayID.SelectedValue);
//sTD_RoutineTime.ClassTimeID = int.Parse(ddlClassTimeID.SelectedValue);
sTD_RoutineTime.RoutineID = int.Parse(ddlRoutineID.SelectedValue);
sTD_RoutineTime.AddedBy = Profile.card_id;
sTD_RoutineTime.AddedDate = DateTime.Now;
sTD_RoutineTime.UpdatedBy = Profile.card_id;
sTD_RoutineTime.UpdateDate = DateTime.Now;
int resutl = 0;
foreach (GridViewRow row in gvClassDay.Rows)
{
Label lblDayID = (Label)row.FindControl("lblDayID");
HiddenField hfDayID = (HiddenField)row.FindControl("hfDayID");
DataList dlTime = (DataList)row.FindControl("dlTime");
foreach (DataListItem iteam in dlTime.Items)
{
HiddenField hfClassTimeID = (HiddenField)iteam.FindControl("hfClassTimeID");
CheckBox chkTime = (CheckBox)iteam.FindControl("chkTime");
if (chkTime.Checked)
{
sTD_RoutineTime.ClassTimeID = int.Parse(hfClassTimeID.Value);
sTD_RoutineTime.ClassDayID = int.Parse(hfDayID.Value);
try
{
resutl = STD_RoutineTimeManager.InsertSTD_RoutineTime(sTD_RoutineTime);
}
catch (Exception ex)
{ }
}
}
//CheckBoxList chkClassTime = (CheckBoxList)row.FindControl("chkClassTime");
//string routineTime = "";
//foreach (ListItem item in chkClassTime.Items)
//{
// routineTime += item.Value + ",";
//}
//string[] spTime = routineTime.Split(',');
//for (int i = 0; i < spTime.Length; i++)
//{
// sTD_RoutineTime.ClassTimeID = Convert.ToInt32(spTime[i]);
// sTD_RoutineTime.ClassDayID = Convert.ToInt32(lblDayID.Text);
// int resutl = STD_RoutineTimeManager.InsertSTD_RoutineTime(sTD_RoutineTime);
// if (resutl == 0)
// lblMessage.Text = "Entry already exists for the time";
//}
}
//int resutl = STD_RoutineTimeManager.InsertSTD_RoutineTime(sTD_RoutineTime);
//if (resutl == 0)
// lblMessage.Text = "Entry already exists for the time";
//else
loadRoutine();
btnAdd.Visible = false;
//btnLoadDaynTime_Click(this, new EventArgs());
//Response.Redirect("Class_Display_RoutineTime_ByValues.aspx?IsDelete=0&CampusID=" + ddlCampus.SelectedValue + "&RoutineID=" + ddlRoutineID.SelectedValue + "&ClassID=" + ddlClassID.SelectedValue + "&SubjectID=" + ddlSubjectID.SelectedValue + "&EmployeeID=" + ddlEmployeeID.SelectedValue );
}
catch (Exception ex)
{
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
try
{
STD_RoutineTime sTD_RoutineTime = new STD_RoutineTime();
sTD_RoutineTime.RoutineTimeName = txtRoutineTimeName.Text;
sTD_RoutineTime.RoomID = int.Parse(ddlRoomID.SelectedValue);
sTD_RoutineTime.SubjectID = int.Parse(ddlSubjectID.SelectedValue);
sTD_RoutineTime.EmployeeID = ddlEmployeeID.SelectedValue;
sTD_RoutineTime.ClassID = int.Parse(ddlClassID.SelectedValue);
//sTD_RoutineTime.ClassDayID = int.Parse(ddlClassDayID.SelectedValue);
//sTD_RoutineTime.ClassTimeID = int.Parse(ddlClassTimeID.SelectedValue);
sTD_RoutineTime.RoutineID = int.Parse(ddlRoutineID.SelectedValue);
sTD_RoutineTime.AddedBy = Profile.card_id;
sTD_RoutineTime.AddedDate = DateTime.Now;
sTD_RoutineTime.UpdatedBy = Profile.card_id;
sTD_RoutineTime.UpdateDate = DateTime.Now;
foreach (GridView row in gvClassDay.Rows)
{
Label lblDayID = (Label)row.FindControl("lblDayID");
CheckBoxList chkClassTime = (CheckBoxList)row.FindControl("chkClassTime");
string routineTime = "";
foreach (ListItem item in chkClassTime.Items)
{
routineTime += item.Value + ",";
}
string[] spTime = routineTime.Split(',');
for (int i = 0; i < spTime.Length; i++)
{
sTD_RoutineTime.ClassTimeID = Convert.ToInt32(spTime[i]);
sTD_RoutineTime.ClassDayID = Convert.ToInt32(lblDayID.Text);
int resutl = STD_RoutineTimeManager.InsertSTD_RoutineTime(sTD_RoutineTime);
if (resutl == 0)
lblMessage.Text = "Entry already exists for the time";
}
}
//string routineTime = "";
//foreach (ListItem item in chkClassTime.Items)
//{
// if (item.Selected)
// routineTime += item.Value + ",";
//}
//int resutl = STD_RoutineTimeManager.InsertSTD_RoutineTime(sTD_RoutineTime);
//if (resutl == 0)
// lblMessage.Text = "Entry already exists for the time";
//else
// Response.Redirect("AdminDisplaySTD_RoutineTime.aspx");
}
catch (Exception ex)
{
}
}
public static bool UpdateSTD_RoutineTime(STD_RoutineTime sTD_RoutineTime)
{
SqlSTD_RoutineTimeProvider sqlSTD_RoutineTimeProvider = new SqlSTD_RoutineTimeProvider();
return sqlSTD_RoutineTimeProvider.UpdateSTD_RoutineTime(sTD_RoutineTime);
}
public static DataSet STD_SearchRoutineTimeForRoutineCheck(STD_RoutineTime routineTime, string studentID)
{
DataSet sTD_RoutineTimes = new DataSet();
SqlSTD_RoutineTimeProvider sqlSTD_RoutineTimeProvider = new SqlSTD_RoutineTimeProvider();
sTD_RoutineTimes = sqlSTD_RoutineTimeProvider.STD_SearchRoutineTimeForRoutineCheck(routineTime, studentID);
return sTD_RoutineTimes;
}
public static int InsertSTD_RoutineTime(STD_RoutineTime sTD_RoutineTime)
{
SqlSTD_RoutineTimeProvider sqlSTD_RoutineTimeProvider = new SqlSTD_RoutineTimeProvider();
return sqlSTD_RoutineTimeProvider.InsertSTD_RoutineTime(sTD_RoutineTime);
}
public static STD_RoutineTime GetSTD_SubjectBySubjectID(int SubjectID)
{
STD_RoutineTime sTD_RoutineTime = new STD_RoutineTime();
SqlSTD_RoutineTimeProvider sqlSTD_RoutineTimeProvider = new SqlSTD_RoutineTimeProvider();
sTD_RoutineTime = sqlSTD_RoutineTimeProvider.GetSTD_RoutineTimeBySubjectID(SubjectID);
return sTD_RoutineTime;
}
public static STD_RoutineTime GetSTD_RoutineTimeByRoutineTimeID(int RoutineTimeID)
{
STD_RoutineTime sTD_RoutineTime = new STD_RoutineTime();
SqlSTD_RoutineTimeProvider sqlSTD_RoutineTimeProvider = new SqlSTD_RoutineTimeProvider();
sTD_RoutineTime = sqlSTD_RoutineTimeProvider.GetSTD_RoutineTimeByRoutineTimeID(RoutineTimeID);
return sTD_RoutineTime;
}
public static STD_RoutineTime GetSTD_EmployeeByEmployeeID(string EmployeeID)
{
STD_RoutineTime sTD_RoutineTime = new STD_RoutineTime();
SqlSTD_RoutineTimeProvider sqlSTD_RoutineTimeProvider = new SqlSTD_RoutineTimeProvider();
sTD_RoutineTime = sqlSTD_RoutineTimeProvider.GetSTD_RoutineTimeByEmployeeID(EmployeeID);
return sTD_RoutineTime;
}
public STD_RoutineTime GetSTD_RoutineTimeFromReader(IDataReader reader)
{
try
{
STD_RoutineTime sTD_RoutineTime = new STD_RoutineTime
(
DataAccessObject.IsNULL<int>(reader["RoutineTimeID"]),
DataAccessObject.IsNULL<string>(reader["RoutineTimeName"]),
DataAccessObject.IsNULL<int>(reader["RoomID"]),
DataAccessObject.IsNULL<int>(reader["SubjectID"]),
DataAccessObject.IsNULL<string>(reader["EmployeeID"].ToString()),
DataAccessObject.IsNULL<int>(reader["ClassID"]),
DataAccessObject.IsNULL<int>(reader["ClassDayID"]),
DataAccessObject.IsNULL<int>(reader["ClassTimeID"]),
DataAccessObject.IsNULL<int>(reader["RoutineID"]),
DataAccessObject.IsNULL<string>(reader["AddedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["AddedDate"]),
DataAccessObject.IsNULL<string>(reader["UpdatedBy"].ToString()),
DataAccessObject.IsNULL<DateTime>(reader["UpdateDate"])
);
return sTD_RoutineTime;
}
catch(Exception ex)
{
return null;
}
}
private void BindDayIDTimeIDPair()
{
string dayIDTimeIDPair = ";";
STD_RoutineTime routineTime = new STD_RoutineTime();
routineTime.RoomID = int.Parse(ddlRoomID.SelectedValue);
routineTime.SubjectID = int.Parse(ddlSubjectID.SelectedValue);
routineTime.ClassID = int.Parse(ddlClassID.SelectedValue);
routineTime.EmployeeID = ddlEmployeeID.SelectedValue;
DataSet dsRoomEmployeeClass = STD_RoutineTimeManager.STD_SearchRoutineTimeForRoutineCheck(routineTime, "");
foreach (DataRow dr in dsRoomEmployeeClass.Tables[0].Rows)// table[0] == for Room
{
for (int i = int.Parse(dr["ExtraField1"].ToString()); i <= int.Parse(dr["ExtraField2"].ToString()); i++)
{
//if (!dayIDTimeIDPair.Contains(";" + dr["ClassDayID"].ToString() + "-" + dr["ClassTimeID"].ToString() + ";"))
//{
// dayIDTimeIDPair += dr["ClassDayID"].ToString() + "-" + dr["ClassTimeID"].ToString() + ";";
//}
if (!dayIDTimeIDPair.Contains(";" + dr["ClassDayID"].ToString() + "-" + i.ToString() + ";"))
{
dayIDTimeIDPair += dr["ClassDayID"].ToString() + "-" + i.ToString() + ";";
}
}
fillddlForRoutine(dr["RoutineTimeID"].ToString(), getClassName(dr));
fillddl(dr["ClassDayID"].ToString() + "-" + dr["ClassTimeID"].ToString(), "R" + dr["RoutineTimeID"].ToString());
}
lblHaveClassInHour.Text = "0";
lblTotalNoOfClasses.Text = dsRoomEmployeeClass.Tables[1].Rows.Count.ToString();
foreach (DataRow dr in dsRoomEmployeeClass.Tables[1].Rows) // table[1] == Employee
{
for (int i = int.Parse(dr["ExtraField1"].ToString()); i <= int.Parse(dr["ExtraField2"].ToString()); i++)
{
//if (!dayIDTimeIDPair.Contains(";" + dr["ClassDayID"].ToString() + "-" + dr["ClassTimeID"].ToString() + ";"))
//{
// dayIDTimeIDPair += dr["ClassDayID"].ToString() + "-" + dr["ClassTimeID"].ToString() + ";";
//}
if (!dayIDTimeIDPair.Contains(";" + dr["ClassDayID"].ToString() + "-" + i.ToString() + ";"))
{
dayIDTimeIDPair += dr["ClassDayID"].ToString() + "-" + i.ToString() + ";";
}
}
fillddlForRoutine(dr["RoutineTimeID"].ToString(), getClassName(dr));
fillddl(dr["ClassDayID"].ToString() + "-" + dr["ClassTimeID"].ToString(), "T" + dr["RoutineTimeID"].ToString());
lblHaveClassInHour.Text = (decimal.Parse(lblHaveClassInHour.Text) + decimal.Parse(dr["Duration"].ToString())).ToString();
}
lblHaveClassInHour.Text = (decimal.Parse(lblHaveClassInHour.Text) / 60).ToString("0") + " : " + (decimal.Parse(lblHaveClassInHour.Text) % 60).ToString();
foreach (DataRow dr in dsRoomEmployeeClass.Tables[2].Rows) //table[2] == Class
{
for (int i = int.Parse(dr["ExtraField1"].ToString()); i <= int.Parse(dr["ExtraField2"].ToString()); i++)
{
//if (!dayIDTimeIDPair.Contains(";" + dr["ClassDayID"].ToString() + "-" + dr["ClassTimeID"].ToString() + ";"))
//{
// dayIDTimeIDPair += dr["ClassDayID"].ToString() + "-" + dr["ClassTimeID"].ToString() + ";";
//}
if (!dayIDTimeIDPair.Contains(";" + dr["ClassDayID"].ToString() + "-" + i.ToString() + ";"))
{
dayIDTimeIDPair += dr["ClassDayID"].ToString() + "-" + i.ToString() + ";";
}
}
fillddlForRoutine(dr["RoutineTimeID"].ToString(), getClassName(dr));
fillddl(dr["ClassDayID"].ToString() + "-" + dr["ClassTimeID"].ToString(), "C" + dr["RoutineTimeID"].ToString());
}
//foreach (DataRow dr in dsRoomEmployeeClass.Tables[3].Rows) //table[3] == other Classes and subjects of those student who are also member of other classes
//{
// for (int i = int.Parse(dr["ExtraField1"].ToString()); i <= int.Parse(dr["ExtraField2"].ToString()); i++)
// {
// //if (!dayIDTimeIDPair.Contains(";" + dr["ClassDayID"].ToString() + "-" + dr["ClassTimeID"].ToString() + ";"))
// //{
// // dayIDTimeIDPair += dr["ClassDayID"].ToString() + "-" + dr["ClassTimeID"].ToString() + ";";
// //}
// if (!dayIDTimeIDPair.Contains(";" + dr["ClassDayID"].ToString() + "-" + i.ToString() + ";"))
// {
// dayIDTimeIDPair += dr["ClassDayID"].ToString() + "-" + i.ToString() + ";";
// }
// }
// fillddlForRoutine(dr["RoutineTimeID"].ToString(), getClassName(dr));
// fillddl(dr["ClassDayID"].ToString() + "-" + dr["ClassTimeID"].ToString(), "C" + dr["RoutineTimeID"].ToString());
//}
//if (dsRoomEmployeeClass.Tables[4].Rows.Count == 0)
//{
btnDeleteClassSubject.Visible = false;
btnDeleteFromSelectedClass.Visible = false;
btnPassClassSubject.Visible = false;
//}
//else
//{
// btnDeleteClassSubject.Visible = true;
// btnDeleteFromSelectedClass.Visible = true;
// btnPassClassSubject.Visible = true;
//}
//gvListOfStudentsWhohaveClassesInOtherThanSelectClass.DataSource = dsRoomEmployeeClass.Tables[4];
//gvListOfStudentsWhohaveClassesInOtherThanSelectClass.DataBind();
hfDayIDTimeIDPair.Value = dayIDTimeIDPair;
}
private void showSTD_RoutineTimeData()
{
STD_RoutineTime sTD_RoutineTime = new STD_RoutineTime ();
sTD_RoutineTime = STD_RoutineTimeManager.GetSTD_RoutineTimeByRoutineTimeID(Int32.Parse(Request.QueryString["ID"]));
//txtRoutineTimeName.Text =sTD_RoutineTime.RoutineTimeName.ToString();
ddlRoomID.SelectedValue =sTD_RoutineTime.RoomID.ToString();
//ddlSubjectID.SelectedValue =sTD_RoutineTime.SubjectID.ToString();
//ddlEmployeeID.SelectedValue =sTD_RoutineTime.EmployeeID.ToString();
//ddlClassID.SelectedValue =sTD_RoutineTime.ClassID.ToString();
ddlClassDayID.SelectedValue =sTD_RoutineTime.ClassDayID.ToString();
ddlClassTimeID.SelectedValue =sTD_RoutineTime.ClassTimeID.ToString();
ddlRoutineID.SelectedValue =sTD_RoutineTime.RoutineID.ToString();
}
public bool UpdateSTD_RoutineTime(STD_RoutineTime sTD_RoutineTime)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateSTD_RoutineTime", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@RoutineTimeID", SqlDbType.Int).Value = sTD_RoutineTime.RoutineTimeID;
cmd.Parameters.Add("@RoutineTimeName", SqlDbType.NVarChar).Value = sTD_RoutineTime.RoutineTimeName;
cmd.Parameters.Add("@RoomID", SqlDbType.Int).Value = sTD_RoutineTime.RoomID;
cmd.Parameters.Add("@SubjectID", SqlDbType.Int).Value = sTD_RoutineTime.SubjectID;
cmd.Parameters.Add("@EmployeeID", SqlDbType.NVarChar).Value = sTD_RoutineTime.EmployeeID;
cmd.Parameters.Add("@ClassID", SqlDbType.Int).Value = sTD_RoutineTime.ClassID;
cmd.Parameters.Add("@ClassDayID", SqlDbType.Int).Value = sTD_RoutineTime.ClassDayID;
cmd.Parameters.Add("@ClassTimeID", SqlDbType.Int).Value = sTD_RoutineTime.ClassTimeID;
cmd.Parameters.Add("@RoutineID", SqlDbType.Int).Value = sTD_RoutineTime.RoutineID;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = sTD_RoutineTime.UpdatedBy;
cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = sTD_RoutineTime.UpdateDate;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public DataSet STD_SearchRoutineTimeForRoutineCheck(STD_RoutineTime routineTime, string studentID)
{
DataSet ds = new DataSet();
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
using (SqlCommand command = new SqlCommand("STD_SearchRoutineTimeForRoutineCheck", connection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@ClassID", routineTime.ClassID);
command.Parameters.AddWithValue("@RoomID", routineTime.RoomID);
command.Parameters.AddWithValue("@SubjectID", routineTime.SubjectID);
command.Parameters.AddWithValue("@StudentID", studentID);
command.Parameters.AddWithValue("@EmployeeID", routineTime.EmployeeID);
connection.Open();
SqlDataAdapter myadapter = new SqlDataAdapter(command);
myadapter.Fill(ds);
myadapter.Dispose();
connection.Close();
return ds;
}
}
}
private void BindDayIDTimeIDPair()
{
string dayIDTimeIDPair = ";";
STD_RoutineTime routineTime = new STD_RoutineTime();
routineTime.RoomID = int.Parse(ddlRoomID.SelectedValue);
routineTime.SubjectID = int.Parse(ddlSubjectID.SelectedValue);
routineTime.ClassID = int.Parse(ddlClassID.SelectedValue);
routineTime.EmployeeID = ddlEmployeeID.SelectedValue;
DataSet dsRoomEmployeeClass= STD_RoutineTimeManager.STD_SearchRoutineTimeForRoutineCheck(routineTime,"");
foreach (DataRow dr in dsRoomEmployeeClass.Tables[0].Rows)// table[0] == for Room
{
for (int i = int.Parse(dr["ExtraField1"].ToString()); i <= int.Parse(dr["ExtraField2"].ToString()); i++)
{
//if (!dayIDTimeIDPair.Contains(";" + dr["ClassDayID"].ToString() + "-" + dr["ClassTimeID"].ToString() + ";"))
//{
// dayIDTimeIDPair += dr["ClassDayID"].ToString() + "-" + dr["ClassTimeID"].ToString() + ";";
//}
if (!dayIDTimeIDPair.Contains(";" + dr["ClassDayID"].ToString() + "-" + i.ToString() + ";"))
{
dayIDTimeIDPair += dr["ClassDayID"].ToString() + "-" + i.ToString() + ";";
}
}
fillddlForRoutine(dr["RoutineTimeID"].ToString(), getClassName(dr));
fillddl(dr["ClassDayID"].ToString() + "-" + dr["ClassTimeID"].ToString(), "R" + dr["RoutineTimeID"].ToString());
}
lblHaveClassInHour.Text = "0";
lblTotalNoOfClasses.Text = dsRoomEmployeeClass.Tables[1].Rows.Count.ToString();
foreach (DataRow dr in dsRoomEmployeeClass.Tables[1].Rows) // table[1] == Employee
{
for (int i = int.Parse(dr["ExtraField1"].ToString()); i <= int.Parse(dr["ExtraField2"].ToString()); i++)
{
//if (!dayIDTimeIDPair.Contains(";" + dr["ClassDayID"].ToString() + "-" + dr["ClassTimeID"].ToString() + ";"))
//{
// dayIDTimeIDPair += dr["ClassDayID"].ToString() + "-" + dr["ClassTimeID"].ToString() + ";";
//}
if (!dayIDTimeIDPair.Contains(";" + dr["ClassDayID"].ToString() + "-" + i.ToString() + ";"))
{
dayIDTimeIDPair += dr["ClassDayID"].ToString() + "-" + i.ToString() + ";";
}
}
fillddlForRoutine(dr["RoutineTimeID"].ToString(), getClassName(dr));
fillddl(dr["ClassDayID"].ToString() + "-" + dr["ClassTimeID"].ToString(), "T" + dr["RoutineTimeID"].ToString());
lblHaveClassInHour.Text = (decimal.Parse(lblHaveClassInHour.Text) + decimal.Parse(dr["Duration"].ToString())).ToString();
}
lblHaveClassInHour.Text = (decimal.Parse(lblHaveClassInHour.Text) / 60).ToString("0") + " : " + (decimal.Parse(lblHaveClassInHour.Text) % 60).ToString();
foreach (DataRow dr in dsRoomEmployeeClass.Tables[2].Rows) //table[2] == Class
{
for (int i = int.Parse(dr["ExtraField1"].ToString()); i <= int.Parse(dr["ExtraField2"].ToString()); i++)
{
//if (!dayIDTimeIDPair.Contains(";" + dr["ClassDayID"].ToString() + "-" + dr["ClassTimeID"].ToString() + ";"))
//{
// dayIDTimeIDPair += dr["ClassDayID"].ToString() + "-" + dr["ClassTimeID"].ToString() + ";";
//}
if (!dayIDTimeIDPair.Contains(";" + dr["ClassDayID"].ToString() + "-" + i.ToString() + ";"))
{
dayIDTimeIDPair += dr["ClassDayID"].ToString() + "-" + i.ToString() + ";";
}
}
fillddlForRoutine(dr["RoutineTimeID"].ToString(), getClassName(dr));
fillddl(dr["ClassDayID"].ToString() + "-" + dr["ClassTimeID"].ToString(), "C" + dr["RoutineTimeID"].ToString());
}
foreach (DataRow dr in dsRoomEmployeeClass.Tables[3].Rows) //table[2] == other Classes
{
for (int i = int.Parse(dr["ExtraField1"].ToString()); i <= int.Parse(dr["ExtraField2"].ToString()); i++)
{
//if (!dayIDTimeIDPair.Contains(";" + dr["ClassDayID"].ToString() + "-" + dr["ClassTimeID"].ToString() + ";"))
//{
// dayIDTimeIDPair += dr["ClassDayID"].ToString() + "-" + dr["ClassTimeID"].ToString() + ";";
//}
if (!dayIDTimeIDPair.Contains(";" + dr["ClassDayID"].ToString() + "-" + i.ToString() + ";"))
{
dayIDTimeIDPair += dr["ClassDayID"].ToString() + "-" + i.ToString() + ";";
}
}
fillddlForRoutine(dr["RoutineTimeID"].ToString(), getClassName(dr));
fillddl(dr["ClassDayID"].ToString() + "-" + dr["ClassTimeID"].ToString(), "C" + dr["RoutineTimeID"].ToString());
}
hfDayIDTimeIDPair.Value= dayIDTimeIDPair;
}
protected void ddlClassID_OnSelectedIndexChanged(object sender, EventArgs e)
{
//loadClass();
try
{
STD_RoutineTime routineTime = new STD_RoutineTime();
routineTime.RoomID = 0;
routineTime.ClassID = int.Parse(ddlClassID.SelectedValue.Split('-')[1]);
routineTime.SubjectID = int.Parse(ddlSubjectID.SelectedValue);
routineTime.EmployeeID = "";
string StudentID = "";
lblRoutineDisplayForSelectedClassNSubject.Text = STD_RoutineTimeManager.getRoutineTextDayTop(routineTime, StudentID);
}
catch (Exception ex)
{ }
}
private void showSTD_RoutineTimeData()
{
try
{
STD_RoutineTime sTD_RoutineTime = new STD_RoutineTime();
sTD_RoutineTime = STD_RoutineTimeManager.GetSTD_RoutineTimeByRoutineTimeID(Int32.Parse(Request.QueryString["ID"]));
txtRoutineTimeName.Text = sTD_RoutineTime.RoutineTimeName.ToString();
//RoomIDLoad();
//SubjectIDLoad();
//EmployeeIDLoad();
ddlRoomID.SelectedValue = sTD_RoutineTime.RoomID.ToString();
ddlClassID.SelectedValue = sTD_RoutineTime.ClassID.ToString();
ddlClassID_SelectedIndexChanged(this, new EventArgs());
ddlSubjectID.SelectedValue = sTD_RoutineTime.SubjectID.ToString();
ddlSubjectID_SelectedIndexChanged(this, new EventArgs());
ddlEmployeeID.SelectedValue = sTD_RoutineTime.EmployeeID.ToString();
//ddlClassDayID.SelectedValue = sTD_RoutineTime.ClassDayID.ToString();
//ddlClassTimeID.SelectedValue = sTD_RoutineTime.ClassTimeID.ToString();
//ddlRoutineID.SelectedValue = sTD_RoutineTime.RoutineID.ToString();
}
catch (Exception ex)
{
}
}
public static String getRoutineTextDayTop(STD_RoutineTime routineTime, string StudentID)
{
try
{
DataSet dsRoutineTime = STD_RoutineTimeManager.STD_SearchRoutineTime(routineTime, StudentID);
DataSet dsClassTime = STD_ClassTimeManager.GetAllSTD_ClassTimes();
DataSet dsClassDay = STD_ClassDayManager.GetAllSTD_ClassDaies();
int width = 120;
int widthDay = 70;
string routine = "";
if (dsRoutineTime.Tables[1].Rows.Count > 0)
{
if (routineTime.RoutineID != 0)
{
routine += "<br/><b>Campus :</b> " + dsRoutineTime.Tables[1].Rows[0]["CampusName"];
}
if (routineTime.RoomID != 0)
{
routine += "<br/><b>Room :</b> " + dsRoutineTime.Tables[1].Rows[0]["RoomName"];
}
if (routineTime.ClassID != 0)
{
routine += "<br/><b>Batch :</b> " + dsRoutineTime.Tables[1].Rows[0]["ClassName"];
}
if (routineTime.SubjectID != 0)
{
routine += "<br/><b>Subject :</b> " + dsRoutineTime.Tables[1].Rows[0]["SubjectName"];
}
if (routineTime.EmployeeID != "")
{
routine += "<br/><b>Teacher :</b> " + dsRoutineTime.Tables[1].Rows[0]["EmployeeName"];
}
}
routine += "<table id='tblRoutineDisplay' style='font-size:10px;'>";
//string routine = "<table id='tblRoutineDisplay' style='font-size:10px;width:" + ((dsClassTime.Tables[0].Rows.Count * width) + widthDay).ToString() + "px'>";
string classTimeGroupID = dsClassTime.Tables[0].Rows[0]["ClassTimeGroupID"].ToString();
bool lastSetEmpty = false;
string daysNameRow = "";
for (int row = 0; row < dsClassTime.Tables[0].Rows.Count; row++)
{
if (classTimeGroupID != dsClassTime.Tables[0].Rows[row]["ClassTimeGroupID"].ToString())
{
if (!lastSetEmpty)
{
routine = routine.Replace("<tr><td style='color:white;' colspan='" + (dsClassDay.Tables[0].Rows.Count + 1) + "'> </br>" + classTimeGroupID + "</td></tr>", "");
}
routine += "<tr><td style='color:white;' colspan='" + (dsClassDay.Tables[0].Rows.Count + 1) + "'> </br>" + dsClassTime.Tables[0].Rows[row]["ClassTimeGroupID"].ToString() + "</td></tr>";
//routine += "<tr><td colspan='" + (dsClassDay.Tables[0].Rows.Count + 1) + "'> </td></tr>";
classTimeGroupID = dsClassTime.Tables[0].Rows[row]["ClassTimeGroupID"].ToString();
lastSetEmpty = false;
}
if (row == 0)
{
daysNameRow += "<tr><td></td>";
for (int col = 0; col < dsClassDay.Tables[0].Rows.Count; col++)
{
daysNameRow += "<td>";
daysNameRow += dsClassDay.Tables[0].Rows[col]["ClassDayName"].ToString();
daysNameRow += "</td>";
}
daysNameRow += "</tr>";
routine += daysNameRow;
}
string tmp = "";
bool needtoAdd = false;
tmp += "<tr>";
for (int col = 0; col < dsClassDay.Tables[0].Rows.Count; col++)
{
if (col == 0)
{
//routine += "<td valign='top' style='min-width:" + widthDay + "px'>";
tmp += "<td valign='top'>";
tmp += dsClassTime.Tables[0].Rows[row]["ClassTimeName"].ToString();
tmp += "</td>";
}
//routine += "<td valign='top' style='min-width:" + width + "px;'>";
tmp += "<td valign='top' >";
string tmp1 = GetClassName(routineTime, dsRoutineTime, dsClassTime.Tables[0].Rows[row]["ClassTimeID"].ToString(), dsClassDay.Tables[0].Rows[col]["ClassDayID"].ToString());
if (tmp1 != "")
{
tmp += tmp1;
needtoAdd = true;
}
tmp += "</td>";
}
tmp += "</tr>";
if (needtoAdd)
{
routine += tmp;
lastSetEmpty = true;
}
}
if (!lastSetEmpty)
{
routine = routine.Replace("<tr><td style='color:white;' colspan='" + (dsClassDay.Tables[0].Rows.Count + 1) + "'> </br></br></br>" + classTimeGroupID + "</td></tr>", "");
}
routine += daysNameRow;
routine += "</table>";
routine += GetTeacherName(dsRoutineTime);
return routine;
}
catch (Exception ex)
{
return "";
}
}