private void Accept__Click(object sender, RoutedEventArgs e)
{
if (Pending1.SelectedItem == null)
{
label3.Content = "Select an Item";
}
string item2 = Pending1.SelectedItem.ToString();
char[] delimiterChars = { ' ' };
var i = item2.Split(delimiterChars);
string id = i.FirstOrDefault();
TutoringDB.TutorCourse temp3 = new TutorCourse();
TutoringDB.TutorConfirmationRequest temp4 = new TutorConfirmationRequest();
foreach (var tt in db.TutorConfirmationRequests.Local)
{
if (tt.TutorId.ToString() == id)
{
temp4 = tt;
temp3.TutorId = tt.TutorId;
temp3.CourseId = tt.CourseId;
}
}
db.TutorCourses.Add(temp3);
db.TutorConfirmationRequests.Remove(temp4);
db.SaveChanges();
Refresh1();
}
//[Authorize(Roles = "Admin")]
public IHttpActionResult Put(TutorCourse tutorCourse)
{
if (TutorCourseDAO.Update(tutorCourse))
{
return(Ok());
}
return(BadRequest());
}
public static TutorCourse Insert(TutorCourse tutorCourse)
{
using (SqlConnection connection = DataBase.GetConnection())
{
connection.Open();
SqlCommand command = new SqlCommand(INSERT, connection);
command.Parameters.AddWithValue("@idTutor", tutorCourse.IdTutor);
command.Parameters.AddWithValue("@idCourse", tutorCourse.IdCourse);
int id = (int)command.ExecuteScalar();
tutorCourse.IdCourse = id;
}
return(tutorCourse);
}
private void Remove_Click(object sender, RoutedEventArgs e)
{
TutoringDB.TutorCourse temp3 = new TutorCourse();
TutoringDB.Cours tempc2 = new Cours();
TutoringDB.Tutor tt = new Tutor();
db.Tutors.Load();
db.Courses.Load();
db.TutorCourses.Load();
string item;
item = CurrentTutors.SelectedItem.ToString();
char[] delimiterChars = { ' ' };
var i = item.Split(delimiterChars);
string fn = i.ElementAt(0).ToString();
string ln = i.ElementAt(1).ToString();
foreach (var c in db.Tutors)
{
if (fn == c.FirstName && ln == c.LastName)
{
tt = c;
foreach (var l in db.Courses)
{
if (l.CourseName == Courses.SelectedItem.ToString())
{
tempc2 = l;
}
}
}
}
temp3.Cours = tempc2;
temp3.CourseId = tempc2.Id;
temp3.Tutor = tt;
temp3.TutorId = tt.Id;
foreach (var x in db.TutorCourses)
{
if (temp3.Cours == x.Cours && temp3.Tutor == x.Tutor)
{
temp3 = x;
}
}
db.TutorCourses.Remove(temp3);
db.SaveChanges();
refresh2();
}
public static bool Update(TutorCourse tutorCourse)
{
bool state = false;
using (SqlConnection connection = DataBase.GetConnection())
{
connection.Open();
SqlCommand command = new SqlCommand(UPDATE, connection);
command.Parameters.AddWithValue("@idCourse", tutorCourse.IdCourse);
command.Parameters.AddWithValue("@idTutor", tutorCourse.IdTutor);
command.Parameters.AddWithValue("@id", tutorCourse.Id);
state = command.ExecuteNonQuery() != 0;
}
return(state);
}
public static TutorCourse Get(int id)
{
TutorCourse tutorCourse = null;
using (SqlConnection connection = DataBase.GetConnection())
{
connection.Open();
SqlCommand command = new SqlCommand(GET, connection);
command.Parameters.AddWithValue("@id", id);
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
tutorCourse = new TutorCourse(reader);
}
}
return(tutorCourse);
}
private void Apply_Click(object sender, RoutedEventArgs e)
{
db.Tutors.Load();
db.Tutees.Load();
db.Courses.Load();
db.TutorCourses.Load();
string item2;
item2 = PotentialTutors.SelectedItem.ToString();
char[] delimiterChars = { ' ' };
var i = item2.Split(delimiterChars);
string fn = i.ElementAt(0);
string ln = i.ElementAt(1);
TutoringDB.TutorCourse temp3 = new TutorCourse();
TutoringDB.Cours tempc2 = new Cours();
foreach (var c in db.Tutors) //Doesn't work for tutees
{
if (fn == c.FirstName && ln == c.LastName)
{
TutoringDB.Tutor tt = new Tutor();
tt = c;
temp3.Tutor = tt;
foreach (var l in db.Courses)
{
if (l.CourseName == Courses.SelectedItem as string)
{
tempc2 = l;
}
}
}
}
if (temp3.Tutor != null)
{
temp3.CourseId = tempc2.Id;
db.TutorCourses.Add(temp3);
db.SaveChanges();
refresh2();
return;
}
TutoringDB.Tutee temp = new TutoringDB.Tutee();
foreach (var d in db.Tutees)
{
if (fn == d.FirstName && ln == d.LastName)
{
temp = d;
}
}
TutoringDB.Tutor temp2 = new TutoringDB.Tutor();
temp2.FirstName = temp.FirstName;
temp2.LastName = temp.LastName;
temp2.Password = temp.Password;
temp2.UserName = temp.Username;
temp2.Year = temp.Year;
temp2.Email = temp.Email;
//temp2.Id = db.Tutors.Count();
db.Tutors.Add(temp2);
//db.Tutees.Remove(temp);
db.SaveChanges();
TutoringDB.Cours tempc = new Cours();
foreach (var l in db.Courses)
{
if (l.CourseName == Courses.SelectedItem.ToString())
{
tempc = l;
}
}
TutoringDB.TutorCourse temp4 = new TutorCourse();
temp4.Cours = tempc;
temp4.Tutor = temp2;
db.TutorCourses.Add(temp4);
db.SaveChanges();
refresh2();
}
//[Authorize(Roles ="Tutor")]
public TutorCourse Post(TutorCourse tutorCourse)
{
return(TutorCourseDAO.Insert(tutorCourse));
}
