private string ValidateNewOrder(clsOrders prOrder) { if (prOrder.Name == "" || prOrder.Email == "") { return("Name or Email Required"); } else if (IsPhoneBooked(prOrder.ProductId)) { return("This product is out of stock"); } else { return("true"); } }
public string DeleteOrder(clsOrders prOrder) { try { int lcRecCount = ClsDBConnection.Execute( "DELETE FROM tbl_orders WHERE id = @Id", prepareOrderParameters(prOrder)); if (lcRecCount == 1) { return("Order is deleted"); } else { return("Error Unexpected order confirm count: " + lcRecCount); } } catch (Exception ex) { return(ex.GetBaseException().Message); } }
public string PutConfirmOrder(clsOrders prOrder) { try { int lcRecCount = ClsDBConnection.Execute( "UPDATE tbl_orders SET status = 1 WHERE id = @Id and updated_at = @UpdatedAt", prepareOrderParameters(prOrder)); if (lcRecCount == 1) { return("Order is confirmed"); } else { return("Error Unexpected order confirm count: " + lcRecCount); } } catch (Exception ex) { return(ex.GetBaseException().Message); } }
public string PostOrder(clsOrders prOrder) { var validString = ValidateNewOrder(prOrder); if (validString == "true") { try { int lcRecCount = ClsDBConnection.Execute("INSERT INTO `tbl_orders` (`name`, `status`, `email`, " + "`amount`, `product_id`) VALUES (@Name, 0, @Email, @Amount, @ProductId)", prepareOrderParameters(prOrder)); if (lcRecCount == 1) { int lcRecUpdateCount = ClsDBConnection.Execute( "UPDATE tbl_all_products SET availability = 'Not Available' WHERE id = " + prOrder.ProductId + "", null); if (lcRecUpdateCount == 1) { return("Your order is completed."); } else { return("Error Unexpected order confirm count: " + lcRecCount); } } else { return("Error Unexpected Product insert count: " + lcRecCount); } } catch (Exception ex) { return("Error: " + ex.GetBaseException().Message); } } else { return(validString); } }