public string getSchedule4Admin()//הבאת תגבורים
{
Tigburim newTigbur = new Tigburim();
List <Tigburim> listTigbur = newTigbur.getTigburimList("studentDBConnectionString", "Lesson");
JavaScriptSerializer js = new JavaScriptSerializer();
// serialize to string
string jsonStringgetSchedule = js.Serialize(listTigbur);
return(jsonStringgetSchedule);
}
public string getTigburByIdTeacher(string id)
{
Tigburim newTigbur = (new Tigburim()).getTigburById(id);
JavaScriptSerializer js = new JavaScriptSerializer();
// serialize to string
string jsonStringGetTurtering = js.Serialize(newTigbur);
return(jsonStringGetTurtering);
}
public string getRelevantTemplate(string startDate)
{
Tigburim newTigbur = new Tigburim();
List <Tigburim> listTigbur = newTigbur.getTigburimTemplate(startDate);
JavaScriptSerializer js = new JavaScriptSerializer();
// serialize to string
string jsonStringGetTurtering = js.Serialize(listTigbur);
return(jsonStringGetTurtering);
}
public string getSpecificSchedule(string id)// הבאת תגבורים לתלמיד
{
Tigburim newTigbur = new Tigburim();
List <Tigburim> listTigbur = newTigbur.getTigburimListForStudent("studentDBConnectionString", "Lesson", id);
JavaScriptSerializer js = new JavaScriptSerializer();
// serialize to string
string jsonStringgetSchedule = js.Serialize(listTigbur);
return(jsonStringgetSchedule);
}
public Tigburim getTigburById(string tigID)
{
int TigID = Convert.ToInt16(tigID);
DBServices dbs = new DBServices();
Tigburim DBTigbur = dbs.getTigburById(TigID, "studentDBConnectionString", "Lesson");
if (DBTigbur == null)
{
return(null);
}
else
{
return(DBTigbur);
}
}
public string getTigburById(string id, string stuID, string IsCheckNeeded)
{
int Check = Convert.ToInt16(IsCheckNeeded);
Tigburim newTigbur = (new Tigburim()).getTigburById(id);
if (Check == 1)
{
List <Tigburim> tiglist = new List <Tigburim>();
tiglist.Add(newTigbur);
tiglist = newTigbur.checkIfSignedFunc(stuID, tiglist);
foreach (Tigburim t in tiglist)
{
newTigbur = t;
}
}
JavaScriptSerializer js = new JavaScriptSerializer();
// serialize to string
string jsonStringGetTurtering = js.Serialize(newTigbur);
return(jsonStringGetTurtering);
}
public string delSpecTig(string id, string date)
{
double manID = 9999; // manager id
double TeaId = 0;
string prof = null;
string hour = null;
string todayStr = DateTime.Now.ToString("yyyy-MM-dd");//today's date for insert
Request req = new Request();
Tigburim tig = new Tigburim();
List <Tigburim> tigList = new List <Tigburim>();
//getting student list and teacher id
tigList = tig.getStudentList4Messages(id, date);
DateTime tempDate = Convert.ToDateTime(date);
string trueDate = tempDate.ToString("dd-MM-yyyy");
//calling for messages to stu
foreach (Tigburim tigbur in tigList)
{
if (TeaId == 0)
{
TeaId = Convert.ToDouble(tigbur.TeacherId);
prof = tigbur.ProfName;
hour = Convert.ToString(tigbur.StartTime);
string[] splitStr = hour.Split(':');
hour = splitStr[0] + ":" + splitStr[1];
}
string content = "תלמיד יקר, שיעור " + tigbur.ProfName + " שחל בתאריך " + trueDate + " ובשעה " + hour + " בוטל.";
Messages mes = new Messages(manID, Convert.ToDouble(tigbur.StuId), "ביטול שיעור", content, false, todayStr);
int NumEffected = mes.InsertMessage();
if (NumEffected == 0)
{
return(null);
}
}
if (TeaId == 0)
{
Teacher t = new Teacher();
TeaId = (double)t.getTeacherId4delete(id);
}
//calling for messages to teacher
string mesToTeaContent = "מתגבר יקר, בוטל תגבור " + prof + " שחל בתאריך " + trueDate + " ובשעה " + hour + " , עמך הסליחה.";
Messages TeaMes = new Messages();
TeaMes.Msg_fromManagerId = manID;
TeaMes.Msg_toTeacherId = TeaId;
TeaMes.Msg_subject = "ביטול תגבור";
TeaMes.Msg_content = mesToTeaContent;
TeaMes.Msg_hasRead = false;
TeaMes.Msg_date = todayStr;
int numEffectedTeach = TeaMes.InsertMessageFromManagerToTeacher();
if (numEffectedTeach == 0)
{
return(null);
}
//updating status to 1 in AL table and deleting requests
int delSTL = tig.deleteSTL(id, date);
int delReq = req.deleteRequests(id, date);
int delTig = tig.delSpecTig(id, date);
if (delTig == 0)
{
return(null);
}
JavaScriptSerializer js = new JavaScriptSerializer();
// serialize to string
string jsonStringgetSchedule = js.Serialize(delTig);
return(jsonStringgetSchedule);
}
