/// <summary>
/// Insert new record on Order tabel
/// </summary>
/// <param name="pMemberID">String</param>
/// <param name="pAmount">Decimal</param>
/// <param name="pDescription">String</param>
/// <param name="pRemarks">Remarks</param>
/// <returns></returns>
public static bool Add(string pOrderId,string pMemberID, decimal pAmount, string pDescription, string pRemarks, DateTime pOrderDate, bool pIsDelivered, bool pIsPaid, DateTime? pDeliveredDate,DateTime? pPaidDate)
{
using (NetworkEntities context = new NetworkEntities())
{
Order objOder = new Order();
objOder.OrderID = pOrderId;
objOder.MembershipID = pMemberID;
objOder.OrderDate = Convert.ToDateTime(pOrderDate);
objOder.Amount = pAmount;
objOder.IsDelivered = false;
objOder.Description = pDescription;
objOder.Remarks = pRemarks;
objOder.IsDelivered = pIsDelivered;
objOder.DeliveredDate = pDeliveredDate;
objOder.IsPaid = pIsPaid;
objOder.PaidDate = pPaidDate;
context.Orders.AddObject(objOder);
int status = context.SaveChanges();
return true;
}
}
/// <summary>
/// Deprecated Method for adding a new object to the Orders EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToOrders(Order order)
{
base.AddObject("Orders", order);
}
/// <summary>
/// Create a new Order object.
/// </summary>
/// <param name="orderID">Initial value of the OrderID property.</param>
/// <param name="membershipID">Initial value of the MembershipID property.</param>
/// <param name="description">Initial value of the Description property.</param>
/// <param name="amount">Initial value of the Amount property.</param>
/// <param name="orderDate">Initial value of the OrderDate property.</param>
public static Order CreateOrder(global::System.String orderID, global::System.String membershipID, global::System.String description, global::System.Decimal amount, global::System.DateTime orderDate)
{
Order order = new Order();
order.OrderID = orderID;
order.MembershipID = membershipID;
order.Description = description;
order.Amount = amount;
order.OrderDate = orderDate;
return order;
}