public clsOrder GetOrder(int OrderNo)// Get { Dictionary <string, object> par = new Dictionary <string, object>(1); par.Add("OrderNo", OrderNo); DataTable lcResult = clsDbConnection.GetDataTable("SELECT * FROM [Order] WHERE OrderNo = @OrderNo", par); if (lcResult.Rows.Count > 0) { DataRow dr = lcResult.Rows[0]; clsOrder lcOrder = dataRow2Order(dr); lcOrder.OrderItem = GetItem(lcOrder.ItemID); return(lcOrder); } else { return(null); } }
public string PostOrder(clsOrder prOrder) // Insert { try { int lcRecCount = clsDbConnection.Execute("INSERT INTO [Order] " + "(Qnty, PricePerItem, CustName, CustPh, TimeOrdered, ItemID) " + "VALUES (@Qnty, @PricePerItem, @CustName, @CustPh, @TimeOrdered, @ItemID)" , prepareOrderParameters(prOrder)); if (lcRecCount == 1) { clsMQTTClient.Instance.MqttPublish("DBChange"); return("One order inserted"); } else { return("Unexpected order insert count: " + lcRecCount); } } catch (Exception ex) { return(ex.GetBaseException().Message); } }
public string DeleteOrder(clsOrder prOrder) // Delete { // delete try { int lcRecCount = clsDbConnection.Execute( "DELETE FROM [Order] " + "WHERE OrderNo = @OrderNo", prepareOrderParameters(prOrder)); if (lcRecCount == 1) { clsMQTTClient.Instance.MqttPublish("DBChange"); return("One order deleted"); } else { return("Unexpected order delete count: " + lcRecCount); } } catch (Exception ex) { return(ex.GetBaseException().Message); } }