private void Button_Click(object sender, RoutedEventArgs e)
{
//Update project name
MySqlDataReader reader = ChaoticaDBManager.Query("UPDATE projects SET Title = '" + xTitle.Text.ToString() + "' WHERE ID = '" + this.proj.ID + "';");
reader.Close();
}
public MainPage()
{
this.InitializeComponent();
this.MyProjects = new ObservableCollection <ChaoticaProject>();
this.MyBugs = new ObservableCollection <ChaoticaBug>();
this.MyProjects.Clear();
c_ProjectsPanel.ItemsSource = this.MyProjects;
/*ENCODING BEGIN*/
System.Text.EncodingProvider ppp;
ppp = System.Text.CodePagesEncodingProvider.Instance;
System.Text.Encoding.RegisterProvider(ppp);
/*ENCODING END*/
//MySQL Query
MySqlDataReader reader = ChaoticaDBManager.Query("SELECT * FROM projects;");
//Loop Tables
while (reader.Read())
{
//Add Project [Get Project Title]
this.MyProjects.Add(new ChaoticaProject(reader.GetString("ID"), reader.GetString("Title")));
}
reader.Close();
}
public void LoadBugList(ChaoticaProject proj)
{
//Clear bug list
this.Bugs.Clear();
//MySQL Query
MySqlDataReader reader = ChaoticaDBManager.Query("SELECT * FROM `bugs` WHERE PID = '" + this.ID + "';");
//Loop Tables
while (reader.Read())
{
//Add Project [Get Project Title]
this.AddBug(new ChaoticaBug(reader.GetString("ID"), reader.GetString("Title"), reader.GetString("Description"), reader.GetString("TimeStamp"), reader.GetInt32("Priority"), reader.GetBoolean("Resolved"), proj));
}
//Close reader
reader.Close();
}
public void RefreshProjectsList()
{
//Clear project list
this.MyProjects.Clear();
btnn = c_CreateProject;
//MySQL Query
MySqlDataReader reader = ChaoticaDBManager.Query("SELECT * FROM projects;");
//Loop Tables
while (reader.Read())
{
//Add Project [Get Project Title]
this.MyProjects.Add(new ChaoticaProject(reader.GetString("ID"), reader.GetString("Title")));
}
reader.Close();
}
private void Button_Click(object sender, RoutedEventArgs e)
{
if (xTitle.Text == "")
{
return;
}
//Query existing project
MySqlDataReader reader = ChaoticaDBManager.Query("SELECT * FROM projects WHERE Title = '" + xTitle.Text.ToString() + "';");
int x = 0;
int y = 0;
while (reader.Read())
{
if (xTitle.Text.ToString() == reader.GetString("Title"))
{
x++;
break;
}
}
//Close reader
reader.Close();
//If project not found
if (x <= 0)
{
//Insert project
reader = ChaoticaDBManager.Query("INSERT INTO projects (Title) VALUES ('" + xTitle.Text + "')");
//Close reader
reader.Close();
FinishProjectCreation();
}
else
{
}
}