public Invoice GetInvoiceByInvoiceId(Int64 id)
{
using (InvoiceModuleContext dbContext = new InvoiceModuleContext())
{
return(dbContext.invoices.Where(x => x.Id == id).FirstOrDefault());
}
}
public List <RGDetails> GetRGDetails(int userId, int invoiceId)
{
using (InvoiceModuleContext dbContext = new InvoiceModuleContext())
{
var invoices = dbContext.rgDetails.Where(x => x.MPDetailsId.Equals(invoiceId) && x.Createdby.Equals(userId) && x.IsDeleted.Equals(false));
return(invoices.ToList());
}
}
/// <summary>
/// Repository class for all methods which will be called from controller
/// From here we will call our Db, will perform all DB actions
/// </summary>
public List <Invoice> GetInvoices(int userId)
{
using (InvoiceModuleContext dbContext = new InvoiceModuleContext())
{
var invoices = dbContext.invoices.Where(x => x.Createdby.Equals(userId) && x.IsDeleted.Equals(false));
return(invoices.ToList());
}
}
public List <Users> GetUsers()
{
using (InvoiceModuleContext dbContext = new InvoiceModuleContext())
{
var users = dbContext.users;
return(users.ToList());
}
}
public void UpdateInvoice(Invoice invoice)
{
using (InvoiceModuleContext dbContext = new InvoiceModuleContext())
{
invoice.Modifieddate = DateTime.Now;
dbContext.Update(invoice);
dbContext.SaveChanges();
}
}
public Int64 InsertInvoice(Invoice invoice)
{
using (InvoiceModuleContext dbContext = new InvoiceModuleContext())
{
dbContext.invoices.Add(invoice);
dbContext.SaveChanges();
return(invoice.Id);
}
}
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();
});
}
}
