public static IEnumerable <PaymentModel> GetPayments()
{
using (var db = new PaymentsContext())
{
return(new List <PaymentModel>(db.Payments.OrderBy(x => x.EmployeeId).ToList()));
}
}
public static bool DoesReportExist(string reportId)
{
using (var db = new PaymentsContext())
{
var exists = db.Reports.Where(x => x.ReportId == reportId).FirstOrDefault() != null;
return(exists);
}
}
public static void WriteRecords(IEnumerable <PaymentModel> payments, string reportId)
{
using (var db = new PaymentsContext())
{
db.Reports.Add(new PaymentReport {
ReportId = reportId
});
foreach (var payment in payments)
{
db.Payments.Add(payment);
}
db.SaveChanges();
}
}
