public DataTable getLigsPick()
        {
            DataTable dt1;

            try
            {
                DataTable dt = (DataTable)this.Session[this._nameSessionData];
                if (dt == null || dt.Rows.Count == 0)
                {
                    return(new DataTable());
                }

                dt1 = DataTableExtensions.CopyToDataTable <DataRow>((IEnumerable <DataRow>)EnumerableRowCollectionExtensions.Where <DataRow>(DataTableExtensions.AsEnumerable(dt), (Func <DataRow, bool>)(x => DataRowExtensions.Field <string>(x, "liq_estid").Equals("PM") || DataRowExtensions.Field <string>(x, "liq_estid").Equals("PF"))));
                return(dt1);

                //return DataTableExtensions.CopyToDataTable<DataRow>((IEnumerable<DataRow>)EnumerableRowCollectionExtensions.Where<DataRow>(DataTableExtensions.AsEnumerable(dt), (Func<DataRow, bool>)(x => DataRowExtensions.Field<string>(x, "liq_estid").Equals("PF"))));
            }
            catch
            {
                return(new DataTable());
            }
        }
        public DataTable getLiqsHalls()
        {
            try
            {
                DataTable dt = (DataTable)this.Session[this._nameSessionData];
                if (dt == null || dt.Rows.Count == 0)
                {
                    return(new DataTable());
                }

                return(DataTableExtensions.CopyToDataTable <DataRow>((IEnumerable <DataRow>)EnumerableRowCollectionExtensions.Where <DataRow>(DataTableExtensions.AsEnumerable(dt), (Func <DataRow, bool>)(x => !DataRowExtensions.Field <string>(x, "lhv_status").Equals("PM")))));
            }
            catch
            {
                return(new DataTable());
            }
        }