public static void deleteAdjustmentVoucher(int voucher) { UniversityStoreEntities CONTEXT = new UniversityStoreEntities(); var b = from x in CONTEXT.AdjustmentVouchers where x.VoucherNumber == voucher select x; AdjustmentVoucher q = b.First <AdjustmentVoucher>(); CONTEXT.DeleteObject(q); CONTEXT.SaveChanges(); }
//public static DateTime getDate(int VoucherNo) //{ // var q2 = from x in CONTEXT.AdjustmentVouchers // where x.VoucherNumber == VoucherNo // select x; // DateTime av =(DateTime) q2.First<AdjustmentVoucher>().DateCreated; // return av; public static void deleteAdjustmentVoucherDetail(int voucherNo) { UniversityStoreEntities CONTEXT = new UniversityStoreEntities(); var a = from x in CONTEXT.AdjustmentVoucherDetails where x.VoucherNumber == voucherNo select x; AdjustmentVoucherDetail d = a.First <AdjustmentVoucherDetail>(); CONTEXT.DeleteObject(d); CONTEXT.SaveChanges(); }