public PartialViewResult DetailTableView(string tableid, string id) { // Define the base SQL query string SQLString = "SELECT tblorder_event_queue.*, c_status.name FROM tblorder_event_queue, c_status WHERE tblorder_event_queue.EventID = c_status.StatusID and tblorder_event_queue.OrderID IN (" + id + ") and tblorder_event_queue.CategoryID=2"; // Add the group by clause SQLString += " ORDER BY tblorder_event_queue.UpdateDate"; // Create a list of our result class to hold the data from the query // Please ensure you instatiate the class for this controller and not a different controller List <PurchaseEventQuene> result = new List <PurchaseEventQuene>(); // Execute the SQL query and get the results using (MySqlDataAdapter adapter = new MySqlDataAdapter(SQLString, new MySqlConnection(Helpers.Helpers.GetERPConnectionString()))) { DataSet ds = new DataSet(); adapter.Fill(ds); DataTable tb = (DataTable)ds.Tables[0]; if (tb != null && tb.Rows.Count > 0) { for (int i = 0; i < tb.Rows.Count; i++) { DataRow dr = tb.Rows[i]; result.Add(PurchaseEventQuene.fillInObject(dr)); } } } ViewBag.tableid = tableid; return(PartialView("DetailTableView", result)); }
public static PurchaseEventQuene fillInObject(DataRow dr) { PurchaseEventQuene account = new PurchaseEventQuene(); account.OrderEventQueueID = Int32.Parse(dr["OrderEventQueueID"].ToString()); if (dr["OrderID"] != DBNull.Value) { account.OrderID = Int32.Parse(dr["OrderID"].ToString()); } if (dr["EventID"] != DBNull.Value) { account.EventID = Int32.Parse(dr["EventID"].ToString()); } account.Note = dr["Note"].ToString(); if (dr["UpdateDate"] != DBNull.Value) { account.UpdateDate = DateTime.Parse(dr["UpdateDate"].ToString()); } account.name = dr["name"].ToString(); return(account); }