public void addLeaveToDB(LeaveApplicationDA leaveObj)
{
string query = "";
try
{
query = XMLreader.readXMLtxt("addLeave", "~/DATA/XML/LeaveXML.xml");
leaveObj.leaveID = getLeaveId(teacherID).ToString();
query = query.Replace("@TEACHER_ID", leaveObj.teacherID);
query = query.Replace("@LEAVE_ID", leaveObj.leaveID.ToString());
query = query.Replace("@START_DATE", leaveObj.startDate.ToString("yyyy/M/d"));
query = query.Replace("@END_DATE", leaveObj.endDate.ToString("yyyy/M/d"));
query = query.Replace("@DURATION", leaveObj.duration.ToString());
query = query.Replace("@REASON", leaveObj.reason);
query = query.Replace("@STATUS", leaveObj.status.ToString());
query = query.Replace("@LEAVE_TYPE_ID", leaveObj.leaveTypeId);
query = query.Replace("@LEAVE_CATEGORY_ID", leaveObj.leaveCategoryId);
query = query.Replace("@ABSENT_TIME_PERIOD", leaveObj.absentTimePeriod);
srv.Modify(query);
}
catch (Exception ex)
{
throw ex;
}
}
//......................ttDA................................
public void recInsert(String gID, String cID, String sID, String sCode, String tID)
{
string query1 = "", query2 = "";
try
{
//srv = new smss_web_service_app();
//XMLreader = new readXML();
query1 = XMLreader.readXMLtxt("InsertToSlotAllocation", "~/DATA/XML/TimetableXML.xml");
query1 = query1.Replace("@gID", gID);
query1 = query1.Replace("@cID", cID);
query1 = query1.Replace("@sID", sID);
query1 = query1.Replace("@sCode", sCode);
srv.Modify(query1);
// srv.Search(query1);
query2 = XMLreader.readXMLtxt("InsertToTeacherAssignedToSlot", "~/DATA/XML/TimetableXML.xml");
query2 = query2.Replace("@tID", tID);
query2 = query2.Replace("@cID", cID);
query2 = query2.Replace("@sID", sID);
srv.Modify(query2);
}
catch (Exception ex)
{
throw ex;
}
}
// ..........................................VIEW TEACHER TIMETABLE.............................................
public void viewTeacherTimetable(string teacher_id)
{
// xmlReader = new readXML();
// srv = new smss_web_service_app();
string query = "";
string query1 = "";
try
{
query1 = XMLreader.readXMLtxt("createTemporyTable", "~/DATA/XML/timetableXML.xml");
srv.Modify(query1);
int mon = 1;
int tue = 9;
int wed = 17;
int thu = 25;
int fri = 33;
for (int i = 0; i <= 7; i++)
{
srv = new smss_web_service_app();
query = XMLreader.readXMLtxt("insert_tempory", "~/DATA/XML/timetableXML.xml");
query = query.Replace("@teacher_id", teacher_id);
query = query.Replace("@mon", mon.ToString());
query = query.Replace("@tue", tue.ToString());
query = query.Replace("@wed", wed.ToString());
query = query.Replace("@thu", thu.ToString());
query = query.Replace("@fri", fri.ToString());
srv.Modify(query);
mon = mon + 1;
tue = tue + 1;
wed = wed + 1;
thu = thu + 1;
fri = fri + 1;
}
}
catch (Exception ex)
{
throw ex;
}
}