public int DeleteProject(Project project) { try { con.Open(); string query = "DELETE FROM Projects " + "WHERE ProjectID = @ProjectID OR ProjectName = @ProjectName OR OwnerUser = @OwnerUser"; SqlCommand cmd = new SqlCommand(query, con); cmd.Parameters.AddWithValue("@ProjectID", project.ProjectID); cmd.Parameters.AddWithValue("@ProjectName", project.ProjectName); cmd.Parameters.AddWithValue("@OwnerUser", project.OwnerUser); 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 InsertProject(Project project) { try { con.Open(); string query = "INSERT INTO Projects " + "(ProjectName " + ",Description " + ",OwnerUser " + ",StartDate " + ",DueDate) " + "VALUES " + "(@ProjectName " + ",@Description " + ",@OwnerUser " + ",@StartDate " + ",@DueDate)"; SqlCommand cmd = new SqlCommand(query, con); cmd = new SqlCommand(query, con); cmd.Parameters.AddWithValue("@ProjectName", project.ProjectName); cmd.Parameters.AddWithValue("@Description", project.Description); cmd.Parameters.AddWithValue("@OwnerUser", project.OwnerUser); cmd.Parameters.AddWithValue("@StartDate", project.StartDate); cmd.Parameters.AddWithValue("@DueDate", project.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 UpdateProject(Project project) { throw new NotImplementedException(); }
public int AddNewProject(Project project) { throw new NotImplementedException(); }
public int UpdateProject(Project project) { try { con.Open(); string query = "UPDATE Projects " + "SET ProjectName = @ProjectName " + ",Description = @Description " + ",OwnerUser = @OwnerUser " + ",StartDate = @StartDate " + ",DueDate = @DueDate " + "WHERE ProjectID = @ProjectID"; SqlCommand cmd = new SqlCommand(query, con); cmd = new SqlCommand(query, con); cmd.Parameters.AddWithValue("@ProjectID", project.ProjectID); cmd.Parameters.AddWithValue("@ProjectName", project.ProjectName); cmd.Parameters.AddWithValue("@Description", project.Description); cmd.Parameters.AddWithValue("@OwnerUser", project.OwnerUser); cmd.Parameters.AddWithValue("@StartDate", project.StartDate); cmd.Parameters.AddWithValue("@DueDate", project.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 DataTable SelectProject(Project project) { try { con = new SqlConnection(connectionString); con.Open(); string query = "SELECT * " + "FROM Projects " + "WHERE ProjectID = @ProjectID OR ProjectName = @ProjectName OR OwnerUser = @OwnerUser"; cmd = new SqlCommand(query, con); cmd.Parameters.AddWithValue("@ProjectID", project.ProjectID); cmd.Parameters.AddWithValue("@ProjectName", project.ProjectName); cmd.Parameters.AddWithValue("@OwnerUser", project.OwnerUser); da = new SqlDataAdapter(cmd); ds = new DataSet(); da.Fill(ds, "Projects"); DataTable dt = ds.Tables["Projects"]; 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(); } }