public void AddHochschule(int Land_ID) { config = XmlDataManager.XmlConfigDataReader("configs.xml"); string query = "insert into tab_hochschule ([txtName],[intLand],[Hochschulestadt])" + " values ('" + NameTextBox.Text.Trim() + "','" + Land_ID + "','" + Stadt_CB.Text.Trim() + "')"; OleDbConnection UserConnection = new OleDbConnection(); UserConnection.ConnectionString = config.DbConnectionString; OleDbCommand cmd = new OleDbCommand { CommandType = CommandType.Text, CommandText = query, Connection = UserConnection }; UserConnection.Open(); try { cmd.ExecuteNonQuery(); MessageBox.Show("Data Saved Successful"); UserConnection.Close(); } catch (Exception ex) { MessageBox.Show("Error " + ex); } }
// Function to add UserData in the database public void AddBetreuer(string Vorname, string Name, string Email, int Titel, string Telefonnummer) { config = XmlDataManager.XmlConfigDataReader("configs.xml"); string query = "insert into tab_betreuer ([txtVorname],[txtName],[txtMail],[intTitel],[txtTelefon]) " + "values ('" + Vorname + "','" + Name + "','" + Email + "','" + Titel + "','" + Telefonnummer + "')"; OleDbConnection UserConnection = new OleDbConnection(); UserConnection.ConnectionString = config.DbConnectionString; OleDbCommand cmd = new OleDbCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = query; cmd.Connection = UserConnection; UserConnection.Open(); try { cmd.ExecuteNonQuery(); MessageBox.Show("Data Saved Successful"); UserConnection.Close(); } catch (Exception ex) { MessageBox.Show("Error " + ex); } }
//function to search a title's id public int Search_Title_ID(string titel) { config = XmlDataManager.XmlConfigDataReader("configs.xml"); string query = "SELECT ID FROM tab_titel where txtTitel = '" + titel + "' "; OleDbConnection UserConnection1 = new OleDbConnection { ConnectionString = config.DbConnectionString }; UserConnection1.Open(); OleDbCommand cmd1 = new OleDbCommand { Connection = UserConnection1, CommandType = CommandType.Text, CommandText = query }; OleDbDataReader reader = cmd1.ExecuteReader(); if (reader.HasRows) { reader.Read(); string resultat = reader["ID"].ToString(); int id = Convert.ToInt32(resultat); UserConnection1.Close(); return(id); } else { UserConnection1.Close(); return(0); } }
// Anzeige der nformationen des Betreuer public void ShowBetreuerInfo(DataGridView grid) { try { /*t.txtTitel AS Titel, tab_titel AS t, WHERE t.ID = b.intTitel */ config = XmlDataManager.XmlConfigDataReader("configs.xml"); string query = "SELECT b.ID AS BetreuerID, t.txtTitel AS Titel, b.txtVorname AS Vorname, b.txtName AS Name, b.txtMail AS AdresseMail, b.txtTelefon AS Telefonnumer " + "FROM tab_titel AS t, tab_betreuer AS b WHERE t.ID = b.intTitel"; OleDbConnection UserConnection = new OleDbConnection(); UserConnection.ConnectionString = config.DbConnectionString; UserConnection.Open(); OleDbCommand cmd = new OleDbCommand(); cmd.Connection = UserConnection; cmd.CommandText = query; OleDbDataAdapter da = new OleDbDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); grid.DataSource = dt; UserConnection.Close(); } catch (Exception ex) { MessageBox.Show("Error " + ex); } }
// Function to remove Betreuer from the tab_betreuer public void RemoveUser(int id) { config = XmlDataManager.XmlConfigDataReader("configs.xml"); string query = "delete from tab_betreuer where ID = " + id + ""; OleDbConnection UserConnection = new OleDbConnection(); UserConnection.ConnectionString = config.DbConnectionString; OleDbCommand cmd = new OleDbCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = query; cmd.Connection = UserConnection; UserConnection.Open(); try { cmd.ExecuteNonQuery(); MessageBox.Show("Data Removed Successful"); UserConnection.Close(); } catch (Exception ex) { MessageBox.Show("Error " + ex); } }
public void Show_Database(DataGridView grid, int ID) { try { config = XmlDataManager.XmlConfigDataReader("configs.xml"); string query = "SELECT t.intBewerbung AS BewerbungsID, t.datDatum AS Datum, t.txtBenutzer AS Benutzer, t.Masterstudiengang_1, t.Masterstudiengang_2, t.Masterstudiengang_3 FROM tab_status AS t WHERE t.intBewerbung = " + ID + " "; OleDbConnection UserConnection = new OleDbConnection(); UserConnection.ConnectionString = config.DbConnectionString; UserConnection.Open(); OleDbCommand cmd = new OleDbCommand(); cmd.Connection = UserConnection; cmd.CommandText = query; OleDbDataAdapter da = new OleDbDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); grid.DataSource = dt; UserConnection.Close(); } catch (Exception ex) { MessageBox.Show("Error " + ex); } }
// Search the connected user public bool Search_User_Online_To_Disconect(UserData userdat) { config = XmlDataManager.XmlConfigDataReader("configs.xml"); int count = 0; OleDbConnection LoginConnection = new OleDbConnection(); LoginConnection.ConnectionString = config.DbConnectionString; LoginConnection.Open(); OleDbCommand cmd = new OleDbCommand(); cmd.Connection = LoginConnection; cmd.CommandText = "SELECT * FROM tab_User where Username = '******' "; OleDbDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { count++; } LoginConnection.Close(); // Test if the given username exists in the database if (count == 1) { return(true); } else { return(false); } }
// return the nationality ID public string Search_Nationalitaet(int nationalitaetID) { config = XmlDataManager.XmlConfigDataReader("configs.xml"); string query = "SELECT Nationalitaet FROM tab_land where ID = " + nationalitaetID + ""; OleDbConnection UserConnection1 = new OleDbConnection(); UserConnection1.ConnectionString = config.DbConnectionString; UserConnection1.Open(); OleDbCommand cmd1 = new OleDbCommand(); cmd1.Connection = UserConnection1; cmd1.CommandType = CommandType.Text; cmd1.CommandText = query; OleDbDataReader reader = cmd1.ExecuteReader(); if (reader.HasRows) { reader.Read(); string resultat = reader["txtNationalität"].ToString(); UserConnection1.Close(); return(resultat); } else { UserConnection1.Close(); return(null); } }
public void AddSemester() { config = XmlDataManager.XmlConfigDataReader("configs.xml"); string query = "insert into tab_semester ([txtSemester])" + " values ('" + SemesterTextBox.Text.Trim() + "')"; OleDbConnection UserConnection = new OleDbConnection(); UserConnection.ConnectionString = config.DbConnectionString; OleDbCommand cmd = new OleDbCommand { CommandType = CommandType.Text, CommandText = query, Connection = UserConnection }; UserConnection.Open(); try { cmd.ExecuteNonQuery(); MessageBox.Show("Data Saved Successful"); UserConnection.Close(); } catch (Exception ex) { MessageBox.Show("Error " + ex); } }
//Load Hochschule in MasterStudiengangComboBox private void Load_Master_Studiengang_Database() { config = XmlDataManager.XmlConfigDataReader("configs.xml"); string query = "SELECT txtName FROM tab_masterstudiengang"; OleDbConnection UserConnection1 = new OleDbConnection { ConnectionString = config.DbConnectionString }; UserConnection1.Open(); OleDbCommand cmd1 = new OleDbCommand { Connection = UserConnection1, CommandType = CommandType.Text, CommandText = query }; OleDbDataReader reader = cmd1.ExecuteReader(); while (reader.Read()) { string sName = reader["txtName"].ToString(); MasterstudiengangCB.Items.Add(sName); MasterstudiengangCB2.Items.Add(sName); MasterstudiengangCB3.Items.Add(sName); } UserConnection1.Close(); }
// function to search a Semester_ID in database private int Search_ID_Smester(string Semester) { config = XmlDataManager.XmlConfigDataReader("configs.xml"); string query = "SELECT Id FROM tab_semester where txtSemester = '" + Semester + "'"; OleDbConnection UserConnection1 = new OleDbConnection(); UserConnection1.ConnectionString = config.DbConnectionString; UserConnection1.Open(); OleDbCommand cmd1 = new OleDbCommand(); cmd1.Connection = UserConnection1; cmd1.CommandType = CommandType.Text; cmd1.CommandText = query; OleDbDataReader reader = cmd1.ExecuteReader(); if (reader.HasRows) { reader.Read(); string resultat = reader["ID"].ToString(); UserConnection1.Close(); int id = Convert.ToInt32(resultat); return(id); } else { UserConnection1.Close(); return(0); } }
//Load Nationalität in NationalitätComboBox private void Load_Nationalitaet_Database() { config = XmlDataManager.XmlConfigDataReader("configs.xml"); string query = "SELECT txtNationalität FROM tab_land"; OleDbConnection UserConnection1 = new OleDbConnection { ConnectionString = config.DbConnectionString }; UserConnection1.Open(); OleDbCommand cmd1 = new OleDbCommand { Connection = UserConnection1, CommandType = CommandType.Text, CommandText = query }; OleDbDataReader reader = cmd1.ExecuteReader(); while (reader.Read()) { string sName = reader["txtNationalität"].ToString(); NationalitaetCB.Items.Add(sName); } UserConnection1.Close(); }
private void Load_Hochschule_Database() { config = XmlDataManager.XmlConfigDataReader("configs.xml"); string query = "SELECT txtName FROM tab_hochschule"; OleDbConnection UserConnection1 = new OleDbConnection { ConnectionString = config.DbConnectionString }; UserConnection1.Open(); OleDbCommand cmd1 = new OleDbCommand { Connection = UserConnection1, CommandType = CommandType.Text, CommandText = query }; OleDbDataReader reader = cmd1.ExecuteReader(); while (reader.Read()) { string sName = reader["txtName"].ToString(); HochschuleComboBox.Items.Add(sName); } }
// fill the ComboBox Titel with Database private void Load_Titel_Database() { config = XmlDataManager.XmlConfigDataReader("configs.xml"); string query = "SELECT txtTitel FROM tab_titel"; OleDbConnection UserConnection1 = new OleDbConnection { ConnectionString = config.DbConnectionString }; UserConnection1.Open(); OleDbCommand cmd1 = new OleDbCommand { Connection = UserConnection1, CommandType = CommandType.Text, CommandText = query }; OleDbDataReader reader = cmd1.ExecuteReader(); while (reader.Read()) { string Titel = reader["txtTitel"].ToString(); TitelComboBox.Items.Add(Titel); } UserConnection1.Close(); }
public bool Check_Benutzer_Data(UserData userdat) { int count = 0; config = XmlDataManager.XmlConfigDataReader("configs.xml"); OleDbConnection LoginConnection = new OleDbConnection(); LoginConnection.ConnectionString = config.DbConnectionString; LoginConnection.Open(); OleDbCommand cmd = new OleDbCommand(); cmd.Connection = LoginConnection; cmd.CommandText = "SELECT * FROM tab_User where Username = '******' and Password = '******' and Attribut = '" + userdat.UserAttribut + "' "; OleDbDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { count++; } LoginConnection.Close(); // Test if the given username exists in the database if (count == 1) { return(true); } else { return(false); } }
public bool RemoveBewerbung(int id) { bool resp = false; config = XmlDataManager.XmlConfigDataReader("configs.xml"); string query = "delete from tab_bewerbung where ID = " + id + ""; OleDbConnection UserConnection = new OleDbConnection(); UserConnection.ConnectionString = config.DbConnectionString; OleDbCommand cmd = new OleDbCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = query; cmd.Connection = UserConnection; UserConnection.Open(); try { cmd.ExecuteNonQuery(); UserConnection.Close(); resp = true; } catch (Exception ex) { MessageBox.Show("Error " + ex); } return(resp); }
public int Search_Land_ID(string LandName) { config = XmlDataManager.XmlConfigDataReader("configs.xml"); string query = "SELECT ID FROM tab_land where txtName = '" + LandName + "' "; OleDbConnection LandConnection1 = new OleDbConnection(); LandConnection1.ConnectionString = config.DbConnectionString; LandConnection1.Open(); OleDbCommand cmd1 = new OleDbCommand { Connection = LandConnection1, CommandType = CommandType.Text, CommandText = query }; OleDbDataReader reader = cmd1.ExecuteReader(); if (reader.HasRows) { reader.Read(); string resultat = reader["ID"].ToString(); int id = Convert.ToInt32(resultat); LandConnection1.Close(); return(id); } else { LandConnection1.Close(); return(0); } }
// Anzeige der Informationen des Studenten public void ShowStudentenInfo(DataGridView grid, int BewerbungsID) { try { /*t.txtTitel AS Titel, tab_titel AS t, WHERE t.ID = b.intTitel */ config = XmlDataManager.XmlConfigDataReader("configs.xml"); string query1 = "SELECT t.intBewerbung AS BewerbungsID, t.Masterstudiengang_1 AS Masterstudiengang_1, t.Masterstudiengang_2 AS Masterstudiengang_2, t.Masterstudiengang_3 AS Masterstudiengang_3, t.datDatum AS Datum, t.txtBenutzer AS txtBenutzer" + "FROM tab_status AS t WHERE t.intBewerbung = " + BewerbungsID + ""; string query = "SELECT intBewerbung AS BewerbungID, Masterstudiengang_1 AS Masterstudiengang1, Masterstudiengang_2 AS Masterstudiengang2, Masterstudiengang_3 AS Masterstudiengang3, datDatum AS Datum, txtBenutzer AS Benutzer " + "FROM tab_status AS t WHERE t.intBewerbung = " + BewerbungsID + ""; OleDbConnection UserConnection = new OleDbConnection(); UserConnection.ConnectionString = config.DbConnectionString; UserConnection.Open(); OleDbCommand cmd = new OleDbCommand(); cmd.Connection = UserConnection; cmd.CommandText = query; OleDbDataAdapter da = new OleDbDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); grid.DataSource = dt; UserConnection.Close(); } catch (Exception ex) { MessageBox.Show("Error " + ex); } }
// Function to einstufen public void Einstufen(int bewerbungid, string benutzer, string masterstudiengang, string masterstudiengang2, string masterstudiengang3) { config = XmlDataManager.XmlConfigDataReader("configs.xml"); string query = "insert into tab_status ([intBewerbung],[datDatum],[txtBenutzer],[Masterstudiengang_1],[Masterstudiengang_2],[Masterstudiengang_3]) values ('" + bewerbungid + "','" + DateTime.Now + "','" + benutzer + "','" + masterstudiengang + "','" + masterstudiengang2 + "', '" + masterstudiengang3 + "')"; OleDbConnection UserConnection = new OleDbConnection(); UserConnection.ConnectionString = config.DbConnectionString; OleDbCommand cmd = new OleDbCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = query; cmd.Connection = UserConnection; UserConnection.Open(); try { cmd.ExecuteNonQuery(); UserConnection.Close(); } catch (Exception ex) { MessageBox.Show("Error " + ex); } }
// function to search a Semester in database public string Search_ID_Smester(int SemesterID) { config = XmlDataManager.XmlConfigDataReader("configs.xml"); string query = "SELECT txtSemester FROM tab_semester where Id = " + SemesterID + ""; OleDbConnection UserConnection1 = new OleDbConnection(); UserConnection1.ConnectionString = config.DbConnectionString; UserConnection1.Open(); OleDbCommand cmd1 = new OleDbCommand(); cmd1.Connection = UserConnection1; cmd1.CommandType = CommandType.Text; cmd1.CommandText = query; OleDbDataReader reader = cmd1.ExecuteReader(); if (reader.HasRows) { reader.Read(); string resultat = reader["txtSemester"].ToString(); UserConnection1.Close(); return(resultat); } else { UserConnection1.Close(); return(null); } }
private String ExportDocx(string masterStudiengang, int fileIndex) { config = XmlDataManager.XmlConfigDataReader("configs.xml"); WordDocCreator Docx = new WordDocCreator(@Path.GetDirectoryName(Application.ExecutablePath).Trim() + "\\bci.docx"); Docx.FindAndReplace("<name>", bewerbungsdata.Name.Trim()); Docx.FindAndReplace("<vorname>", bewerbungsdata.Vorname.Trim()); Docx.FindAndReplace("<nationalitaet>", bewerbungsdata.Nationalitaet.Trim()); Docx.FindAndReplace("<studiengang>", bewerbungsdata.Studiengang.Trim()); Docx.FindAndReplace("<hochschule>", bewerbungsdata.Hochschule.Trim()); Docx.FindAndReplace("<note>", bewerbungsdata.Note.Trim()); Docx.FindAndReplace("<erworbenecp>", bewerbungsdata.Creditpunkte.Trim()); Docx.FindAndReplace("<masterstudiengang>", masterStudiengang.Trim()); Docx.FindAndReplace("<ablehnungsgrund>", bewerbungsdata.Ablehnungsgrund.Trim()); Docx.FindAndReplace("<kommentar>", bewerbungsdata.Comment.Trim()); Docx.FindAndReplace("<date>", DateTime.Now.ToShortDateString()); string filename = "\\" + bewerbungsdata.Name.Trim() + bewerbungsdata.Vorname.Trim() + fileIndex.ToString().Trim() + ".docx"; string filepath = config.SaveDocxPath.Trim() + filename.Trim(); Docx.CreateDocx(filepath); return(filepath); }
// Check if the BewerbungIDin tab_fehltcp exist public bool Search_BewerbungID_in_tab_FehlCP(int bewerbungsID) { config = XmlDataManager.XmlConfigDataReader("configs.xml"); int count = 0; OleDbConnection LoginConnection = new OleDbConnection(); LoginConnection.ConnectionString = config.DbConnectionString; LoginConnection.Open(); OleDbCommand cmd = new OleDbCommand(); cmd.Connection = LoginConnection; cmd.CommandText = "SELECT intBewerbung FROM tab_fehlcp where intBewerbung = " + bewerbungsID + " "; OleDbDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { count++; } LoginConnection.Close(); // Test if the given username exists in the database if (count != 0) { return(true); } else { return(false); } }
// return the studiengang ID public int Search_StudiengangID(string studiengang) { config = XmlDataManager.XmlConfigDataReader("configs.xml"); string query = "SELECT ID FROM tab_studiengang where txtName = '" + studiengang + "'"; OleDbConnection UserConnection1 = new OleDbConnection(); UserConnection1.ConnectionString = config.DbConnectionString; UserConnection1.Open(); OleDbCommand cmd1 = new OleDbCommand(); cmd1.Connection = UserConnection1; cmd1.CommandType = CommandType.Text; cmd1.CommandText = query; OleDbDataReader reader = cmd1.ExecuteReader(); if (reader.HasRows) { reader.Read(); string resultat = reader["ID"].ToString(); UserConnection1.Close(); int id = Convert.ToInt32(resultat); return(id); } else { UserConnection1.Close(); return(0); } }
private void Show_Database() { try { config = XmlDataManager.XmlConfigDataReader("configs.xml"); OleDbConnection UserConnection = new OleDbConnection(); UserConnection.ConnectionString = config.DbConnectionString; UserConnection.Open(); OleDbCommand cmd = new OleDbCommand(); cmd.Connection = UserConnection; cmd.CommandText = "SELECT tab_studiengang.ID AS ID , tab_studiengang.txtName AS Studiengang , tab_hochschule.txtName AS Hochschule, tab_studiengang.intRegelstudienzeit AS Regelstudienzeit," + " tab_studiengang.intCredits AS Credit,tab_titel.txtTitel AS Titel, tab_studiengang.blnCPErsatz AS CPErsatz " + "FROM tab_studiengang, tab_hochschule, tab_titel " + "WHERE tab_studiengang.intHochschule = tab_hochschule.ID AND tab_studiengang.intTitel = tab_titel.ID ORDER BY tab_studiengang.ID "; OleDbDataAdapter da = new OleDbDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); StudiengangGridView.DataSource = dt; UserConnection.Close(); } catch (Exception ex) { MessageBox.Show("Error " + ex); } }
private void SettingsUI_Load(object sender, EventArgs e) { if (File.Exists("configs.xml")) { config = XmlDataManager.XmlConfigDataReader("configs.xml"); DbPathTexbox.Text = config.DatabasePath; DocxPathTB.Text = config.SaveDocxPath; } }
private void Add_Hochschule_Load(object sender, EventArgs e) { if (File.Exists("configs.xml")) { config = XmlDataManager.XmlConfigDataReader("configs.xml"); } else { MessageBox.Show("no config xml file!"); } }
private void NewStudentUI_Load(object sender, EventArgs e) { if (File.Exists("configs.xml")) { config = XmlDataManager.XmlConfigDataReader("configs.xml"); } else { MessageBox.Show("config file not found!"); } }
private void StudiengangUI_Load(object sender, EventArgs e) { if (File.Exists("configs.xml")) { config = XmlDataManager.XmlConfigDataReader("configs.xml"); } else { MessageBox.Show("no config xml file!"); } Show_Database(); }
// Function to add FehlendeCp in the database public void AddFehlendeCP(int bewerbungid, int IntCPdelta, int FehlCP, int Studiengang, int valueOfErfuellt) { // check if the username already exist and return his value Boolean response = Search_BewerbungID_in_tab_FehlCP(bewerbungid, Studiengang, IntCPdelta); if (response == false) { config = XmlDataManager.XmlConfigDataReader("configs.xml"); string query = "insert into tab_fehlcp ([intCPdelta],[intWert],[intBewerbung],[intStudiengang],[blnErfüllt]) values ('" + IntCPdelta + "','" + FehlCP + "','" + bewerbungid + "','" + Studiengang + "','" + valueOfErfuellt + "')"; OleDbConnection UserConnection = new OleDbConnection(); UserConnection.ConnectionString = config.DbConnectionString; OleDbCommand cmd = new OleDbCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = query; cmd.Connection = UserConnection; UserConnection.Open(); try { cmd.ExecuteNonQuery(); UserConnection.Close(); } catch (Exception ex) { MessageBox.Show("Error " + ex); } } else { config = XmlDataManager.XmlConfigDataReader("configs.xml"); string query = "Update tab_fehlcp set [intWert] = '" + FehlCP + "', [blnErfüllt] = '" + valueOfErfuellt + "' where intCPdelta = " + IntCPdelta + " and intBewerbung = " + bewerbungid + " and intStudiengang = " + Studiengang + " "; OleDbConnection UserConnection = new OleDbConnection(); UserConnection.ConnectionString = config.DbConnectionString; OleDbCommand cmd = new OleDbCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = query; cmd.Connection = UserConnection; UserConnection.Open(); try { cmd.ExecuteNonQuery(); UserConnection.Close(); } catch (Exception ex) { MessageBox.Show("Error " + ex); } } }
// Noten Suchen public FehlendeCPInfo ShowFehlendeCI(string MastStudiengang, int Deltacp) { int bewerbungsID = ShowMasterstudiengangID(MastStudiengang); FehlendeCPInfo fehlendeCPInfo = new FehlendeCPInfo(); fehlendeCPInfo.IntCPdelta = 1; config = XmlDataManager.XmlConfigDataReader("configs.xml"); string query = "SELECT t.intCPdelta, t.intWert, t.intBewerbung, t.blnErfüllt FROM tab_fehlcp AS t WHERE t.intBewerbung = " + bewerbungsID + " AND t.intCPdelta = " + Deltacp + ""; OleDbConnection UserConnection1 = new OleDbConnection(); UserConnection1.ConnectionString = config.DbConnectionString; UserConnection1.Open(); OleDbCommand cmd1 = new OleDbCommand(); cmd1.Connection = UserConnection1; cmd1.CommandType = CommandType.Text; cmd1.CommandText = query; OleDbDataReader reader = cmd1.ExecuteReader(); if (reader.HasRows) { reader.Read(); string intCPDelta = reader["intCPdelta"].ToString(); string fehlCP = reader["intWert"].ToString(); string intBewerbung = reader["intBewerbung"].ToString(); string erfuelle = reader["blnErfüllt"].ToString(); UserConnection1.Close(); int IntCPDelta = Convert.ToInt32(intCPDelta); int FehlCP = Convert.ToInt32(fehlCP); int IntBewerbung = Convert.ToInt32(intBewerbung); bool Erfuelle = Convert.ToBoolean(erfuelle); fehlendeCPInfo.IntCPdelta = IntCPDelta; fehlendeCPInfo.FehlCP = FehlCP; fehlendeCPInfo.IntBewerbungID = IntBewerbung; fehlendeCPInfo.Erfuelle = Erfuelle; return(fehlendeCPInfo); } else { return(fehlendeCPInfo); } }