public List <Model.Common.Invoice> GetInvoice()
{
List <Model.Common.Invoice> Items = new List <Model.Common.Invoice>();
try
{
using (var dBContext = new CustomerReportContext())
{
Model.Common.Invoice inv;
foreach (var it in dBContext.TblInvoices)
{
inv = new Model.Common.Invoice();
inv.InvoiceNo = it.InvoiceNo;
inv.CustomerNo = it.CustomerNo;
inv.InvoiceDate = it.InvoiceDate;
inv.InvoiceAmount = it.InvoiceAmount;
inv.PaymentDueDate = it.PaymentDueDate;
Items.Add(inv);
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(Items);
}
public int AddInvoiceData(Model.Common.Invoice InvoiceModel, string InvoiceNo)
{
List <Model.Common.Invoice> Items = new List <Model.Common.Invoice>();
int returnVal = 0;
try
{
using (var dBContext = new CustomerReportContext())
{
Model.Common.Invoice get;
foreach (var it in dBContext.TblInvoices)
{
get = new Model.Common.Invoice();
get.InvoiceNo = it.InvoiceNo;
get.CustomerNo = it.CustomerNo;
get.InvoiceDate = it.InvoiceDate;
get.InvoiceAmount = it.InvoiceAmount;
get.PaymentDueDate = it.PaymentDueDate;
Items.Add(get);
}
TblInvoices Cust;
//Add record
Cust = new TblInvoices();
Cust.InvoiceNo = InvoiceModel.InvoiceNo;
Cust.CustomerNo = InvoiceModel.CustomerNo;
Cust.InvoiceDate = InvoiceModel.InvoiceDate;
Cust.InvoiceAmount = InvoiceModel.InvoiceAmount;
Cust.PaymentDueDate = Cust.InvoiceDate.AddDays(30);
//dBContext.TblInvoices.Add(Cust);
InvoiceNo = Cust.InvoiceNo;
bool Inv = Items.Any(asd => asd.InvoiceNo == InvoiceNo);
if (Inv == true)
{
returnVal = -1;
}
if (Inv == false)
{
dBContext.TblInvoices.Add(Cust);
returnVal = dBContext.SaveChanges();
}
//returnVal = dBContext.SaveChanges();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(returnVal);
}
