public int DeleteTaskAssignmnet(TaskAssignmnet taskAssignment)
{
try
{
con.Open();
string query = "DELETE FROM TaskAssignments "
+ "WHERE TaskAssignmentID = @TaskAssignmentID OR User = @UserID OR TaskID = @TaskID";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@TaskAssignmentID", taskAssignment.TaskAssignmentID);
cmd.Parameters.AddWithValue("@UserID", taskAssignment.UserID);
cmd.Parameters.AddWithValue("@TaskID", taskAssignment.TaskID);
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 InsertTaskAssignmnet(TaskAssignmnet taskAssignment)
{
try
{
con.Open();
string query = "INSERT INTO TaskAssignments " +
"(UserID " +
",TaskID) " +
"VALUES " +
"(@UserID " +
",@TaskID)";
SqlCommand cmd = new SqlCommand(query, con);
cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@UserID", taskAssignment.UserID);
cmd.Parameters.AddWithValue("@TaskID", taskAssignment.TaskID);
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 DataTable SelectTaskAssignment(TaskAssignmnet taskAssignment)
{
try
{
con = new SqlConnection(connectionString);
con.Open();
string query = "SELECT * " +
"FROM TaskAssignments " +
"WHERE TaskAssignmentID = @TaskAssignmentID OR UserID = @UserID OR TaskID = @TaskID";
cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@TaskAssignmentID", taskAssignment.TaskAssignmentID);
cmd.Parameters.AddWithValue("@UserID", taskAssignment.UserID);
cmd.Parameters.AddWithValue("@TaskID", taskAssignment.TaskID);
da = new SqlDataAdapter(cmd);
ds = new DataSet();
da.Fill(ds, "TaskAssignments");
DataTable dt = ds.Tables["TaskAssignments"];
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();
}
}