protected void dgvProduct_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (!string.IsNullOrEmpty(e.CommandArgument.ToString()))
        {
            objCommon     = new clsCommon();
            hdnPKID.Value = e.CommandArgument.ToString();
            if (e.CommandName == "Save")
            {
                objCommon     = new clsCommon();
                objNewArrival = new tblNewArrival();

                objNewArrival.AddNew();
                objNewArrival.AppDisplayOrder = objCommon.GetNextDisplayOrder("tblNewArrival", tblNewArrival.ColumnNames.AppDisplayOrder);

                objNewArrival.s_AppProductID = e.CommandArgument.ToString();
                objNewArrival.AppIsActive    = true;

                objNewArrival.Save();

                objNewArrival = null;
                objCommon     = null;
                LoadNewArrival(true, false);

                LoadDataGrid(true, false);
            }
        }
    }
    protected void dgvGridView_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (!string.IsNullOrEmpty(e.CommandArgument.ToString()))
        {
            objCommon     = new clsCommon();
            hdnPKID.Value = e.CommandArgument.ToString();
            if (e.CommandName == "Up")
            {
                LinkButton  inkButton = (LinkButton)e.CommandSource;
                GridViewRow drCurrent = (GridViewRow)inkButton.Parent.Parent;
                if (drCurrent.RowIndex > 0)
                {
                    GridViewRow drUp = dgvGridView.Rows[drCurrent.RowIndex - 1];
                    objCommon.SetDisplayOrder("tblNewArrival", tblNewArrival.ColumnNames.AppNewArrivalID, tblNewArrival.ColumnNames.AppDisplayOrder, (int)dgvGridView.DataKeys[drCurrent.RowIndex].Values[0], (int)dgvGridView.DataKeys[drCurrent.RowIndex].Values[2], (int)dgvGridView.DataKeys[drUp.RowIndex].Values[0], (int)dgvGridView.DataKeys[drUp.RowIndex].Values[2]);
                    LoadDataGrid(false, false);
                    objCommon = null;
                }
            }
            else if (e.CommandName == "Down")
            {
                LinkButton  lnkButton = (LinkButton)e.CommandSource;
                GridViewRow drCurrent = (GridViewRow)lnkButton.Parent.Parent;
                if (drCurrent.RowIndex < dgvGridView.Rows.Count - 1)
                {
                    GridViewRow drUp = dgvGridView.Rows[drCurrent.RowIndex + 1];
                    objCommon.SetDisplayOrder("tblNewArrival", tblNewArrival.ColumnNames.AppNewArrivalID, tblNewArrival.ColumnNames.AppDisplayOrder, (int)dgvGridView.DataKeys[drCurrent.RowIndex].Values[0], (int)dgvGridView.DataKeys[drCurrent.RowIndex].Values[2], (int)dgvGridView.DataKeys[drUp.RowIndex].Values[0], (int)dgvGridView.DataKeys[drUp.RowIndex].Values[2]);
                    LoadDataGrid(false, false);
                    objCommon = null;
                }
            }


            else if (e.CommandName == "IsActive")
            {
                objNewArrival = new tblNewArrival();

                if (objNewArrival.LoadByPrimaryKey(Convert.ToInt32(hdnPKID.Value)))
                {
                    if (objNewArrival.AppIsActive == true)
                    {
                        objNewArrival.AppIsActive = false;
                    }
                    else if (objNewArrival.AppIsActive == false)
                    {
                        objNewArrival.AppIsActive = true;
                    }
                    objNewArrival.Save();
                    LoadDataGrid(false, false, "", "");
                }
                objNewArrival = null;
            }
        }
    }