public static List <ComplaintRecord> GetComplaints()
{
List <ComplaintRecord> complaintRecords = new List <ComplaintRecord>();
String query = "SELECT orderId, workerId, description, DATE_FORMAT(openDate,'%Y-%m-%d') AS openDate, isClosed FROM complaints ";
DataTable complaints = connector.ExecuteQuery(query);
foreach (DataRow dr in complaints.Rows)
{
ComplaintRecord record = new ComplaintRecord();
record.Fill(dr);
complaintRecords.Add(record);
}
return(complaintRecords);
}
public static ComplaintRecord GetComplaint(int orderId)
{
String query = $"SELECT orderId, workerId, description, DATE_FORMAT(openDate,'%Y-%m-%d') AS openDate, isClosed FROM complaints WHERE orderId='{orderId}'";
DataTable complaint = connector.ExecuteQuery(query);
if (complaint.Rows.Count == 0)
{
return(null);
}
var record = new ComplaintRecord();
record.Fill(complaint.Rows[0]);
return(record);
}
