public CustomBill GetCustomBill(int billid)
{
CustomBill item = null;
using (var context = new PBEntities())
{
item = context.CustomBills.Where(s => s.BillId == billid).FirstOrDefault();
}
return(item);
}
public Bill GetBill(int id)
{
Bill item = null;
using (var context = new PBEntities())
{
item = context.Bills.Where(s => s.Id == id).FirstOrDefault();
}
return(item);
}
public List <CustomBill> GetCustomBills(int billid)
{
List <CustomBill> items = null;
using (var context = new PBEntities())
{
items = context.CustomBills.AsNoTracking().ToList().Where(a => a.BillId == billid).ToList();
}
return(items);
}
public Setting GetSettings(Guid userid)
{
Setting items = null;
using (var context = new PBEntities())
{
items = context.Settings.AsNoTracking().ToList().Single(a => a.UserID == userid);
}
return(items);
}
public List <Bill> GetBills(Guid userid)
{
List <Bill> items = null;
using (var context = new PBEntities())
{
items = context.Bills.AsNoTracking().ToList().Where(a => a.UserId == userid).ToList();
}
return(items);
}
public Payday GetPayday(int id)
{
Payday item = null;
using (var context = new PBEntities())
{
item = context.Paydays.Where(s => s.Id == id).FirstOrDefault();
}
return(item);
}
public CustomPaycheck GetCustomPaycheck(int id)
{
CustomPaycheck item = null;
using (var context = new PBEntities())
{
item = context.CustomPaychecks.Where(s => s.Id == id).FirstOrDefault();
}
return(item);
}
public List <CustomPaycheck> GetCustomPaychecks(int paycheckid)
{
List <CustomPaycheck> items = null;
using (var context = new PBEntities())
{
items = context.CustomPaychecks.AsNoTracking().ToList().Where(a => a.PaycheckId == paycheckid).ToList();
}
return(items);
}
public Paycheck GetPaycheck(Guid userid, string type)
{
Paycheck item = null;
using (var context = new PBEntities())
{
item = context.Paychecks.Where(s => s.Type == type && s.UserId == userid).FirstOrDefault();
}
return(item);
}
public List <Paycheck> GetPaychecks(Guid userid)
{
List <Paycheck> items = null;
using (var context = new PBEntities())
{
items = context.Paychecks.AsNoTracking().ToList().Where(a => a.UserId == userid).ToList();
}
return(items);
}
