public static void addNewTask(string TaskName, string TaskDescription, double TaskLength, int ProjectID, int Priority, DateTime StartDate)
{
/*
* This method acts similarly to the one above, however is used if a task with priotiy 1 needs to be added (with a start date)
*/
string SQL = "INSERT INTO tblTask(TaskName, TaskDescription, TaskLength, ProjectID, Priority, StartDate) VALUES(@TN,@TD,@TL,@PID,@PR,@SD)";
//Populate command object
command = new MySqlCommand(SQL, Conn);
try
{
//Add SQL param values
command.Parameters.AddWithValue("@TN", TaskName);
command.Parameters.AddWithValue("@TD", TaskDescription);
command.Parameters.AddWithValue("@TL", TaskLength);
command.Parameters.AddWithValue("@PID", ProjectID);
command.Parameters.AddWithValue("@PR", Priority);
command.Parameters.AddWithValue("@SD", TimeHandler.ConvertToAccessDateTime(StartDate));
}
catch (Exception)
{
MessageBox.Show("Failed to bind project information to SQL variables");
}
/*Open the connection and execute the insert-into command. This method will return the number of rows that have been affected (in this case, added)
* therefore, if affectedRows>0, insertion has been completed successfully*/
Conn.Open();
if (command.ExecuteNonQuery() > 0)
{
MessageBox.Show("Task added successfully");
}
else
{
//If the code gets this far, it means that there has not been an in-code syntax error, instead a data entry error (v.likely to be user-related)
MessageBox.Show("Task addition failed - check that all task criteria have a correct entry");
}
//Close the connection to reduce resource usage and prevent other changes to database from other users (and this software)
Conn.Close();
//Update project length
updateProjectLength(ProjectID);
}
public static void editProject(string ProjectName, string ProjectDescription, DateTime StartDate, Project ProjectToEdit)
{
/*
* Takes new project information and syncs these changes to the database
*/
string SQL = "UPDATE tblProject SET ProjectName = @PN, ProjectDescription = @PDN, DateStarted = @SD WHERE ProjectID = @PID";
//Create command
command = new MySqlCommand(SQL, Conn);
try
{
//Add param values
command.Parameters.AddWithValue("@PN", ProjectName);
command.Parameters.AddWithValue("@PDN", ProjectDescription);
command.Parameters.AddWithValue("@SD", TimeHandler.ConvertToAccessDateTime(StartDate));
command.Parameters.AddWithValue("@PID", ProjectToEdit.ID);
}
catch (Exception)
{
MessageBox.Show("Failed to bind information to SQL variables");
}
/*Open the connection and execute the insert-into command. This method will return the number of rows that have been affected (in this case, added)
* therefore, if affectedRows>0, insertion has been completed successfully*/
Conn.Open();
if (command.ExecuteNonQuery() > 0)
{
MessageBox.Show("Project information updated");
}
else
{
//If the code gets this far, it means that there has not been an in-code syntax error, instead a data entry error (v.likely to be user-related)
MessageBox.Show("Project edit failed - check that all criteria have a correct entry");
}
//Close the connection to reduce resource usage and prevent other changes to database from other users (and this software)
Conn.Close();
}
public static void addNewUser(string Username, string Password, string FirstName, string Surname, DateTime DateOfBirth, string EMail)
{
//Generate SQL (with params) and populate the commmand object
string SQL = "INSERT INTO tbluser(Username, Password, FirstName, Surname, DateOfBirth, EMail) VALUES(@UN, @PW, @FN, @SN, @DOB, @EM)";
command = new MySqlCommand(SQL, Conn);
try
{
//Add the paramater values to the command objects
command.Parameters.AddWithValue("@UN", Username);
command.Parameters.AddWithValue("@PW", Password);
command.Parameters.AddWithValue("@FN", FirstName);
command.Parameters.AddWithValue("@SN", Surname);
command.Parameters.AddWithValue("@DOB", TimeHandler.ConvertToAccessDateTime(DateOfBirth));
command.Parameters.AddWithValue("@EM", EMail);
}
catch (Exception)
{
MessageBox.Show("Failed to bind user information to SQL variables");
}
/*Open the connection and execute the insert-into command. This method will return the number of rows that have been affected (in this case, added)
* therefore, if affectedRows>0, insertion has been completed successfully*/
Conn.Open();
if (command.ExecuteNonQuery() > 0)
{
MessageBox.Show("User Registered Successfuly");
}
else
{
//If the code gets this far, it means that there has not been an in-code syntax error, instead a data entry error (v.likely to be user-related)
MessageBox.Show("User registration failed - check that all project criteria have a correct entry");
}
//Close the connection to reduce resource usage and prevent other changes to database from other users (and this software)
Conn.Close();
}
public static void addNewProject(string Username, string ProjectName, string ProjectDescription, DateTime DateStarted, DateTime prjDueDate)
{
//Generate SQL (with params) and populate the commmand object
string SQL = "INSERT INTO tblproject(Username,ProjectName,ProjectDescription,ProjectLength,DateStarted,DateDue) VALUES(@UN,@PN,@PD,@PL,@DS,@DD)";
command = new MySqlCommand(SQL, Conn);
try
{
//Add the paramater values to the command objects
command.Parameters.AddWithValue("@UN", Username);
command.Parameters.AddWithValue("@PN", ProjectName);
command.Parameters.AddWithValue("@PD", ProjectDescription);
command.Parameters.AddWithValue("@PL", 1);
command.Parameters.AddWithValue("@DS", TimeHandler.ConvertToAccessDateTime(DateStarted));
command.Parameters.AddWithValue("@DD", TimeHandler.ConvertToAccessDateTime(prjDueDate));
}
catch (Exception)
{
MessageBox.Show("Failed to bind project information to SQL variables");
}
/*Open the connection and execute the insert-into command. This method will return the number of rows that have been affected (in this case, added)
* therefore, if affectedRows>0, insertion has been completed successfully*/
Conn.Open();
if (command.ExecuteNonQuery() > 0)
{
MessageBox.Show("Project Added Successfuly");
}
else
{
//If the code gets this far, it means that there has not been an in-code syntax error, instead a data entry error (v.likely to be user-related)
MessageBox.Show("New project failed - check that all project criteria have a correct entry");
}
//Close the connection to reduce resource usage and prevent other changes to database from other users (and this software)
Conn.Close();
}
