public Task(string name, string details, string project)
{
_guru = new DatabaseGuru(Paths.PROJECTS_SAVE);
_name = name;
_details = details;
_project = project;
}//Task()
void _validateButton_MouseDown(object sender, System.Windows.Input.MouseButtonEventArgs e)
{
Console.WriteLine("In validate button MouseDown");
DatabaseGuru guru = new DatabaseGuru( Paths.PROJECTS_SAVE);
Console.WriteLine("Projects save is : " + Paths.PROJECTS_SAVE);
guru._propUpdater.UpdateProject(_block.Text, DatabaseValues.NAME, _nameBox.Text);
Console.WriteLine("_block.Text = " + _block.Text + "\n DatabaseValues.NAME : " + DatabaseValues.NAME + "\n_nameBox.Text : " + _nameBox.Text);
this.Close();
}
public bool IsProjectExisting(string newProject)
{
DatabaseGuru guru = new DatabaseGuru(Paths.PROJECTS_SAVE);
List<string> projects = guru._propSelector.SelectProjects();
foreach (var item in projects)
{
if (newProject.Trim().ToLower().Replace(" ", String.Empty) == item.Trim().ToLower().Replace(" ", String.Empty))
return true;
}
return false;
}
public Project(string name)
{
_name = name;
_guru = new DatabaseGuru(Paths.PROJECTS_SAVE);
//_name = _guru._propSelector.SelectSingleByEquality(DatabaseValues.NAME, DatabaseValues.PROJECT, DatabaseValues.NAME, "AFK");
//_id = Convert.ToUInt16(_guru._propSelector.SelectSingleByEquality(DatabaseValues.ID, DatabaseValues.PROJECT, DatabaseValues.NAME, _name));
//_startDate = _guru._propSelector.SelectSingleByEquality(DatabaseValues.STARTDATE, DatabaseValues.PROJECT, DatabaseValues.NAME, name);
//_endDate = _guru._propSelector.SelectSingleByEquality(DatabaseValues.ENDDATE, DatabaseValues.PROJECT, DatabaseValues.NAME, name);
//_formations = _guru._propSelector.SelectMultipleByEqualityWithProject(DatabaseValues.NAME,DatabaseValues.TASK,DatabaseValues.TYPE,ModelConstants.FORMATION,_id);
//_tasks = _guru._propSelector.SelectMultipleByEqualityWithProject(DatabaseValues.NAME, DatabaseValues.TASK, DatabaseValues.TYPE, ModelConstants.TASK,_id);
//_maintenances = _guru._propSelector.SelectMultipleByEqualityWithProject(DatabaseValues.NAME, DatabaseValues.TASK, DatabaseValues.TYPE, ModelConstants.MAINTENANCE,_id);
}//Project()
public MainWindow()
{
InitializeComponent();
TryColors();
DatabaseGuru guru = new DatabaseGuru(Paths.PROJECTS_SAVE);
//Test insert
guru._propInserter.InsertProject("ARK mod", DateTime.Now.ToString("DD:MM:YYYY"), DateTime.Now.ToString("DD::MM::YYYY"));
//Test update
//guru._propUpdater.Update(3,"project", "NOUVEAUNom");
//Test Delete
guru._propDeleter.DeleteOnId(4,"project");
ResultTextBlock.Inlines.Add("---------------Projects------------\n");
List<string> list = guru._propSelector.SelectProjects();
foreach (string item in list)
{
ResultTextBlock.Inlines.Add("\n " + item);
}
ResultTextBlock.Inlines.Add("\n---------------------TASKS ----------------\n");
//Test SelectMultipleByEquality
//List<string> res = guru._propSelector.SelectMultipleByEquality("name", "task", "projectid", 2);
//foreach (var item in res)
//{
// ResultTextBlock.Inlines.Add("\n" + item);
//}
//Test Update tasks
//guru._propUpdater.UpdateName(2, "task", "Clean code");
//Test Insert tasks
//guru._propInserter.InsertTask("Mettre tout en flat", DateTime.Now.ToString(), "task", 3, 5);
//Test delete
guru._propDeleter.DeleteOnId(4, "task");
//List<Object> res = guru._propSelector.Select("name", "task");
//foreach (var item in res)
//{
// ResultTextBlock.Inlines.Add("\n" + item);
//}
}
private void CreateButton_Click(object sender, RoutedEventArgs e)
{
DatabaseGuru g = new DatabaseGuru(Paths.PROJECTS_SAVE);
// g._propInserter.InsertTask(TextButton.Text, Deadline.SelectedDate, "formation");
}
public Masterchief ()
{
_guru = new DatabaseGuru (Paths.PROJECTS_SAVE);
}//Masterchief()
public ProjectMasterChief()
{
_guru = new DatabaseGuru(Paths.PROJECTS_SAVE);
}//ProjectMasterChief()
public Project(string name, string startDate, string endDate)
{
_guru = new DatabaseGuru(Paths.PROJECTS_SAVE);
_guru._propInserter.InsertProject(name, startDate, endDate);
}
