public static void UpdateOrder(Order order) { if (order.OrderID == Guid.Empty) return; string sqlQuery = "UPDATE Order SET CustomerFacilityID=@CustomerFacilityID, TerritoryID=@TerritoryID, EmployeeID=@EmployeeID, OrderStatus=@OrderStatus, Identifier=@Identifier, OrderDate=@OrderDate, DateModified=@DateModified, SubTotal=@SubTotal, TaxAmount=@TaxAmount, Total=@Total, Comment=@Comment WHERE OrderID='" + order.OrderID + "'"; DbCommand dbCommand = DBHelper.GetDBCommand(sqlQuery); DBHelper.AddInParameter(dbCommand, "OrderID", DbType.Guid, order.OrderID); DBHelper.AddInParameter(dbCommand, "CustomerFacilityID", DbType.Guid, order.CustomerFacilityID); DBHelper.AddInParameter(dbCommand, "TerritoryID", DbType.Guid, order.TerritoryID); DBHelper.AddInParameter(dbCommand, "EmployeeID", DbType.Guid, order.EmployeeID); DBHelper.AddInParameter(dbCommand, "OrderStatus", DbType.Guid, order.OrderStatusID); DBHelper.AddInParameter(dbCommand, "Identifier", DbType.String, order.Identifier); DBHelper.AddInParameter(dbCommand, "OrderDate", DbType.DateTime, order.OrderDate); if (order.DateModified.HasValue) DBHelper.AddInParameter(dbCommand, "DateModified", DbType.DateTime, order.DateModified.Value); else DBHelper.AddInParameter(dbCommand, "DateModified", DbType.DateTime, DBNull.Value); DBHelper.AddInParameter(dbCommand, "SubTotal", DbType.Decimal, order.SubTotal); DBHelper.AddInParameter(dbCommand, "TaxAmount", DbType.Decimal, order.TaxAmount); DBHelper.AddInParameter(dbCommand, "Total", DbType.Decimal, order.Total); DBHelper.AddInParameter(dbCommand, "Comment", DbType.String, order.Comment); DBHelper.ExecuteNonQuery(dbCommand); }
public static Order InsertOrder(Order order) { string sqlQuery = "INSERT INTO [Order] (OrderID, CustomerFacilityID, TerritoryID, EmployeeID, OrderStatus, Identifier, OrderDate, SubTotal, TaxAmount, Total, Comment) " + " VALUES(@OrderID,@CustomerFacilityID,@TerritoryID,@EmployeeID,@OrderStatus,@Identifier,@OrderDate,@SubTotal,@TaxAmount,@Total,@Comment)"; if (order.OrderID == Guid.Empty) order.OrderID = Guid.NewGuid(); else return null; DbCommand dbCommand = DBHelper.GetDBCommand(sqlQuery); DBHelper.AddInParameter(dbCommand, "OrderID", DbType.Guid, order.OrderID); DBHelper.AddInParameter(dbCommand, "CustomerFacilityID", DbType.Guid, order.CustomerFacilityID); DBHelper.AddInParameter(dbCommand, "TerritoryID", DbType.Guid, order.TerritoryID); DBHelper.AddInParameter(dbCommand, "EmployeeID", DbType.Guid, order.EmployeeID); DBHelper.AddInParameter(dbCommand, "OrderStatus", DbType.Guid, order.OrderStatusID); DBHelper.AddInParameter(dbCommand, "Identifier", DbType.String, order.Identifier); DBHelper.AddInParameter(dbCommand, "OrderDate", DbType.DateTime, order.OrderDate); DBHelper.AddInParameter(dbCommand, "SubTotal", DbType.Decimal, order.SubTotal); DBHelper.AddInParameter(dbCommand, "TaxAmount", DbType.Decimal, order.TaxAmount); DBHelper.AddInParameter(dbCommand, "Total", DbType.Decimal, order.Total); DBHelper.AddInParameter(dbCommand, "Comment", DbType.String, order.Comment); DBHelper.ExecuteNonQuery(dbCommand); return order; }
public Invoice(Guid invoiceid, Order order, Dictionary invoicestatus, string number, DateTime date, bool ispaid) { this.invoiceid = invoiceid; this.order = order; this.invoicestatus = invoicestatus; this.number = number; this.date = date; this.ispaid = ispaid; }
public OrderLine(OrderLineId id, int quantity, decimal itemprice, decimal itempricediscount, decimal total, Order order, Product product) { this.id= id; this.quantity= quantity; this.itemprice= itemprice; this.itempricediscount= itempricediscount; this.total= total; this.order= order; this.product= product; }
public static Order InsertOrder(Order order) { order.OrderDate = DateTime.Now; order.Identifier = GenerateOrderIdentifier(order); OrderDB.InsertOrder(order); if(order.OrderID!=Guid.Empty) { foreach (OrderLine line in order.OrderLines) { line.OrderID = order.OrderID; OrderLineDB.InsertOrderLine(line); } } return order; }
private static string GenerateOrderIdentifier(Order order) { StringBuilder builder = new StringBuilder(); builder.Append(order.OrderDate.Day+"/"+order.OrderDate.Month+"/"+order.OrderDate.Year); builder.Append("_" + order.Territory.Name.Substring(0, 2)); if (order.Employee.Contact != null) { builder.Append("_" + order.Employee.Contact.FirstName.Substring(0, 1) + order.Employee.Contact.LastName.Substring(0, 1)); } Order newestOrder = OrderDB.GetOrders().Where(o => o.Identifier.Contains(builder.ToString())).OrderByDescending(o => o.Identifier).FirstOrDefault(); int idx = 1; if (newestOrder != null) { idx = Int32.Parse(newestOrder.Identifier.Replace(builder.ToString() + "_", "")); idx++; } builder.Append("_" + idx); return builder.ToString(); }
public OrderLineId(Order order, Product product) { this.order= order; this.product= product; }
private static Order GetOrderFromReader(IDataReader dataReader) { Order order = new Order(); order.OrderID = DBHelper.GetGuid(dataReader, "OrderID"); order.CustomerFacilityID = DBHelper.GetGuid(dataReader, "CustomerFacilityID"); order.TerritoryID = DBHelper.GetGuid(dataReader, "TerritoryID"); order.EmployeeID = DBHelper.GetGuid(dataReader, "EmployeeID"); order.OrderStatusID = DBHelper.GetGuid(dataReader, "OrderStatus"); order.Identifier = DBHelper.GetString(dataReader, "Identifier"); order.OrderDate = DBHelper.GetDateTime(dataReader, "OrderDate"); order.DateModified = DBHelper.GetNullableDateTime(dataReader, "DateModified"); order.SubTotal = DBHelper.GetDecimal(dataReader, "SubTotal"); order.TaxAmount = DBHelper.GetDecimal(dataReader, "TaxAmount"); order.Total = DBHelper.GetDecimal(dataReader, "Total"); order.Comment = DBHelper.GetString(dataReader, "Comment"); return order; }