public int DeleteTask(Task task)
{
try
{
con.Open();
string query = "DELETE FROM Tasks "
+ "WHERE TaskID = @TaskID OR StateID = @StateID OR ProjectID = @ProjectID";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@TaskID", task.TaskID);
cmd.Parameters.AddWithValue("@StateID", task.StateID);
cmd.Parameters.AddWithValue("@ProjectID", task.ProjectID);
return cmd.ExecuteNonQuery();
}
catch (SqlException i)
{
Logs logging = new Logs();
logging.InsertLog(new Log());
return 0;
}
catch (Exception i)
{
Logs logging = new Logs();
logging.InsertLog(new Log());
return 0;
}
finally
{
con.Close();
}
}
public int InsertTask(Task task)
{
try
{
con.Open();
string query = "INSERT Tasks " +
"(TaskName, " +
"Description, " +
"StateID, " +
"ProjectID, " +
"Comments, " +
"Status, " +
"StartDate, " +
"DueDate)" +
"VALUES " +
"(@TaskName, " +
"@Description, " +
"@StateID, " +
"@ProjectID, " +
"@Comments, " +
"@Status, " +
"@StartDate, " +
"@DueDate)";
SqlCommand cmd = new SqlCommand(query, con);
cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@TaskName", task.TaskName);
cmd.Parameters.AddWithValue("@Description", task.Description);
cmd.Parameters.AddWithValue("@StateID", task.StateID);
cmd.Parameters.AddWithValue("@ProjectID", task.ProjectID);
cmd.Parameters.AddWithValue("@Comments", task.Comments);
cmd.Parameters.AddWithValue("@Status", task.Status);
cmd.Parameters.AddWithValue("@StartDate", task.StartDate);
cmd.Parameters.AddWithValue("@DueDate", task.DueDate);
return cmd.ExecuteNonQuery();
}
catch (SqlException i)
{
Logs logging = new Logs();
logging.InsertLog(new Log());
return 0;
}
catch (Exception i)
{
Logs logging = new Logs();
logging.InsertLog(new Log());
return 0;
}
finally
{
con.Close();
}
}
public int UpdateTask(Task task)
{
throw new NotImplementedException();
}
public int AddNewTask(Task task)
{
throw new NotImplementedException();
}
public DataTable SelectTask(Task task)
{
try
{
con = new SqlConnection(connectionString);
con.Open();
string query = "SELECT * " +
"FROM Tasks " +
"WHERE TaskID = @TaskID OR TaskName = @TaskName OR StateID = @StateID OR " +
"ProjectID = @ProjectID";
cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@TaskID", task.TaskID);
cmd.Parameters.AddWithValue("@TaskName", task.TaskName);
cmd.Parameters.AddWithValue("@StateID", task.StateID);
cmd.Parameters.AddWithValue("@ProjectID", task.ProjectID);
da = new SqlDataAdapter(cmd);
ds = new DataSet();
da.Fill(ds, "Tasks");
DataTable dt = ds.Tables["Tasks"];
return dt;
}
catch (SqlException i)
{
Logs logging = new Logs();
logging.InsertLog(new Log());
return null;
}
catch (Exception i)
{
Logs logging = new Logs();
logging.InsertLog(new Log());
return null;
}
finally
{
con.Close();
}
}