public void AddProject(Project project) { if (_projects.Count > 0) { int highestId = _projects[_projects.Count - 1].Id; project.Id = highestId + 1; } else { project.Id = 1; } _projects.Add(project); }
public void AddProject(Project project) { String sql = "INSERT into PROJEKTE(BEZEICHNUNG,VON,BIS,ORT) VALUES ('" + project.Title + "' , '" + project.Start + "' , '" + project.End + "' , '" + project.Location + "')"; FbCommand com = new FbCommand(sql, conn); FbDataReader dr = com.ExecuteReader(); dr.Read(); dr.Close(); }
private void addProjekte() { Console.WriteLine("Bitte geben sie den Ort des Projektes an: "); var ort = Console.ReadLine(); Console.WriteLine("Bitte geben sie die Bezeichnung des Projektes an: "); var title = Console.ReadLine(); Console.WriteLine("Bitte geben sie Projektstart an: "); var start = Console.ReadLine(); Console.WriteLine("Bitte geben sie Projektende an: "); var ende = Console.ReadLine(); var Pprojekte = new Project(); Pprojekte.Location = ort; Pprojekte.Title = title; Pprojekte.Start = start; Pprojekte.End = ende; fachkonzept.AddProject(Pprojekte); }
public void AddProject(Project project) { //XML DataTable dt = new DataTable(); dt.TableName = "Project"; DataColumn p_id_projekt = new DataColumn("P_PROJEKT_ID"); DataColumn bezeichnung = new DataColumn("BEZEICHNUNG"); DataColumn von = new DataColumn("VON"); DataColumn bis = new DataColumn("BIS"); DataColumn ort = new DataColumn("ORT"); dt.Columns.Add(p_id_projekt); dt.Columns.Add(bezeichnung); dt.Columns.Add(von); dt.Columns.Add(bis); dt.Columns.Add(ort); /*TextBox müssen noch angepasst werden */ dt.Rows.Add(TextBox.Text, 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 AddProject(Project project) { throw new NotImplementedException(); }
public void UpdateProject(Project project) { _storage.UpdateProject(project); }
public void AddProject(Project project) { _storage.AddProject(project); }
public void UpdateProject(Project project) { //XML DataTable dt = new DataTable(); dt.TableName = "Project"; DataColumn p_id_projekt = new DataColumn("P_PROJEKT_ID"); DataColumn bezeichnung = new DataColumn("BEZEICHNUNG"); DataColumn von = new DataColumn("VON"); DataColumn bis = new DataColumn("BIS"); DataColumn ort = new DataColumn("ORT"); /*TextBox müssen noch angepasst werden */ /*Rows Dynamisch* anpassen*/ dt.Rows.Add(TextBox.Text, TextBox.Text, TextBox.Text, TextBox.Text, TextBox.Text); dt.Rows[][p_id_projekt] = TextBox.Text; dt.Rows[][bezeichnung] = TextBox.Text; dt.Rows[][von] = TextBox.Text; dt.Rows[][bis] = TextBox.Text; dt.Rows[][ort] = TextBox.Text; DataSet ds = new DataSet(); ds.Tables.Add(dt); ds.WriteXml("ASProjekt.xml"); }
public void UpdateProject(Project updatedProject) { Project project = _projects.FirstOrDefault(o => o.Id == updatedProject.Id); if (project != null) { project = updatedProject; } else { throw new ArgumentException("Project not found in storage."); } }
public void UpdateProject(Project project) { BusinessLogic.UpdateProject(project); }
public void AddProject(Project project) { BusinessLogic.AddProject(project); }
protected int CompareProjectsByLocation(Project project1, Project project2) { return String.Compare(project1.Location, project2.Location, StringComparison.CurrentCulture); }
public void UpdateProject(Project project) { /* FbConnection conn = new FbConnection(connString); conn.Open(); String sql = "UPDATE Projekt SET ('P_PROJEKT_ID' = '@P_PROJEKT_ID' , 'BEZEICHNUNG' = '@BEZEICHNUNG' , 'VON' = '@VON' , 'BIS' = '@BIS' , 'ORT' = '@ORT')"; FbCommand com = new FbCommand(sql, conn); com.Parameters.Add("@P_PROJEKT_ID", TextBox.Text); com.Parameters.Add("@BEZEICHNUNG", TextBox.Text); com.Parameters.Add("@VON", TextBox.Text); com.Parameters.Add("@BIS", TextBox.Text); com.Parameters.Add("@ORT", TextBox.Text); com.ExecuteNonQuery(); FbDataReader dr = com.ExecuteReader(); while (dr.Read()) { Console.WriteLine(dr.GetString(0)); } dr.Close(); conn.Close(); Console.ReadLine(); */ }
public List<Project> GetProjects() { String sql = "SELECT * FROM PROJEKTE"; FbCommand com = new FbCommand(sql, conn); FbDataReader dr = com.ExecuteReader(); List<Project> resultsList = new List<Project>(); while (dr.Read()) { int id = dr.GetInt32(0); string title = dr.GetString(1); string start = dr.GetString(2); string end = dr.GetString(3); string location = dr.GetString(4); Project project = new Project { Id = id, Title = title, Start = start, End = end, Location = location }; resultsList.Add(project); } dr.Close(); return resultsList; }