コード例 #1
0
        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();
        }
コード例 #2
0
        //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();
        }