protected void applicantArchivateClick(object sender, RoutedEventArgs e) { MessageBoxResult result = MessageBox.Show("Biztosan megváltoztatod? \n\n", "HR Cloud", MessageBoxButton.YesNoCancel); switch (result) { case MessageBoxResult.Yes: ModelApplicantList items = (sender as MenuItem).DataContext as ModelApplicantList; selectedApplicant = new Applicant(items.id).data; if (selectedApplicant.statusz == 1) { Cimke_Grid.Visibility = Visibility.Visible; cimke_related_list.ItemsSource = new ModelCimkek().GetRelated(selectedApplicant.id); cimke_title.Text = "Cimkék (" + selectedApplicant.nev + ")"; } else { Utility.applicantArchiver(selectedApplicant.id, selectedApplicant.statusz); applicantListLoader(); } break; case MessageBoxResult.No: break; case MessageBoxResult.Cancel: break; } }
private void Remove_from_favorit_Click(object sender, RoutedEventArgs e) { ModelApplicantList applicant = (sender as MenuItem).DataContext as ModelApplicantList; Applicant.DeleteFromFavorite(applicant.id); LoadLists(); }
//protected void jeloltTabClick(object sender, RoutedEventArgs e) //{ // kapcs_jeloltek_listBox.Visibility = System.Windows.Visibility.Visible; // kapcs_ertesitendo_listBox.Visibility = System.Windows.Visibility.Hidden; // jeloltek_addbtn.Visibility = System.Windows.Visibility.Visible; // ertesitendok_addbtn.Visibility = System.Windows.Visibility.Hidden; //} //protected void ertesitendokTabClick(object sender, RoutedEventArgs e) //{ // kapcs_jeloltek_listBox.Visibility = System.Windows.Visibility.Hidden; // kapcs_ertesitendo_listBox.Visibility = System.Windows.Visibility.Visible; // ertesitendok_addbtn.Visibility = System.Windows.Visibility.Visible; // jeloltek_addbtn.Visibility = System.Windows.Visibility.Hidden; //} protected void jeloltDeleteClick(object sender, MouseButtonEventArgs e) { Image delete = sender as Image; ModelApplicantList items = delete.DataContext as ModelApplicantList; project.jeloltKapcsDelete(items.id); kapcs_jeloltek_listBox.ItemsSource = util.Data_JeloltKapcs(); }
protected void modositasClick(object sender, RoutedEventArgs e) { MenuItem item = sender as MenuItem; ModelApplicantList itemSource = item.DataContext as ModelApplicantList; Session.isUpdate = true; Session.ApplicantID = itemSource.id; Session.ApplicantSearchValue = GetSearchValues(); Utilities.NavigateTo(grid, new NewApplicantPanel(grid, new Applicant(itemSource.id))); }
public List <ModelApplicantList> Data_JeloltKapcs() { string command = "SELECT coalesce((SELECT count(projekt_id) FROM interview " + "WHERE jelolt_id = jeloltek.id AND projekt_id = " + Session.ProjektID + " Group by projekt_id),0) as interjuk_db, " + "coalesce((SELECT count(projekt_id) FROM projekt_jelolt_kapcs WHERE projekt_jelolt_kapcs.jelolt_id = jeloltek.id),0) as project_db, " + "jeloltek.id,nev,jeloltek.szuldatum,megnevezes_munka,email,reg_date,kepesseg1,kepesseg2,kepesseg3,kepesseg4,kepesseg5, " + "jeloltek.munkakor, jeloltek.munkakor2, jeloltek.munkakor3, allapota,jeloltek.statusz, jeloltek.friss, jeloltek.kategoria, jeloltek.megjegyzes, (SELECT EXISTS(SELECT * FROM projekt_jelolt_kapcs WHERE projekt_jelolt_kapcs.jelolt_id = jeloltek.id)) as allasban " + "FROM jeloltek INNER JOIN projekt_jelolt_kapcs ON jeloltek.id = projekt_jelolt_kapcs.jelolt_id " + "LEFT JOIN projektek ON projektek.id = projekt_jelolt_kapcs.projekt_id " + "LEFT JOIN munkakor ON jeloltek.munkakor = munkakor.id WHERE projektek.id =" + Session.ProjektID + " GROUP BY jeloltek.id "; return(ModelApplicantList.GetModelApplicantList(command)); }
protected void gridMouseDown(object sender, MouseButtonEventArgs e) { Grid grid = sender as Grid; ModelApplicantList item = grid.DataContext as ModelApplicantList; if (item.checkbox == false) { item.checkbox = true; } else { item.checkbox = false; } kapcs_jeloltek_listBox.Items.Refresh(); }
public static List <ModelApplicantList> Data_FavoriteApplicants() { string command = "SELECT coalesce((SELECT count(projekt_id) FROM interview " + "WHERE jelolt_id = jeloltek.id Group by projekt_id),0) as interjuk_db, " + "coalesce((SELECT count(projekt_id) FROM projekt_jelolt_kapcs WHERE projekt_jelolt_kapcs.jelolt_id = jeloltek.id),0) as project_db, " + "jeloltek.id,nev,jeloltek.szuldatum,megnevezes_munka,email,reg_date,kepesseg1,kepesseg2,kepesseg3,kepesseg4,kepesseg5, " + "jeloltek.munkakor, jeloltek.munkakor2, jeloltek.munkakor3, allapota,kategoria,jeloltek.statusz, jeloltek.friss, jeloltek.profession_type, jeloltek.megjegyzes, (SELECT EXISTS(SELECT * FROM projekt_jelolt_kapcs WHERE projekt_jelolt_kapcs.jelolt_id = jeloltek.id)) as allasban " + "FROM jeloltek LEFT JOIN projekt_jelolt_kapcs ON jeloltek.id = projekt_jelolt_kapcs.jelolt_id " + "LEFT JOIN projektek ON projektek.id = projekt_jelolt_kapcs.projekt_id " + "LEFT JOIN munkakor ON jeloltek.munkakor = munkakor.id " + "LEFT JOIN jelolt_megfigyelt ON jeloltek.id = jelolt_megfigyelt.jelolt_id WHERE jelolt_megfigyelt.user_id = " + Session.UserData.id + " GROUP BY jeloltek.id ORDER BY jelolt_megfigyelt.date"; List <ModelApplicantList> list = ModelApplicantList.GetModelApplicantList(command); return(list); }
protected void openApplicantClick(object sender, RoutedEventArgs e) { Button button = sender as Button; ModelApplicantList items = button.DataContext as ModelApplicantList; Session.ApplicantID = items.id; if (items.allapota >= 1) { Session.TelefonSzurt = 1; } else { Session.TelefonSzurt = 0; } Utilities.NavigateTo(grid, new ProjektJeloltDataSheet(grid, new Project(0), new Applicant(items.id))); }
protected void jeloltRightClick(object sender, RoutedEventArgs e) { Email email = new Email(); MenuItem mitem = sender as MenuItem; ModelApplicantList items = mitem.DataContext as ModelApplicantList; switch (mitem.Tag.ToString()) { case "delete": { MessageBoxResult result = MessageBox.Show("Elutasító E-Mail kiküldésre kerüljön?", "My App", MessageBoxButton.YesNoCancel); switch (result) { case MessageBoxResult.Yes: project.jeloltKapcsDelete(items.id); new Email().Send(items.email, emailTemplate.Elutasito_Email(items.nev)); break; case MessageBoxResult.No: project.jeloltKapcsDelete(items.id); break; case MessageBoxResult.Cancel: break; } break; } case "1": project.jeloltKapcsUpdate(items.id, Convert.ToInt32(mitem.Tag)); break; case "2": project.jeloltKapcsUpdate(items.id, Convert.ToInt32(mitem.Tag)); break; case "3": project.jeloltKapcsUpdate(items.id, Convert.ToInt32(mitem.Tag)); new Email().Send(items.email, emailTemplate.Elutasito_Email(items.nev)); break; } listLoader(); formLoader(); }
protected void applicantDeleteClick(object sender, RoutedEventArgs e) { MessageBoxResult result = MessageBox.Show("Biztosan törölni szeretnéd? \n", "HR Cloud", MessageBoxButton.YesNoCancel); switch (result) { case MessageBoxResult.Yes: MenuItem menuItem = sender as MenuItem; ModelApplicantList items = menuItem.DataContext as ModelApplicantList; Applicant.DeleteApplicant(items.id); Files.DeleteFolder(items.id); applicantListLoader(); break; case MessageBoxResult.No: break; case MessageBoxResult.Cancel: break; } }
protected void applicantOpenClick(object sender, RoutedEventArgs e) { Button button = sender as Button; ModelApplicantList items = button.DataContext as ModelApplicantList; Session.ApplicantID = items.id; if (items.frissValue) { MessageBoxResult result = MessageBox.Show("Üdvözlő üzenet küldése? \n", "HR Cloud", MessageBoxButton.YesNo); switch (result) { case MessageBoxResult.Yes: Applicant.FirstOpen(items.id); break; case MessageBoxResult.No: break; } } Utilities.SetReturnPage(Utilities.Views.FavoritePanel); Utilities.NavigateTo(grid, new ApplicantDataSheet(grid, new Applicant(items.id))); }
public static List <ModelApplicantList> GetApplicantList(ModelApplicantSearchBar sw) { double listNo = (sw.numberLimit != 0 ? sw.numberLimit : 10); string command = "SELECT coalesce((SELECT count(projekt_id) FROM interview WHERE jelolt_id = jeloltek.id GROUP BY jelolt_id),0) as interjuk_db, " + "coalesce((SELECT count(projekt_id) FROM projekt_jelolt_kapcs WHERE projekt_jelolt_kapcs.jelolt_id = jeloltek.id),0) as project_db, " + "(SELECT megnevezes_munka FROM munkakor WHERE munkakor.id = jeloltek.munkakor) as munkakor, " + "(SELECT megnevezes_munka FROM munkakor WHERE munkakor.id = jeloltek.munkakor2) as munkakor2, " + "(SELECT megnevezes_munka FROM munkakor WHERE munkakor.id = jeloltek.munkakor3) as munkakor3, " + "jeloltek.id,jeloltek.nev,szuldatum,reg_date,allapota,jeloltek.statusz,jeloltek.megjegyzes,email,friss,kategoria, " + "(SELECT EXISTS(SELECT * FROM projekt_jelolt_kapcs WHERE projekt_jelolt_kapcs.jelolt_id = jeloltek.id)) as allasban " + "FROM jeloltek " + "LEFT JOIN megjegyzesek ON jeloltek.id = megjegyzesek.jelolt_id " + "LEFT JOIN munkakor on jeloltek.munkakor = munkakor.id " + "LEFT JOIN jelolt_cimke_kapcs on jelolt_cimke_kapcs.jelolt_id = jeloltek.id " + "LEFT JOIN jelolt_cimkek on jelolt_cimkek.id = jelolt_cimke_kapcs.cimke_id " + "LEFT JOIN projekt_jelolt_kapcs ON jeloltek.id = projekt_jelolt_kapcs.jelolt_id " + "WHERE jeloltek.id LIKE '%%' AND jeloltek.ervenyes = 1 AND jeloltek.statusz =" + Session.ApplicantStatusz; if (sw.nev != "") { command += " AND jeloltek.nev LIKE '%" + sw.nev + "%' "; } if (sw.lakhely != "") { command += " AND jeloltek.lakhely LIKE '%" + sw.lakhely + "%' "; } if (sw.email != "") { command += " AND jeloltek.email LIKE '%" + sw.email + "%' "; } if (sw.eletkor != "") { command += " AND jeloltek.szuldatum <= " + sw.eletkor + " "; } //if (searchValue[0].tapasztalat != "" && searchValue[0].tapasztalat != "0") //{ // command += "AND jeloltek.tapasztalat_ev >= " + searchValue[0].tapasztalat + " "; //} if (sw.regdate != "") { command += " AND jeloltek.reg_date LIKE '%" + sw.regdate + "%' "; } if (sw.interjuk != "" && sw.interjuk != "0") { command += " AND coalesce((SELECT count(projekt_id) FROM interview WHERE jelolt_id = jeloltek.id Group by projekt_id),0) >= " + sw.interjuk + " "; } if (sw.nemekStr != "") { command += " AND jeloltek.neme LIKE '%" + sw.nemekStr + "%' "; } if (sw.munkakorStr != "") { command += " AND jeloltek.munkakor LIKE '%" + sw.munkakorStr + "%' "; } if (sw.vegzettsegStr != "") { command += " AND jeloltek.vegz_terulet LIKE '%" + sw.vegzettsegStr + "%' "; } if (sw.cimke != "") { command += " AND jelolt_cimkek.cimke_megnevezes LIKE '%" + sw.cimke + "%' "; } if (sw.cimke != "") { command += " OR megjegyzesek.megjegyzes LIKE '%" + sw.cimke + "%' "; } if (sw.szabad == "1") { command += " AND projekt_jelolt_kapcs.id IS NULL "; } if (sw.allasbanBool) { command += " AND projekt_jelolt_kapcs.id IS NOT NULL "; } command += " GROUP BY jeloltek.id "; switch (sw.HeaderSelected) { case "1": command += " ORDER BY jeloltek.nev" + sw.sorrend; break; case "2": command += " ORDER BY jeloltek.statusz" + sw.sorrend; break; case "3": command += " ORDER BY jeloltek.reg_date" + sw.sorrend; break; default: command += " ORDER BY jeloltek.reg_date DESC, friss DESC"; break; } command += " LIMIT " + listNo + " OFFSET " + Session.ApplicantSearchPage * listNo + ""; return(ModelApplicantList.GetModelApplicantList(command)); }
private void MegfigyeltekhezAd(object sender, RoutedEventArgs e) { ModelApplicantList applicant = (sender as MenuItem).DataContext as ModelApplicantList; Applicant.AddToFavorite(applicant.id); }
private void VisszautasitIdeiglenes(object sender, RoutedEventArgs e) { ModelApplicantList applicant = (sender as MenuItem).DataContext as ModelApplicantList; new Email().Send(applicant.email, new EmailTemplate().NincsPozicioElutasito(applicant.nev)); }