public static IEnumerable GetTechIncidents(int TechID) { string query = "SELECT IncidentID, DateOpened, " + "Title, Description, CustomerID, ProductCode, DateClosed " + "FROM Incidents WHERE TechID = @TechID " + "ORDER BY DateOpened"; SqlConnection connection = new SqlConnection(TechSupportDB.GetConnectionString()); SqlCommand command = new SqlCommand(query, connection); command.Parameters.AddWithValue("TechID", TechID); connection.Open(); SqlDataReader dataReader = command.ExecuteReader(); return(dataReader); }
public static int UpdateIncident(Incident original_Incident, Incident incident) { int updateRow = 0; string query = "UPDATE Incidents " + "SET DateClosed = @NewDateClosed, " + "Description = @NewDescription " + "WHERE IncidentID = @original_IncidentID " + "AND ProductCode = @original_ProductCode " + "AND DateOpened = @original_DateOpened " + "AND (DateClosed = @original_DateClosed " + "OR DateClosed IS NULL " + "AND @original_DateClosed IS NULL) " + "AND Title = @original_Title " + "AND Description = @original_Description"; using (SqlConnection connection = new SqlConnection(TechSupportDB.GetConnectionString())) { using (SqlCommand command = new SqlCommand(query, connection)) { if (incident.DateClosed == Convert.ToDateTime("0001-01-01 12:00:00 AM")) { command.Parameters.AddWithValue("NewDateClosed", DBNull.Value); } else { command.Parameters.AddWithValue("NewDateClosed", incident.DateClosed); } command.Parameters.AddWithValue("NewDescription", incident.Description); command.Parameters.AddWithValue("original_IncidentID", original_Incident.IncidentID); command.Parameters.AddWithValue("original_ProductCode", original_Incident.ProductCode); command.Parameters.AddWithValue("original_DateOpened", original_Incident.DateOpened); if (original_Incident.DateClosed == Convert.ToDateTime("0001-01-01 12:00:00 AM")) { command.Parameters.AddWithValue("original_DateClosed", DBNull.Value); } else { command.Parameters.AddWithValue("original_DateClosed", original_Incident.DateClosed); } command.Parameters.AddWithValue("original_Title", original_Incident.Title); command.Parameters.AddWithValue("original_Description", original_Incident.Description); connection.Open(); updateRow = command.ExecuteNonQuery(); } } return(updateRow); }