public static int UpdateOrderItems(PurchaseItemDTO purchaseItemDto) { string query = "UPDATE purchase_has_item SET product_id = " + purchaseItemDto.ProductId + "" + ", brand_id = " + purchaseItemDto.BrandId + ", qty = " + purchaseItemDto.Quntity + ", unit_price = " + purchaseItemDto.Price + ", updated_by = " + purchaseItemDto.UpdatedBy + ", updated_at = '" + DateTime.Now + "' WHERE id = " + purchaseItemDto.Id; try { DataTable purchaseItemTable = DatabaseConnection.ConnectWithServer(query); if (purchaseItemTable == null) { return(-1); } return(1); } catch (Exception) { return(-1); } }
public static int AddOrderItems(PurchaseItemDTO purchaseItemsDto) { string query = "INSERT INTO purchase_has_item (purchase_id, product_id, brand_id, qty, unit_price, created_by) VALUES " + "( " + "" + purchaseItemsDto.PurchaseId + "," + purchaseItemsDto.ProductId + "," + purchaseItemsDto.BrandId + "," + purchaseItemsDto.Quntity + "," + purchaseItemsDto.Price + "," + purchaseItemsDto.CreatedBy + ")"; try { DataTable purchaseItemTable = DatabaseConnection.ConnectWithServer(query); if (purchaseItemTable == null) { return(-1); } return(1); } catch (Exception) { return(-1); } }