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;
}
