public OrdersDS.OrdersRow GetOrderByVisualId(string VisualId) { VisualId = StringUtils.SQLEncode(VisualId); OrdersDSTableAdapters.OrdersTableAdapter adp = new lw.Orders.OrdersDSTableAdapters.OrdersTableAdapter(); OrdersDS.OrdersDataTable dt = adp.GetOrderByVisualId(VisualId); if (dt.Rows.Count == 0) { return(null); } return((OrdersDS.OrdersRow)dt.Rows[0]); }
public void AddComment(int OrderId, string Comments) { OrdersDSTableAdapters.OrdersTableAdapter adp = new lw.Orders.OrdersDSTableAdapters.OrdersTableAdapter(); OrdersDS.OrdersRow order = GetOrder(OrderId); adp.UpdateComments(order.Comments + "{sep}" + Comments, OrderId); }
public void DeleteOrder(int orderId) { OrdersDSTableAdapters.OrdersTableAdapter adp = new lw.Orders.OrdersDSTableAdapters.OrdersTableAdapter(); adp.DeleteByOrderId(orderId); }