// 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); }