public SalesOrderDetailCollection GetSalesOrderDetailCollection(string where, string orderBy)
        {
            SalesOrderDetailData       data = new SalesOrderDetailData();
            SalesOrderDetailCollection col  = new SalesOrderDetailCollection();

            try
            {
                col = data.GetAllSalesOrderDetailsDynamicCollection(where, orderBy);
            }
            catch (Exception ex)
            {
                log.Write(ex.Message, "GetSalesOrderDetailCollection");
                throw (ex);
            }
            finally
            {
                data = null;
            }
            return(col);
        }
        public SalesOrderDetailCollection GetAllSalesOrderHeaderCollection()
        {
            SalesOrderDetailData       data = new SalesOrderDetailData();
            SalesOrderDetailCollection col  = new SalesOrderDetailCollection();

            try
            {
                col = data.GetAllSalesOrderDetailsCollection();
            }
            catch (Exception ex)
            {
                log.Write(ex.Message, "GetAllSalesOrderDetailCollection");
                throw (ex);
            }
            finally
            {
                data = null;
            }
            return(col);
        }