// Retrieve order information public static OrderInfo GetInfo(string orderID) { // get a configured DbCommand object DbCommand comm = GenericDataAccess.CreateCommand(); // set the stored procedure name comm.CommandText = "OrderGetInfo"; // create a new parameter DbParameter param = comm.CreateParameter(); param.ParameterName = "@OrderID"; param.Value = orderID; param.DbType = DbType.Int32; comm.Parameters.Add(param); // obtain the results DataTable table = GenericDataAccess.ExecuteSelectCommand(comm); DataRow orderRow = table.Rows[0]; // save the results into an OrderInfo object OrderInfo orderInfo = new OrderInfo(); orderInfo.OrderID = Int32.Parse(orderRow["OrderID"].ToString()); orderInfo.TotalAmount = Decimal.Parse(orderRow["TotalAmount"].ToString()); orderInfo.DateCreated = orderRow["DateCreated"].ToString(); orderInfo.DateShipped = orderRow["DateShipped"].ToString(); orderInfo.Verified = bool.Parse(orderRow["Verified"].ToString()); orderInfo.Completed = bool.Parse(orderRow["Completed"].ToString()); orderInfo.Canceled = bool.Parse(orderRow["Canceled"].ToString()); orderInfo.Comments = orderRow["Comments"].ToString(); orderInfo.CustomerName = orderRow["CustomerName"].ToString(); orderInfo.ShippingAddress = orderRow["ShippingAddress"].ToString(); orderInfo.CustomerEmail = orderRow["CustomerEmail"].ToString(); // return the OrderInfo object return orderInfo; }
// Update an order public static void Update(OrderInfo orderInfo) { OrderDAO.Update(orderInfo); }
// Update an order public static void Update(OrderInfo orderInfo) { // get a configured DbCommand object DbCommand comm = GenericDataAccess.CreateCommand(); // set the stored procedure name comm.CommandText = "OrderUpdate"; // create a new parameter DbParameter param = comm.CreateParameter(); param.ParameterName = "@OrderID"; param.Value = orderInfo.OrderID; param.DbType = DbType.Int32; comm.Parameters.Add(param); // create a new parameter param = comm.CreateParameter(); param.ParameterName = "@DateCreated"; param.Value = orderInfo.DateCreated; param.DbType = DbType.DateTime; comm.Parameters.Add(param); // The DateShipped parameter is sent only if data is available if (orderInfo.DateShipped.Trim() != "") { param = comm.CreateParameter(); param.ParameterName = "@DateShipped"; param.Value = orderInfo.DateShipped; param.DbType = DbType.DateTime; comm.Parameters.Add(param); } // create a new parameter param = comm.CreateParameter(); param.ParameterName = "@Verified"; param.Value = orderInfo.Verified; param.DbType = DbType.Byte; comm.Parameters.Add(param); // create a new parameter param = comm.CreateParameter(); param.ParameterName = "@Completed"; param.Value = orderInfo.Completed; param.DbType = DbType.Byte; comm.Parameters.Add(param); // create a new parameter param = comm.CreateParameter(); param.ParameterName = "@Canceled"; param.Value = orderInfo.Canceled; param.DbType = DbType.Byte; comm.Parameters.Add(param); // create a new parameter param = comm.CreateParameter(); param.ParameterName = "@Comments"; param.Value = orderInfo.Comments; param.DbType = DbType.String; comm.Parameters.Add(param); // create a new parameter param = comm.CreateParameter(); param.ParameterName = "@CustomerName"; param.Value = orderInfo.CustomerName; param.DbType = DbType.String; comm.Parameters.Add(param); // create a new parameter param = comm.CreateParameter(); param.ParameterName = "@ShippingAddress"; param.Value = orderInfo.ShippingAddress; param.DbType = DbType.String; comm.Parameters.Add(param); // create a new parameter param = comm.CreateParameter(); param.ParameterName = "@CustomerEmail"; param.Value = orderInfo.CustomerEmail; param.DbType = DbType.String; comm.Parameters.Add(param); // return the results GenericDataAccess.ExecuteNonQuery(comm); }