/// <summary> /// Remove OrderPayment from the database /// </summary> /// <param name="orderPayment"></param> /// <param name="db"></param> public static void RemoveOrderPayment(OrderPaymentModel orderPayment, string db) { using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConfig.CnnVal(db))) { var p = new DynamicParameters(); p.Add("@Id", orderPayment.Id); connection.Execute("dbo.spOrderPayment_Delete", p, commandType: CommandType.StoredProcedure); } }
/// <summary> /// Search in all orders to find the OrderPayment Then return the Order /// </summary> /// <param name="orderPayment"></param> /// <returns></returns> public static OrderModel GetTheOrder(OrderPaymentModel orderPayment) { foreach (OrderModel order in PublicVariables.Orders) { OrderPaymentModel orderPaymentModel; orderPaymentModel = order.OrderPayments.Find(x => x == orderPayment); if (orderPaymentModel != null) { return(order); } } return(null); }
/// <summary> /// Add OrderPayment to the database /// Get the orderPayment with the new ID /// </summary> /// <param name="orderPayment"></param> /// <param name="order"></param> /// <param name="db"></param> /// <returns></returns> public static OrderPaymentModel AddOrderPaymentToTheDatabase(OrderPaymentModel orderPayment, OrderModel order, string db) { using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConfig.CnnVal(db))) { var p = new DynamicParameters(); p.Add("@OrderId", order.Id); p.Add("@StaffId", orderPayment.Staff.Id); p.Add("@StoreId", orderPayment.Store.Id); p.Add("@Paid", orderPayment.Paid); p.Add("@Date", orderPayment.Date); p.Add("@Id", 0, dbType: DbType.Int32, direction: ParameterDirection.Output); connection.Execute("dbo.spOrderPayment_Create", p, commandType: CommandType.StoredProcedure); orderPayment.Id = p.Get <int>("@Id"); } return(orderPayment); }