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); }