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