public DataTable GetProductTransferRecordsListByTransferDescriptionTypeFromToDateRangeAndStatusAll()
        {
            ProductTransferRecordDAL productTransferRecord = new ProductTransferRecordDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start();
                DataTable dt = productTransferRecord.GetProductTransferRecordsListByTransferDescriptionTypeFromToDateRangeAndStatusAll(this, db);
                db.Stop();

                return dt;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                productTransferRecord = null;
            }
        }
        public string SaveProductTransferRecord(DataTable dtPrdList)
        {
            ProductTransferRecordDAL productTransferRecord = new ProductTransferRecordDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start(true);
                string Id = productTransferRecord.SaveProductTransferRecord(this, dtPrdList, db);
                db.Stop();

                return Id;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                productTransferRecord = null;
            }
        }
        public void ApproveProductTransferRecord()
        {
            ProductTransferRecordDAL productTransferRecord = new ProductTransferRecordDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start(true);
                productTransferRecord.ApproveProductTransferRecord(this, db);
                db.Stop();
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                productTransferRecord = null;
            }
        }
        public DataTable GetProductTransferRecordProductListById(string transferRecordId)
        {
            ProductTransferRecordDAL productTransferRecord = new ProductTransferRecordDAL();

            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start();
                DataTable dt = productTransferRecord.GetProductTransferRecordProductListById(transferRecordId, db);
                db.Stop();

                return dt;
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                productTransferRecord = null;
            }
        }