public bool DeletePayment(Payment payment) { try { PaymentTable.DeleteOnSubmit(payment); PaymentTable.Context.SubmitChanges(); return true; } catch (Exception) { return false; } }
public bool SavePayment(Payment payment) { try { if (payment.PaymentId == 0) { PaymentTable.InsertOnSubmit(payment); } else { PaymentTable.Context.Refresh(RefreshMode.KeepCurrentValues, payment); } PaymentTable.Context.SubmitChanges(); return true; } catch (Exception) { return false; } }
public List<Payment> GetPaymentsByType(Payment.PaymentTypeList paymentType) { return PaymentTable.Where(x => x.PaymentTypeId == (int)paymentType).ToList(); }
public List<Payment> GetPaymentsByStatus(Payment.PaymentStatusList paymentStatus) { return PaymentTable.Where(x => x.PaymentStatusId == (int)paymentStatus).ToList(); }