public void AddEmployee(Employee employee) { String sql = "INSERT into MITARBEITER(NAME,VORNAME,BERUF) VALUES ('" + employee.LastName + "','" + employee.FirstName + "','" + employee.Profession + "')"; FbCommand com = new FbCommand(sql, conn); FbDataReader dr = com.ExecuteReader(); dr.Read(); dr.Close(); }
public void AddEmployee(Employee employee) { if (_employees.Count > 0) { int highestId = _employees[_employees.Count - 1].Id; employee.Id = highestId + 1; } else { employee.Id = 1; } _employees.Add(employee); }
//Werden Mitarbeiter anders gespeichert/ausgelesen? Ich bekomme keinen Fehler aber auch keine Daten. private void addMitarbeiter() { Console.WriteLine("Bitte geben sie den Familiennamen des Mitarbeiters an:"); var name = Console.ReadLine(); Console.WriteLine("Bitte geben sie den Vornamen des Mitarbeiters an:"); var firstname = Console.ReadLine(); Console.WriteLine("Bitte geben sie den Beruf des Mitarbeiters an."); var profession = Console.ReadLine(); var Eemployee = new Employee(); Eemployee.LastName = name; Eemployee.FirstName = firstname; Eemployee.Profession = profession; fachkonzept.AddEmployee(Eemployee); }
public void AddEmployee(Employee employee) { //XML DataTable dt = new DataTable(); dt.TableName = "Mitarbeiter"; DataColumn p_mitarbeiter_id = new DataColumn("P_MITARBEITER_ID"); DataColumn name = new DataColumn("NAME"); DataColumn vorname = new DataColumn("VORNAME"); DataColumn beruf = new DataColumn("BERUF"); dt.Columns.Add(p_mitarbeiter_id); dt.Columns.Add(name); dt.Columns.Add(vorname); dt.Columns.Add(beruf); /*TextBox müssen noch angepasst werden */ dt.Rows.Add(TextBox.Text, TextBox.Text, TextBox.Text, TextBox.Text); DataSet ds = new DataSet(); ds.Tables.Add(dt); ds.WriteXml("ASProjekt.xml"); }
public MockStorage() { Employee marioSuper = new Employee("Super", "Mario"); marioSuper.Profession = "Klempner"; AddEmployee(marioSuper); Employee gordenFreeman = new Employee("Freeman", "Gorden"); gordenFreeman.Profession = "Physiker"; AddEmployee(gordenFreeman); Project BER = new Project(); BER.Location = "Berlin"; BER.Title = "Flughafen Berlin Brandenbug"; BER.Start = "1157457600"; BER.End = "1504612800"; AddProject(BER); Worklog foo = new Worklog(); foo.EmployeeId = 1; foo.ProjectId = 1; foo.Start = "1448276947"; foo.End = "1448301924"; AddWorklog(foo); }
public void CreateEmployee(Employee employee) { throw new NotImplementedException(); }
public void UpdateEmployee(Employee employee) { _storage.UpdateEmployee(employee); }
public void AddEmployee(Employee employee) { _storage.AddEmployee(employee); }
public void UpdateEmployee(Employee employee) { //XML DataTable dt = new DataTable(); dt.TableName = "Mitarbeiter"; DataColumn p_mitarbeiter_id = new DataColumn("P_MITARBEITER_ID"); DataColumn name = new DataColumn("NAME"); DataColumn vorname = new DataColumn("VORNAME"); DataColumn beruf = new DataColumn("BERUF"); /*TextBox müssen noch angepasst werden */ /*Rows Dynamisch* anpassen*/ dt.Rows.Add(TextBox.Text, TextBox.Text, TextBox.Text, TextBox.Text); dt.Rows[][p_mitarbeiter_id] = TextBox.Text; dt.Rows[][name] = TextBox.Text; dt.Rows[][vorname] = TextBox.Text; dt.Rows[][beruf] = TextBox.Text; DataSet ds = new DataSet(); ds.Tables.Add(dt); ds.WriteXml("ASProjekt.xml"); }
public void UpdateEmployee(Employee updatedEmployee) { Employee employee = _employees.FirstOrDefault(o => o.Id == updatedEmployee.Id); if (employee != null) { employee = updatedEmployee; } else { throw new ArgumentException("Employee not found in storage."); } }
public void UpdateEmployee(Employee employee) { BusinessLogic.UpdateEmployee(employee); }
public void AddEmployee(Employee employee) { BusinessLogic.AddEmployee(employee); }
protected int CompareEmployeeByLastName(Employee employee1, Employee employee2) { return String.Compare(employee1.LastName, employee2.LastName, StringComparison.CurrentCulture); }
public void UpdateEmployee(Employee employee) { { //Firebird /* FbConnection conn = new FbConnection(connString); conn.Open(); String sql = "UPDATE MITARBEITER SET ('P_MITARBEITER_ID' = '@P_MITARBEITER_ID' , 'NAME' = '@NAME' , 'VORNAME' = '@VORNAME' , 'BERUF' = '@BERUF')"; FbCommand com = new FbCommand(sql, conn); com.Parameters.Add("@P_MITARBEITER_ID", TextBox.Text); com.Parameters.Add("@NAME", TextBox.Text); com.Parameters.Add("@VORNAME", TextBox.Text); com.Parameters.Add("@BERUF", TextBox.Text); com.ExecuteNonQuery(); FbDataReader dr = com.ExecuteReader(); while (dr.Read()) { Console.WriteLine(dr.GetString(0)); } dr.Close(); conn.Close(); Console.ReadLine(); */ } }
public List<Employee> GetEmployees() { String sql = "SELECT * FROM MITARBEITER"; FbCommand com = new FbCommand(sql, conn); FbDataReader dr = com.ExecuteReader(); List<Employee> resultsList = new List<Employee>(); while (dr.Read()) { int id = dr.GetInt32(0); string lastName = dr.GetString(1); string firstName = dr.GetString(2); string profession = dr.GetString(3); Employee employee = new Employee(lastName, firstName) { Profession = profession, Id = id }; resultsList.Add(employee); } dr.Close(); return resultsList; }