public static VoucherDetail GetVoucherDetail(Guid ID) { using (VouchersDBEntities ctx = new VouchersDBEntities()) { return(ctx.VoucherDetails.FirstOrDefault(v => v.ID == ID)); } }
public static List <Account> GetAllAcccounts() { using (VouchersDBEntities ctx = new VouchersDBEntities()) { return(ctx.Accounts.OrderBy(v => v.Name).ToList()); } }
//Voucher Details public static List <VoucherDetail> GetVoucherDetails(Guid ID) { using (VouchersDBEntities ctx = new VouchersDBEntities()) { return(ctx.VoucherDetails.Where(v => v.VoucherID == ID).ToList()); } }
//Vouchers public static List <Voucher> GetVouchers() { using (VouchersDBEntities ctx = new VouchersDBEntities()) { return(ctx.Vouchers.OrderByDescending(v => v.Date).ToList()); } }
//Accounts public static List <Account> GetAccountsByType(int Type) { using (VouchersDBEntities ctx = new VouchersDBEntities()) { var isIncome = Convert.ToBoolean(Type); return(ctx.Accounts.Where(v => v.Type == isIncome).OrderByDescending(v => v.Type).ToList()); } }
public static void AddDetail(VoucherDetail Item) { using (VouchersDBEntities ctx = new VouchersDBEntities()) { ctx.VoucherDetails.Add(Item); ctx.SaveChanges(); } }
public static void RemoveDetail(VoucherDetail Item) { using (VouchersDBEntities ctx = new VouchersDBEntities()) { var d = ctx.VoucherDetails.FirstOrDefault(vd => vd.ID == Item.ID); ctx.VoucherDetails.Remove(d); ctx.SaveChanges(); } }