public InvoiceTbl GetInvoice(int id)
{
try
{
InvoiceTbl c = db.InvoiceTbl.Find(id);
return(c);
}
catch (Exception)
{
throw;
}
}
public int AddInvoice(InvoiceTbl inv)
{
try
{
db.InvoiceTbl.Add(inv);
db.SaveChanges();
return(1);
}
catch (Exception ex)
{
throw;
}
}
public int DeleteInvoice(int id)
{
try
{
InvoiceTbl inv = db.InvoiceTbl.Find(id);
db.InvoiceTbl.Remove(inv);
db.SaveChanges();
return(1);
}
catch (Exception)
{
throw;
}
}
public int UpdateInvoice(InvoiceTbl inv)
{
try
{
db.Entry(inv).State = EntityState.Modified;
db.SaveChanges();
return(1);
}
catch (Exception)
{
throw;
}
}
public int AddInvoice(InvoiceTbl inv, string Invoiceno)
{
int returnVal = 0;
try
{
if (inv.InvoiceDate == DateTime.MinValue)
{
inv.InvoiceDate = DateTime.Now;
}
else
{
inv.InvoiceDate = inv.InvoiceDate;
}
inv.PaymentDueDate = inv.InvoiceDate.AddDays(30);
inv.CreatedDate = DateTime.Now;
if (inv.CreatedDate != null)
{
inv.CreatedBy = "abcd";
}
Invoiceno = inv.InvoiceNo;
bool existingCustomer = db.InvoiceTbl.Any(x => x.InvoiceNo == Invoiceno);
if (existingCustomer == true)
{
returnVal = -1;
}
if (existingCustomer == false)
{
db.InvoiceTbl.Add(inv);
db.SaveChanges();
}
// return 1;
}
catch (Exception ex)
{
throw;
}
return(returnVal);
}
