private void OpenProjectClick(object sender, MouseButtonEventArgs e)
{
ModelSmallProject project = (sender as Grid).DataContext as ModelSmallProject;
Session.ProjektID = project.id;
Utilities.NavigateTo(grid, new ProjectDataSheet(grid, new Source.ViewModel.Project(project.id)));
}
protected void projectDelete(object sender, RoutedEventArgs e)
{
MenuItem delete = sender as MenuItem;
ModelSmallProject items = delete.DataContext as ModelSmallProject;
applicant.DeleteRecruitedProjectConnection(items.id, freelancerApplicant.id);
kapcsolodo_projekt_list.ItemsSource = applicant.Data_RecruitedProjectList();
}
protected void navigateToProjectDataSheet(object sender, RoutedEventArgs e)
{
Button button = sender as Button;
ModelSmallProject items = button.DataContext as ModelSmallProject;
Session.ProjektID = items.id;
Utilities.SetReturnPage(Utilities.Views.ApplicantDataSheet);
Utilities.NavigateTo(grid, new ProjectDataSheet(grid, new Project(items.id)));
}
protected void AddProjektClick(object sender, RoutedEventArgs e)
{
ComboBox cbx = projekt_cbx as ComboBox;
ModelSmallProject item = cbx.SelectedItem as ModelSmallProject;
if (item != null)
{
applicant.AddRecruitedToProject(item.id);
kapcsolodo_projekt_list.ItemsSource = applicant.Data_RecruitedProjectList();
}
}
public List <ModelSmallProject> Data_RecruitedProjectList(int id = 0) //javított
{
string command = "SELECT projektek.id, megnevezes_projekt FROM projektek " +
"INNER JOIN projekt_jelolt_kapcs_kulsos ON projektek.id = projekt_jelolt_kapcs_kulsos.projekt_id " +
"INNER JOIN jeloltek ON jeloltek.id = projekt_jelolt_kapcs_kulsos.jelolt_id " +
"WHERE jeloltek.id = " + (id.Equals(0) ? Session.ApplicantID : id) + " " +
"GROUP BY projektek.id";
List <ModelSmallProject> list = ModelSmallProject.GetModelSmallProject(command);
return(list);
}
public List <ModelSmallProject> Data_PorjectListSmall()
{
return(ModelSmallProject.GetModelSmallProject("SELECT projektek.id, megnevezes_projekt FROM projektek WHERE statusz = 1"));
}
