public int DeleteJoinProject(Member member)
{
try
{
con.Open();
string query = "DELETE FROM JoinProjects " +
"WHERE JoineProjectID = @JoinProjectID OR UserID = @UserID OR ProjectID = @ProjectID";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@JoinProjectID", member.JoinProjectID);
cmd.Parameters.AddWithValue("@UserID", member.UserID);
cmd.Parameters.AddWithValue("@ProjectID", member.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 InsertJoinProject(Member member)
{
try
{
con.Open();
string query = "INSERT INTO JoinProjects " +
"(ProjectID " +
",UserID " +
",RoleID) " +
"VALUES " +
"(@ProjectID " +
",@UserID " +
",@RoleID)";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@ProjectID", member.ProjectID);
cmd.Parameters.AddWithValue("@UserID", member.UserID);
cmd.Parameters.AddWithValue("@RoleID", member.RoleID);
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 SelectJoinProject(Member member)
{
try
{
con = new SqlConnection(connectionString);
con.Open();
string query = "SELECT * " +
"FROM JoinProjects " +
"WHERE JoinProjectID = @JoinProjectID OR ProjectID = @ProjectID OR UserID = @UserID OR RoleID = @RoleID";
cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@JoinProjectID", member.JoinProjectID);
cmd.Parameters.AddWithValue("@ProjectID", member.ProjectID);
cmd.Parameters.AddWithValue("@UserID", member.UserID);
cmd.Parameters.AddWithValue("@RoleID", member.RoleID);
da = new SqlDataAdapter(cmd);
ds = new DataSet();
da.Fill(ds, "JoinProjects");
DataTable dt = ds.Tables["JoinProjects"];
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();
}
}