public string InsertRequestTeacher(string id, string date, string teaId, string status, string sub_date, string reason)
{
int reqStat = Convert.ToInt32(status);
double TeaID = Convert.ToDouble(teaId);
int lesId = Convert.ToInt32(id);
DateTime trueDate = Convert.ToDateTime(date);
DateTime reqTrueDate = Convert.ToDateTime(sub_date);
teachersRequests teaReq = new teachersRequests(lesId, trueDate, TeaID, reqStat, reqTrueDate, reason);
int isReq = teaReq.CheckRequestCAL();
if (isReq > 0)
{
return(null);
}
int numEffected = teaReq.InsertTeacherRequest();
JavaScriptSerializer js = new JavaScriptSerializer();
// serialize to string
if (numEffected == 0)
{
return(null);
}
string jsonStringGetTurtering = js.Serialize(numEffected);
return(jsonStringGetTurtering);
}
protected void LinkButton1_Command_cancelrequest(object sender, EventArgs e)
{
GridViewRow gvRow = (GridViewRow)(sender as Control).Parent.Parent;
Teacher t = (Teacher)(Session["teaUserSession"]);
double reqTeaId = t.Tea_id;
int lesID = Convert.ToInt32(gvRow.Cells[1].Text);
DateTime LesDate = Convert.ToDateTime(gvRow.Cells[3].Text);
try
{
teachersRequests req = new teachersRequests();
int numEffected = req.deleteTeacherRequest(reqTeaId, lesID, LesDate);
}
catch (Exception ex)
{
Response.Write("There was an error " + ex.Message);
}
Server.TransferRequest(Request.Url.AbsolutePath, false);
}
protected void btnSend_Click(object sender, EventArgs e)
{
double teaID = (double)(Session["TeaId"]);
int lessNumber = Convert.ToInt32(Session["selectedLessonNum"]);
DateTime lessDate = Convert.ToDateTime(Session["LessonDate"]);
DateTime reqDate = Convert.ToDateTime(Session["requestDate"]);
int reqStatus = 2;
string reqReason = txtReason.Text;
int flg = 0;
teachersRequests teaReq;
DataTable dt = this.GetRequests();
foreach (DataRow dr in dt.Rows)
{
DateTime dat = (DateTime)(dr["TeaReq__LessDate"]);
int lesNum = Convert.ToInt32(dr["TeaReq__LessId"]);
double ReqTeaID = Convert.ToDouble(dr["TeaReq_TeaId"]);
if (dat == lessDate && lesNum == lessNumber && ReqTeaID == teaID)
{
flg = 1;
}
}
if (flg == 0)
{
try
{
teaReq = new teachersRequests(lessNumber, lessDate, teaID, reqStatus, reqDate, reqReason);
int numEffected = teaReq.InsertTeacherRequest();
}
catch (Exception ex)
{
Response.Write("There was an error " + ex.Message);
}
}
Server.TransferRequest(Request.Url.AbsolutePath, false);
}
protected void ApproveButton_Click(object sender, EventArgs e)
{
teachersRequests req = new teachersRequests();
GridViewRow gvRow = (GridViewRow)(sender as Control).Parent.Parent;
int index = gvRow.RowIndex;
int req_num = Convert.ToInt32(gvRow.Cells[1].Text);
int status = 1;
int cancelled = 1;
ActualLesson acl = new ActualLesson();
SignedToLesson stl = new SignedToLesson();
int lesId = Convert.ToInt32(gvRow.Cells[2].Text);
DateTime tmpDate = Convert.ToDateTime(gvRow.Cells[3].Text);
string lesDate = tmpDate.ToString("yyyy-MM-dd");
Request stuReq = new Request();
string proff = gvRow.Cells[4].Text;
string start = gvRow.Cells[6].Text;
Session["cancelledLesId"] = lesId;
Session["cancelledLesDate"] = lesDate;
string lesDateMES = tmpDate.ToString("dd-MM-yyyy");
Manager m = (Manager)(Session["manUserSession"]);
double manID = m.Man_id;
DataTable dt = this.GetStudents();
string currnetDate = DateTime.Now.ToString("yyyy-MM-dd");
Messages mes;
DataTable teaIDtable = this.GetTeaId();
double teaID = Convert.ToDouble(teaIDtable.Rows[0]["Les_Tea_Id"]);
string mesToTeaContent = "מתגבר יקר, בקשתך לביטול שיעור " + proff + " שחל בתאריך " + lesDateMES + " ובשעה " + start + " אושרה והתגבור בוטל.";
// Messages TeaMes = new Messages(manID, teaID, "ביטול שיעור", mesToTeaContent, false, currnetDate);
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 = currnetDate;
int numEffected1 = TeaMes.InsertMessageFromManagerToTeacher();
string mesContent = "תלמיד יקר, שיעור " + proff + " שחל בתאריך " + lesDateMES + " ובשעה " + start + " בוטל.";
foreach (DataRow dr in dt.Rows)
{
double stuID = Convert.ToDouble(dr["StLes_stuId"]);
mes = new Messages(manID, stuID, "ביטול שיעור", mesContent, false, currnetDate);
int NumEffected = mes.InsertMessage();
}
try
{
int numEffected = req.updateSpecificTeacherRequest(req_num, status);
int numEffected2 = acl.cancelSpecificActualLesson(lesId, lesDate, cancelled);
int numEffected3 = stl.deleteStudentsFromLesson(lesId, lesDate);
int numEffected4 = stuReq.deleteCancelldLessonRequests(lesId, lesDate);
Server.TransferRequest(Request.Url.AbsolutePath, false);
}
catch (Exception ex)
{
Response.Write("illegal values to the SignedToLesson attributes - error message is " + ex.Message);
return;
}
}
