// GET: Member/Delete/5
public ActionResult Delete(ComplaintRecord complaintRecord)
{
var d = finance.ComplaintRecords.Where(x => x.ID == complaintRecord.ID).FirstOrDefault();
finance.ComplaintRecords.Remove(d);
finance.SaveChanges();
return(RedirectToAction("viewComplaints"));
}
public ActionResult Create(ComplaintRecord complaintRecord)
{
if (!ModelState.IsValid)
{
return(View());
}
finance.ComplaintRecords.Add(complaintRecord);
finance.SaveChanges();
//Response.Redirect("StudentAdmission",true);
return(View());
}
public ActionResult Edit(ComplaintRecord complaintRecord)
{
var orignalRecord = (from m in finance.ComplaintRecords where m.ID == complaintRecord.ID select m).First();
if (!ModelState.IsValid)
{
return(View(orignalRecord));
}
finance.Entry(orignalRecord).CurrentValues.SetValues(complaintRecord);
finance.SaveChanges();
return(RedirectToAction("viewComplaints"));
}
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);
}
