/// <summary> /// Delete Area by area code /// </summary> /// <param name="PAreaCode"></param> /// <returns></returns> public static bool Delete(string pOrderID) { using (NetworkEntities context = new NetworkEntities()) { FFModal.Order objOrder = context.Orders.FirstOrDefault(x => x.OrderID == pOrderID); if (objOrder == null) return false; else { context.Orders.DeleteObject(objOrder); context.SaveChanges(); return true; } } }
/// <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> /// Edit record on Order table /// </summary> /// <param name="pOrderID"></param> /// <param name="pTaxRatpTaxIDe"></param> /// <returns></returns> public static bool Edit(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 objOrder = context.Orders.FirstOrDefault(x => x.OrderID == pOrderID); objOrder.MembershipID = pMemberID; objOrder.OrderDate = pOrderDate; objOrder.Amount = pAmount; objOrder.Description = pDescription; objOrder.Remarks = pRemarks; objOrder.OrderDate = pOrderDate; objOrder.IsDelivered = pIsDelivered; objOrder.DeliveredDate = pDeliveredDate; objOrder.IsPaid = pIsPaid; objOrder.PaidDate = pPaidDate; context.SaveChanges(); return true; } }
public static List<Order> Search(string pOrderID, string pOrderDate, string pMemberID) { using (NetworkEntities context = new NetworkEntities()) { List<Order> lstOrder = new List<Order>(); //string expression = "( from o in context.Orders "; //if (!string.IsNullOrEmpty(pOrderID)) // expression = " where o.OrderID.Equals(Convert.ToInt32(pOrderID)) "; //if (!string.IsNullOrEmpty(pOrderDate)) //{ // if (!string.IsNullOrEmpty(expression)) // { // expression += " && o.OrderDate.Equals(Convert.ToDateTime(pOrderDate)) "; // } // else // { // expression += " where o.OrderDate.Equals(Convert.ToDateTime(pOrderDate)) "; // } //} //if (!string.IsNullOrEmpty(pMemberID)) //{ // if (!string.IsNullOrEmpty(expression)) // expression += " && o.MembershipID.Equals(pMemberID) "; // else // expression = " where o.MembershipID.Equals(pMemberID) "; //} //expression += " select o).ToList() "; int orderID = string.IsNullOrEmpty(pOrderID) ? 0 : Convert.ToInt32(pOrderID); DateTime? orderDate = null; string[] arr = pOrderDate.Split('/'); if (string.IsNullOrWhiteSpace(arr[0]) || string.IsNullOrWhiteSpace(arr[1]) || string.IsNullOrWhiteSpace(arr[2])) { orderDate = null; } else { orderDate = Convert.ToDateTime(pOrderDate); } // lstOrder = (from o in context.Orders where o.OrderID >= orderID || o.OrderDate.Equals(orderDate) || o.MembershipID.Equals(pMemberID) select o).ToList(); return lstOrder; } }
/// <summary> /// Get Order by Order Id /// </summary> /// <param name="pID"></param> /// <returns></returns> public static Order GetByID(string pID) { using (NetworkEntities context = new NetworkEntities()) { return context.Orders.FirstOrDefault(x => x.OrderID == pID); } }
/// <summary> /// Get All Orders /// </summary> /// <returns></returns> public static List<Order> GetAll() { using (NetworkEntities context = new NetworkEntities()) { return context.Orders.ToList(); } }