public IEnumerable <money> GetMoney()
{
using (OrdersPaymentsDBEntities db = new OrdersPaymentsDBEntities())
{
return(db.money.ToList());
}
}
public bool GetPaymentInfoByOrderId(int orderId)
{
using (OrdersPaymentsDBEntities db = new OrdersPaymentsDBEntities())
{
return(db.payments.Any(p => p.order_id == orderId));
}
}
public IEnumerable <orders> GetOrders()
{
using (OrdersPaymentsDBEntities db = new OrdersPaymentsDBEntities())
{
return(db.orders.ToList());
}
}
public void InsertPayment(payments payment)
{
using (OrdersPaymentsDBEntities db = new OrdersPaymentsDBEntities())
{
db.Database.ExecuteSqlCommand($@"insert into payments(money_id, order_id, payment_sum)
values ({payment.money_id}, {payment.order_id}, {payment.payment_sum})");
}
}
