public PersonalRequest addPersonalRequest(PersonalRequest request)
{
Connection con = Connection.getConnection();
con.db.PersonalRequest.Add(request);
con.db.SaveChanges();
return(request);
}
private void submitBtn_Click(object sender, RoutedEventArgs e)
{
string requestIDStr = requestIDTxt.Text.Trim();
int requestID;
string reason = reasonTxt.Text.Trim();
bool success = int.TryParse(requestIDStr, out requestID);
if (!success)
{
errorLbl.Text = "RequestID must be a number";
}
else if (responseComboBox.SelectedItem == null || ((string)((ComboBoxItem)responseComboBox.SelectedValue).Content == "Decline" && reason == ""))
{
errorLbl.Text = "Please input all field!";
}
else
{
string response = (string)((ComboBoxItem)responseComboBox.SelectedValue).Content;
PersonalRequestMediator mediator = new PersonalRequestMediator();
PersonalRequest request = mediator.getPersonalRequest(requestID);
if (request == null)
{
errorLbl.Text = "Request doesn't exist!";
}
else
{
if (response == "Accept")
{
response += "ed";
}
else
{
response += "d";
}
request.status = response;
if (response == "Declined")
{
request.response = reason;
}
PersonalRequest r = mediator.updatePersonalRequest(requestID, request);
if (r == null)
{
MessageBox.Show("Request response failed");
}
else
{
MessageBox.Show("Request response success");
}
refresh();
}
}
}
public PersonalRequest updatePersonalRequest(int requestID, PersonalRequest request)
{
Connection con = Connection.getConnection();
PersonalRequest newRequest = con.db.PersonalRequest.Find(requestID);
newRequest = request;
con.db.SaveChanges();
return(newRequest);
}
public int getLastID()
{
Connection con = Connection.getConnection();
PersonalRequest request = (from r in con.db.PersonalRequest orderby r.requestID descending select r).FirstOrDefault();
if (request == null)
{
return(0);
}
return(request.requestID);
}
public Lesson(int eventCode, string eventDate, string startingHour, string endingHour, int price, string studentId, string teacherId, string title, string location, PersonalRequest request)
{
EventCode = eventCode;
EventDate = eventDate;
StartingHour = startingHour;
EndingHour = endingHour;
Price = price;
StudentId = studentId;
TeacherId = teacherId;
Title = title;
Location = location;
Request = request;
}
public static Lesson GetEvent(int eventId)
{
SqlParameter parameter = new SqlParameter("@eventId", eventId);
DataSet ds = db.GetDataSetByQuery("GetEvent", System.Data.CommandType.StoredProcedure, parameter);
DataRow dr = ds.Tables[0].Rows[0];
Lesson shiur = new Lesson();
shiur.EventCode = int.Parse(dr[0].ToString());
shiur.StudentId = dr[1].ToString();
shiur.TeacherId = dr[2].ToString();
shiur.Title = dr[3].ToString();
shiur.EventDate = dr[4].ToString();
shiur.StartingHour = dr[5].ToString();
shiur.EndingHour = dr[6].ToString();
shiur.Location = dr[7].ToString();
shiur.Status = (bool)dr[9];
PersonalRequest thisRequest;
int reqID = int.Parse(dr[8].ToString());
parameter = new SqlParameter("@reqID", reqID);
ds = db.GetDataSetByQuery("GetPersonalRequestForALesson", System.Data.CommandType.StoredProcedure, parameter);
if (ds.Tables[0].Rows.Count > 0)
{
string maker = (string)ds.Tables[0].Rows[0]["StudentID"];
string content = (string)ds.Tables[0].Rows[0]["RequestContent"];
string answer = (string)ds.Tables[0].Rows[0]["AnswerContent"];
bool done = false;
if ((bool)ds.Tables[0].Rows[0]["answered"])
{
done = true;
}
string date = (string)ds.Tables[0].Rows[0]["PostingDate"];
string hour = (string)ds.Tables[0].Rows[0]["PostingTime"];
thisRequest = new PersonalRequest(reqID, maker, content, answer, done, date, hour);
}
else
{
thisRequest = new PersonalRequest();
thisRequest.Content = "";
}
shiur.Request = thisRequest;
return(shiur);
}
public static PersonalRequest create(int employeeID, string title, string description,
string type)
{
PersonalRequest p = new PersonalRequest();
p.EmployeeID = employeeID;
p.Title = title;
p.Description = description;
p.Type = type;
p.Note = "";
p.Status = "Pending";
p.Date = DateTime.Now;
return(p);
}
public async Task <ActionResult <PersonalModel> > Post([FromBody] PersonalRequest request)
{
try
{
var model = await _manager.PostAsync(request);
if (model == null)
{
return(BadRequest());
}
return(model);
} catch (Exception ex)
{
return(BadRequest(ex));
}
}
public PersonalRequest createResignRequest(string title, string description)
{
PersonalRequestMediator mediator = new PersonalRequestMediator();
PersonalRequest request = new PersonalRequest();
request.requestID = mediator.getLastID() + 1;
request.departmentID = Session.session.employee.departmentID;
request.employeeID = Session.session.employee.employeeID;
request.title = title;
request.description = description;
request.type = "Resign";
request.response = "-";
request.status = "Pending";
return(request);
}
public async Task <ActionResult> Put(int id, [FromBody] PersonalRequest request)
{
try
{
var model = await _manager.GetByIdAsync(id);
if (model == null)
{
return(NotFound());
}
await _manager.Put(id, request);
return(NoContent());
}catch (Exception ex)
{
return(BadRequest(ex));
}
}
public async Task Put(int id, PersonalRequest request)
{
var model = await this.GetByIdAsync(id);
model.Id = id;
model.Name = request.Name;
model.LastName = request.LastName;
model.Identification = request.Identification;
if (request.Imageformat == null || request.ImageName == null || request.ProfileImage == null)
{
var img = await _repository.GetById(id);
model.ProfileImage = img.ProfileImage;
}
else
{
model.ProfileImage = _upload.UploadFile(request.ProfileImage, request.Imageformat, $"{request.Name}_{request.Identification}");
}
_repository.Put(model);
}
public static List <PersonalRequest> GetAllPersonalRequestsForATeacher(string teacherID, bool done)
{
List <PersonalRequest> requests = new List <PersonalRequest>();
SqlParameter[] parameters = new SqlParameter[2];
parameters[0] = new SqlParameter("@teacherID", teacherID);
parameters[1] = new SqlParameter("@done", done);
DataSet ds = db.GetDataSetByQuery("GetAllPersonalRequestsForATeacher", System.Data.CommandType.StoredProcedure, parameters);
foreach (DataRow dr in ds.Tables[0].Rows)
{
PersonalRequest req = new PersonalRequest();
req.RequestId = int.Parse(dr[0].ToString());
req.Content = dr[1].ToString();
req.Date = dr[2].ToString();
req.Hour = dr[3].ToString();
req.Answer = dr[4].ToString();
req.Done = (bool)dr[6];
req.Writer = Person.SearchForUserInDB(dr[5].ToString()) as Student;
SqlParameter parameter = new SqlParameter("@reqID", req.RequestId);
ds = db.GetDataSetByQuery("GetEventDetailesFromAPersonalRequest", System.Data.CommandType.StoredProcedure, parameter);
if (ds.Tables[0].Rows.Count > 0)
{
DataRow dr2 = ds.Tables[0].Rows[0];
req.LessonTiedTo = new Lesson();
req.LessonTiedTo.EventCode = int.Parse(dr2[0].ToString());
req.LessonTiedTo.EventDate = dr2[4].ToString();
}
requests.Add(req);
}
return(requests);
}
public async Task <PersonalModel> PostAsync(PersonalRequest request)
{
var model = new PersonalModel();
model.Name = request.Name;
model.LastName = request.LastName;
model.Identification = request.Identification;
if (request.ImageName == "")
{
model.ProfileImage = "";
}
else
{
model.ProfileImage = _upload.UploadFile(request.ProfileImage, request.Imageformat, $"{request.ImageName}_{request.Identification}");
}
if (model.ProfileImage == null)
{
return(null);
}
return(await _repository.PostAsync(model));
}
public void add(int employeeID, string title, string description, string type)
{
PersonalRequest p = PersonalRequestFactory.create(employeeID, title, description, type);
PersonalRequestRepository.add(p);
}
public void DeleteLastPersonalRequest()
{
PersonalRequest.DeleteLastPersonalRequest();
}
public int InsertPersonalRequest(string studentId, string teacherId, string content)
{
return(PersonalRequest.InsertPersonalRequest(studentId, teacherId, content));
}
public void AnswerPersonalRequest(int reqID, string content)
{
PersonalRequest.AnswerPersonalRequest(reqID, content);
}
public string GetAllPersonalRequestsForAStudent(string studentID, bool done)
{
JavaScriptSerializer j = new JavaScriptSerializer();
return(j.Serialize(PersonalRequest.GetAllPersonalRequestsForAStudent(studentID, done)));
}
public string GetAllPersonalRequestsForATeacher(string teacherID, bool done)
{
JavaScriptSerializer j = new JavaScriptSerializer();
return(j.Serialize(PersonalRequest.GetAllPersonalRequestsForATeacher(teacherID, done)));
}
public static void add(PersonalRequest p)
{
db.PersonalRequests.Add(p);
db.SaveChanges();
}
public PersonalRequest addPersonalRequest(PersonalRequest request)
{
PersonalRequestRepository repository = new PersonalRequestRepository();
return(repository.addPersonalRequest(request));
}
public PersonalRequest updatePersonalRequest(int requestID, PersonalRequest request)
{
PersonalRequestRepository repository = new PersonalRequestRepository();
return(repository.updatePersonalRequest(requestID, request));
}
public static List <Lesson> GetAllEventsForATeacher(string teacherid)
{
List <Lesson> lessonList = new List <Lesson>();
SqlParameter parameter = new SqlParameter("@teacherId", teacherid);
DataSet ds = db.GetDataSetByQuery("GetAllEventsForATeacher", System.Data.CommandType.StoredProcedure, parameter);
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
Lesson shiur = new Lesson();
shiur.EventCode = int.Parse(dr[0].ToString());
shiur.StudentId = dr[1].ToString();
shiur.TeacherId = dr[2].ToString();
shiur.Title = dr[3].ToString();
shiur.EventDate = dr[4].ToString();
shiur.StartingHour = dr[5].ToString();
shiur.EndingHour = dr[6].ToString();
shiur.Location = dr[7].ToString();
shiur.Status = (bool)dr[9];
PersonalRequest thisRequest;
int reqID = int.Parse(dr[8].ToString());
parameter = new SqlParameter("@reqID", reqID);
DataSet requests = db.GetDataSetByQuery("GetPersonalRequestForALesson", System.Data.CommandType.StoredProcedure, parameter);
if (requests.Tables[0].Rows.Count > 0)
{
string maker = (string)requests.Tables[0].Rows[0]["StudentID"];
string content = (string)requests.Tables[0].Rows[0]["RequestContent"];
string answer = (string)requests.Tables[0].Rows[0]["AnswerContent"];
bool done = false;
if ((bool)requests.Tables[0].Rows[0]["answered"])
{
done = true;
}
string date = (string)requests.Tables[0].Rows[0]["PostingDate"];
string hour = (string)requests.Tables[0].Rows[0]["PostingTime"];
thisRequest = new PersonalRequest(reqID, maker, content, answer, done, date, hour);
}
else
{
thisRequest = new PersonalRequest();
}
shiur.Request = thisRequest;
lessonList.Add(shiur);
}
}
//personal teacher events
if (ds.Tables.Count > 1 && ds.Tables[1].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[1].Rows)
{
Lesson shiur = new Lesson();
shiur.EventCode = int.Parse(dr[0].ToString());
shiur.TeacherId = dr[1].ToString();
shiur.Title = dr[2].ToString();
shiur.EventDate = dr[3].ToString();
shiur.StartingHour = dr[4].ToString();
shiur.EndingHour = dr[5].ToString();
shiur.StudentId = "";
lessonList.Add(shiur);
}
}
return(lessonList);
}
