protected void deleteInterview(object sender, RoutedEventArgs e)
{
MenuItem menu = sender as MenuItem;
ModelInterview items = menu.DataContext as ModelInterview;
new Interview().interviewDelete(items.id);
projectFormLoader();
}
protected void navigateToInterviewPanel(object sender, RoutedEventArgs e)
{
Button btn = sender as Button;
ModelInterview items = btn.DataContext as ModelInterview;
Session.InterViewID = items.id;
Utilities.SetReturnPage(Utilities.Views.FavoritePanel);
Utilities.NavigateTo(grid, new InterviewPanel(grid, new Project(items.projekt_id), new Applicant(items.jelolt_id)));
}
public static List <ModelInterview> Data_SzakmaiInterview()
{
string command = "SELECT interview.id, megnevezes_projekt, interview.projekt_id, interview.jelolt_id, jeloltek.nev,date_start,time_start,time_end,interju_cim,helyszin, sent FROM interju_resztvevo_kapcs INNER JOIN interview ON interju_resztvevo_kapcs.interju_id = interview.id " +
" INNER JOIN projektek ON interview.projekt_id = projektek.id" +
" INNER JOIN jeloltek ON interview.jelolt_id = jeloltek.id" +
" WHERE interju_resztvevo_kapcs.user_id = " + Session.UserData.id + " ORDER BY date_start";
List <ModelInterview> list = ModelInterview.GetSzakmaiInterview(command);
return(list);
}
private void interjuOpenClick(object sender, RoutedEventArgs e)
{
Button btn = sender as Button;
ModelInterview item = btn.DataContext as ModelInterview;
Session.InterViewID = item.id;
Session.ProjektID = item.projekt_id;
Utilities.SetReturnPage(Utilities.Views.ApplicantDataSheet);
Utilities.NavigateTo(grid, new InterviewPanel(grid, new Project(item.projekt_id), new Applicant(item.jelolt_id)));
}
public static List <ModelInterview> Data_InterviewById() //javított
{
string command = "SELECT interview.id,megnevezes_projekt,jeloltek.nev,interview.projekt_id,interview.jelolt_id,jeloltek.email,interview.hr_id,felvitel_datum,date_start,interju_cim,interju_leiras,helyszin, sent, time_end ,time_start FROM interview" +
" INNER JOIN projektek ON interview.projekt_id = projektek.id" +
" INNER JOIN jeloltek ON interview.jelolt_id = jeloltek.id" +
" WHERE interview.id = " + Session.InterViewID + "" +
" ORDER BY felvitel_datum";
List <ModelInterview> list = ModelInterview.GetModelInterview(command);
return(list);
}
public List <ModelInterview> Data_MyPastInterviews() //javított
{
string command = "SELECT interview.id,megnevezes_projekt,jeloltek.nev,interview.projekt_id,interview.jelolt_id,jeloltek.email,interview.hr_id,felvitel_datum,date_start,interju_cim,interju_leiras,helyszin, sent, time_end,time_start FROM interview " +
"INNER JOIN projektek ON interview.projekt_id = projektek.id " +
"INNER JOIN jeloltek ON interview.jelolt_id = jeloltek.id " +
"LEFT JOIN interju_resztvevo_kapcs ON interview.id = interju_resztvevo_kapcs.interju_id " +
"WHERE interju_resztvevo_kapcs.user_id = " + Session.UserData.id + " AND date_start < '" + date.Year + "." + Utilities.DateCorrect(date.Month) + "." + Utilities.DateCorrect(date.Day) + ".' ORDER BY date_start DESC";
List <ModelInterview> list = ModelInterview.GetModelInterview(command);
return(list);
}
protected void Szakmai_interju_open_Click(object sender, RoutedEventArgs e)
{
Button button = sender as Button;
ModelInterview items = button.DataContext as ModelInterview;
Session.InterViewID = items.id;
Session.ProjektID = items.projekt_id;
Session.ApplicantID = items.jelolt_id;
grid.Children.Clear();
grid.Children.Add(interviewPanel = new InterviewPanel(grid, new Project(items.projekt_id), new Applicant(items.jelolt_id)));
}
public InterviewPanel(Grid grid, Project project, Applicant applicant)
{
this.grid = grid;
this.project = project;
this.applicant = applicant;
this.interview = Interview.Data_InterviewById()[0];
InitializeComponent();
interviewLoader();
SendButtonStatus(interview.sent);
if (Session.UserData.kategoria < 1)
{
addPerson.Visibility = Visibility.Hidden;
invitePerson.Visibility = Visibility.Hidden;
}
}
public AppointmentModel TransformData(ModelInterview data)
{
AppointmentModel appdata = new AppointmentModel();
appdata = new AppointmentModel()
{
interview = data,
Id = data.id,
Subject = data.interju_cim,
Body = data.interju_leiras,
Start = data.date_start,
Time_start = data.time_start,
Time_end = data.time_end,
Location = data.helyszin,
Attendees = GetAttendees(data.id)
};
return(appdata);
}
