public Int64 InsertInvoice(Invoice invoice)
{
using (InvoiceModuleContext dbContext = new InvoiceModuleContext())
{
dbContext.invoices.Add(invoice);
dbContext.SaveChanges();
return(invoice.Id);
}
}
public void UpdateInvoice(Invoice invoice)
{
using (InvoiceModuleContext dbContext = new InvoiceModuleContext())
{
invoice.Modifieddate = DateTime.Now;
dbContext.Update(invoice);
dbContext.SaveChanges();
}
}
public void UpdateRGNotes(Invoice notes)
{
using (InvoiceModuleContext dbContext = new InvoiceModuleContext())
{
var invoice = dbContext.invoices.Where(x => x.Id == notes.Id).First();
invoice.RGNotes = notes.RGNotes;
invoice.Modifieddate = DateTime.Now;
dbContext.SaveChanges();
}
}
public Int64 InsertRGDetails(RGDetails model)
{
using (InvoiceModuleContext dbContext = new InvoiceModuleContext())
{
model.Createddate = DateTime.Now;
dbContext.rgDetails.Add(model);
dbContext.SaveChanges();
return(model.Id);
}
}
public void DeleteMPDetails(List <int> selectedMPIds)
{
using (InvoiceModuleContext dbContext = new InvoiceModuleContext())
{
selectedMPIds.ForEach(x =>
{
var mpDetails = dbContext.mpDetails.Where(m => m.Id.Equals(x)).FirstOrDefault();
mpDetails.IsDeleted = true;
dbContext.SaveChanges();
});
}
}