protected void BtnInsertFee_Click(object sender, EventArgs e)
        {
            FeeDAL feesDAL = new FeeDAL
            {
                ConnectionString = ConfigurationManager.ConnectionStrings["MySQLTest"].ToString()
            };

            Fee fees = new Fee
            {
                RewardName    = TxtAddFeesRewardName.Text,
                ShippingCost  = Double.Parse(TxtAddFeesShippingCost.Text),
                HandlingCost  = Double.Parse(TxtAddFeesHandlingCost.Text),
                ServiceCharge = Double.Parse(TxtAddFeesServiceCharge.Text),
                SKU           = TxtAddFeesSKU.Text
            };

            feesDAL.InsertFees(fees);
            GVFees.EditIndex = -1;

            ResetControls();
            FetchFees();
        }
        protected void GVFees_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            FeeDAL feesDAL = new FeeDAL
            {
                ConnectionString = ConfigurationManager.ConnectionStrings["MySQLTest"].ToString()
            };

            Fee fees = new Fee
            {
                ID            = Convert.ToInt32((GVFees.Rows[e.RowIndex].FindControl("LblFeesIDEdit") as Label).Text),
                RewardName    = (GVFees.Rows[e.RowIndex].FindControl("TxtFeesRewardName") as TextBox).Text,
                ShippingCost  = Double.Parse((GVFees.Rows[e.RowIndex].FindControl("TxtFeesShippingCost") as TextBox).Text),
                HandlingCost  = Double.Parse((GVFees.Rows[e.RowIndex].FindControl("TxtFeesHandlingCost") as TextBox).Text),
                ServiceCharge = Double.Parse((GVFees.Rows[e.RowIndex].FindControl("TxtFeesServiceCharge") as TextBox).Text),
                SKU           = (GVFees.Rows[e.RowIndex].FindControl("TxtFeesSKU") as TextBox).Text
            };

            feesDAL.InsertFees(fees);

            GVFees.EditIndex = -1;
            FetchFees();
        }