Esempio n. 1
0
        internal static DB.Bookings_And_payments_DataSet_appData.BillsRow Select_Row_Bill_Payment(long Orignal_Bill_iD)
        {
            DB.Bookings_And_payments_DataSet_appData ds = new DB.Bookings_And_payments_DataSet_appData();


            Table_Adapter_Bill_Payments.FillBy_Row_Bill_by_Id(ds.Bills, Orignal_Bill_iD);

            var BillRowQuery = (from o in ds.Bills
                                where (o.BILL_ID == Orignal_Bill_iD)
                                select o).FirstOrDefault();


            return(BillRowQuery);
        }
Esempio n. 2
0
        internal static long Get_LastAdded_Bill_ID()
        {
            long bid = (long)Table_Adapter_Bill_Payments.ScalarQuery_Get_Last_Added_Bill_ID_Store_Procedure_Func();

            return(bid);
        }
Esempio n. 3
0
 internal static void update_Remaining_Bill(decimal NewPaid_amount, decimal NewRemaining_amount, bool isPaidFull, long Orignal_bill_iD)
 {
     Table_Adapter_Bill_Payments.UpdateQuery_Remaining_amount_StoreProcedure_Func(NewPaid_amount, NewRemaining_amount, isPaidFull, Orignal_bill_iD);
 }