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