protected void _grdUserUnit_ItemCommand(object source, GridCommandEventArgs e)
    {
        if (e.Item.ItemType == GridItemType.AlternatingItem || e.Item.ItemType == GridItemType.Item)
        {
            GridEditableItem editedItem = e.Item as GridEditableItem;
            string _ID = editedItem.OwnerTableView.DataKeyValues[editedItem.ItemIndex]["ID"].ToString();
            GridDataItem item = e.Item as GridDataItem;
            if (item != null)
            {
                LinkButton button = item["Disable"].Controls[0] as LinkButton;

                if (button.Text == "Enable")
                {
                    if (_rdoUnit.Checked)
                        EnableUnit(_ID);
                }
                else if (button.Text == "Disable")
                {
                    if (_rdoUnit.Checked)
                        DisableUnit(_ID);
                    //else if (_rdoUser.Checked)
                    //DisableUser(_ID);
                }
            }
        }
    }

 protected void ucTourists_onTouristUpdated(object sender, GridCommandEventArgs e)
 {
     this.lblUpdated.Text = "Updated: " + ((GridEditableItem)e.Item).GetDataKeyValue("PolTuristiSaraksts").ToString();
     var intTouristId = (int)((GridEditableItem)e.Item).GetDataKeyValue("PolTuristiSaraksts");
     var itemTourist = ucTourists.TouristsList.Where(n => n.PolTuristiSaraksts == intTouristId).FirstOrDefault();
     itemTourist.Fransize = itemTourist.PolTuristiSaraksts * 5;
 }

 protected void RadGrid1_InsertCommand(object sender, GridCommandEventArgs e)
 {
     var item = e.Item as GridEditableItem;
     var values = new Hashtable();
     item.ExtractValues(values);
     BLL.Users.Insert(values);
 }

    protected void RadGrid1_InsertCommand(object source, GridCommandEventArgs e)
    {
        var editableItem = ((GridEditableItem)e.Item);
        Hashtable values = new Hashtable();
        editableItem.ExtractValues(values);
        try
        {
            var posName = values["PositionName"] as string;

            if (posName == null || string.IsNullOrEmpty(posName.Trim()))
            {
                ShowErrorMessage(Pharma.Please_provide_name_to_add);
                e.Canceled = true;
            }
            else
            {
                var result = repo.Add(posName.Trim());
                if (!result)
                {
                    ShowErrorMessage("Position Name is unique, please choose another name.");
                    e.Canceled = true;
                }
            }
        }
        catch (System.Exception ex)
        {
            ShowErrorMessage(ex.Message);
            e.Canceled = true;
        }
    }

 protected void RadGrid1_OnItemCommand(object sender, GridCommandEventArgs e)
 {
     try
     {
         GridDataItem item = (GridDataItem)e.Item;
         string id = item["colId"].Text;
         switch (e.CommandName)
         {
             case "btnSelect":
                 {
                    Response.Redirect("DesignationInformation.aspx?id="+id,true);
                     break;
                 }
             case "btnDelete":
                 int del = new Designation().DeleteDesignationByDesignationId(int.Parse(id));
                 if (del == 0)
                     Alert.Show("Data is not deleted");
                 else
                 {
                     this.LoadDesignationTable();
                 }
                 break;
         }
     }
     catch (Exception ex)
     {
         Alert.Show(ex.Message);
     }
 }

        protected void BlogGrid_ItemCommand(Object sender, GridCommandEventArgs e)
        {
            try
            {
                if (e.CommandName == "Delete")
                {
                    GridEditableItem item = (GridEditableItem)e.Item;
                    Object id = item.GetDataKeyValue("ID");

                    try
                    {
                        BlogManager.Current.Delete(Convert.ToInt32(id));
                        BlogManager.Current.Save();
                    }
                    finally
                    {
                        BlogManager.Current.Reset();
                    }
                }
            }
            catch (Exception ex)
            {

                SetMessage("Article cannot be deleted. Reason: " + ex.Message);
                e.Canceled = true;
            }
            finally
            {
                BlogGrid.Rebind();
            }
        }

 protected void RadGrid1_InsertCommand(object sender, GridCommandEventArgs e)
 {
     GridEditableItem item = e.Item as GridEditableItem;
     Hashtable values = new Hashtable();
     item.ExtractValues(values);
     roles.Insert(values);
 }

        protected void grdConference_ItemCommand(object sender, GridCommandEventArgs e)
        {
            if (e.Item != null)
            {
                string[] commandsToCloseOtherItemsFor = { RadGrid.InitInsertCommandName, RadGrid.EditCommandName };
                if (commandsToCloseOtherItemsFor.Contains(e.CommandName))
                {
                    e.Item.OwnerTableView.IsItemInserted = false;
                    e.Item.OwnerTableView.ClearChildEditItems();
                }

                if (e.CommandName.Equals(RadGrid.ExpandCollapseCommandName))
                {
                    e.Item.OwnerTableView.IsItemInserted = false;
                    e.Item.OwnerTableView.ClearChildEditItems();

                    if (e.Item is GridDataItem)
                    {
                        foreach (GridDataItem item in e.Item.OwnerTableView.Items.OfType<GridDataItem>().Where(it => it != e.Item))
                        {
                            item.Expanded = false;
                        }
                    }
                }

                if (e.CommandName.Equals(RadGrid.RebindGridCommandName))
                {
                    GridTableView table = e.Item.OwnerTableView;
                    table.SortExpressions.Clear();
                    table.Rebind();
                    e.Canceled = true;
                }
            }
        }

        protected void MenuGrid_ItemCommand(Object sender, GridCommandEventArgs e)
        {
            try
            {
                GridEditableItem item = (GridEditableItem)e.Item;
                Int32 id = (Int32)item.GetDataKeyValue("ID");

                if (e.CommandName == "Delete")
                {
                    try
                    {
                        if (MenuManager.Current.Delete(id))
                            MenuManager.Current.Save();
                        else
                            ShowMessage("Item cannot be removed: menu contains a child items.");
                    }
                    finally
                    {
                        MenuManager.Current.Reset();
                    }
                }
            }
            catch (Exception ex)
            {

                ShowMessage("Activity cannot be deleted. Reason: " + ex.Message);
                e.Canceled = true;
            }
            finally
            {
                MenuGrid.Rebind();
            }
        }

    protected void rgAdminListDepartment_InsertCommand(object source, GridCommandEventArgs e)
    {
        GridEditableItem dataItem = (GridEditableItem)e.Item;

        int departmentId = 0;

        TextBox txtDepartmentName = (TextBox)dataItem["DepartmentName"].Controls[0];
        TextBox txtDescription = (TextBox)dataItem["Description"].Controls[0];

        if (txtDepartmentName.Text == string.Empty || txtDescription.Text == string.Empty)
        {
            ShowAlertMessage("Please enter the department and description to add!");
        }
        else
        {
            int IsSaved = new AdministrationBAL().InsertDepartment(departmentId, txtDepartmentName.Text, txtDescription.Text);
            if (IsSaved < 0)
                ShowAlertMessage("Entered Department is already exists!");
            else
            {
                ShowAlertMessage("New Department Saved successfully!");
            }
        }
        BindDepartment(false);
    }

        void pGrid_ItemCommand(object sender, GridCommandEventArgs e)
        {
            Int64 Key = 0;

            // Get the ID for the row to select or delete
            if (e.CommandName.ToUpper() == "SELECT" || e.CommandName.ToUpper() == "DELETE")
            {
                //Key = Methods.Convert_Int64(this.UserGrid.pGrid.MasterTableView.Items[e.Item.ItemIndex].GetDataKeyValue("RecruitmentTestUserID").ToString());
                Key = this.UserGrid.GetKey(e.Item.ItemIndex);
            }

            switch (e.CommandName)
            {
                case "Select":
                    this.Response.Redirect(@"~/Page/User_Details.aspx?ID=" + Key);
                    break;

                case "Delete":
                    ClsKeys ClsKey = new ClsKeys();
                    ClsKey.Add("RecruitmentTestUserID", Convert.ToInt64(Key));

                    this.ClsUser.Load(ClsKey);
                    this.ClsUser.Delete();
                    this.UserGrid.RebindGrid();

                    break;
            }
        }

        protected void RadGrid1_OnItemCommand(object sender, GridCommandEventArgs e)
        {
            try
            {

                GridDataItem item = (GridDataItem)e.Item;

                string id = item["colId"].Text;

                switch (e.CommandName)
                {
                    case "btnSelect":
                        Response.Redirect("ChartOfAccounting.aspx?id=" + id, true);
                        break;
                    case "btnDelete":
                        //int delete = new Bank().DeleteBankByBankId(int.Parse(id));
                        int delete = new ChartOfAccount().DeleteChartOfAccountByCoaId(int.Parse(id));

                        if (delete == 0)
                        {
                            Alert.Show("Data was not delete..");
                        }
                        else
                            LoadChartOfAccountTable();
                        break;
                }
            }
            catch (Exception ex)
            {
                Alert.Show(ex.Message);
            }
        }

        protected void RadGrid1_ItemCommand(object source, GridCommandEventArgs e)
        {
            if (e.CommandName == "btntradedetails")
            {
                GridDataItem item = (GridDataItem)e.Item;
                int paymentkey = Convert.ToInt32(item["payments_key"].Text);
                LoadTradeDetails(paymentkey);
                pnltradedetails.Visible = true;
            }
            if (e.CommandName == "btnWithdraw")
            {
                GridDataItem item = (GridDataItem)e.Item;
                int paymentkey = Convert.ToInt32(item["payments_key"].Text);
                Payment paymenttemp = sitetemp.getPayment(paymentkey);
                Int64 payment_payment_object_key = sitetemp.getpaymentobject(6, paymentkey);
                Users user_requestor = sitetemp.get_user_info(paymenttemp.Requestor_user_key);

                sitetemp.InternalTransaction(paymenttemp.Buy_currency, paymenttemp.Buy_amount, payment_payment_object_key, paymenttemp.Payment_object_receiver, currentuser.User_key, "From Payment object to Withdrawl Bank Account", 1, paymentkey);
                Peerfx_DB.SPs.UpdatePaymentStatus(paymentkey, 5).Execute(); //payment delivered

                //payment completed, send email
                Peerfx.External_APIs.SendGrid sg = new Peerfx.External_APIs.SendGrid();
                sg.Send_Email_Payment_Completed(paymenttemp.Payments_Key, user_requestor);

                RadGrid1.Rebind();
            }
        }

 /// <summary>
 /// rGridAddress_DeleteCommand - Is executed if the 'Delete' command is called
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 protected void rGridAddress_DeleteCommand(object sender, GridCommandEventArgs e)
 {
     GridEditableItem eeditedItem = e.Item as GridEditableItem;
     sp_Sample_Address_Select_DM cSampleAddress = new sp_Sample_Address_Select_DM();
     cSampleAddress.AddrID = Convert.ToInt32(eeditedItem.OwnerTableView.DataKeyValues[eeditedItem.ItemIndex]["AddrID"]);
     BLL.DeleteSampleAddressContext(cSampleAddress);
 }

 protected void grid_OnDeleteCommand(object sender, GridCommandEventArgs e)
 {
     try
     {
         var item = (e.Item as GridEditableItem);
     // ReSharper disable PossibleNullReferenceException
         var roleId = Guid.Parse(item.GetDataKeyValue("RoleId").ToString());
     // ReSharper restore PossibleNullReferenceException
         var userId = Guid.Parse(item.GetDataKeyValue("UserId").ToString());
         var ur = new UserRole
         {
             UserId = userId,
             RoleId = roleId,
             State = State.删除
         };
         HomoryContext.Value.UserRole.AddOrUpdate(ur);
         HomoryContext.Value.SaveChanges();
         LogOp(OperationType.删除);
         grid.Rebind();
         Notify(panel, "操作成功", "success");
     }
     // ReSharper disable EmptyGeneralCatchClause
     catch
     // ReSharper restore EmptyGeneralCatchClause
     {
     }
 }

        protected void InsertUpdateRecord(bool Update, object sender, GridCommandEventArgs e)
        {
            GridEditableItem items = e.Item as GridEditableItem;
            GridEditFormItem editform = (GridEditFormItem)e.Item;
            Hashtable values = new Hashtable();
            items.ExtractValues(values);
            Telerik.Web.UI.RadEditor RadEditor1 = (Telerik.Web.UI.RadEditor)editform.FindControl("RadEditor1");
            RadComboBox ddContentType = (RadComboBox)editform.FindControl("ddContentType");
            CheckBox chkPublished = (CheckBox)editform.FindControl("chkPublished");
            CheckBox chkIsMenu = (CheckBox)editform.FindControl("chkIsMenu");
            values["ContentTypeID"] = ddContentType.SelectedValue;
            values["ContentText"] = RadEditor1.Content;
            values["Published"] = chkPublished.Checked;
            values["IsMenu"] = chkIsMenu.Checked;

            if (Update == false)
            {
                EntityKey = int.Parse(items.GetDataKeyValue(RadGridKey).ToString());
                BLL.Content.Update(EntityKey, values);
            }
            else
            {
                BLL.Content.Create(values);
            }
        }

    protected void rgAdminListSymptom_InsertCommand(object source, GridCommandEventArgs e)
    {
        GridEditableItem dataItem = (GridEditableItem)e.Item;

        int symptomId = 0;

        TextBox txtSymptom = (TextBox)dataItem["Symptom"].Controls[0];
        TextBox txtDescription = (TextBox)dataItem["Description"].Controls[0];

        if (txtSymptom.Text == string.Empty || txtDescription.Text == string.Empty)
        {
            ShowAlertMessage("Please enter the symptom and description to add!");
        }
        else
        {
            int IsSaved = new AdministrationBAL().InsertSymptom(symptomId, txtSymptom.Text, txtDescription.Text);
            if (IsSaved < 0)
                ShowAlertMessage("Entered Symptom is already exists!");
            else
            {
                ShowAlertMessage("New Symptom Saved successfully!");
            }
        }
        BindSymptom(false);
    }

        protected void RadGrid1_OnItemCommand(object sender, GridCommandEventArgs e)
        {
            try
            {
                GridDataItem item = (GridDataItem)e.Item;
                string id = item["colId"].Text;
                switch (e.CommandName)
                {
                    case "btnSelect":
                        Response.Redirect("CompanyInfo.aspx?id=" + id, true);
                        break;
                    case "btnDelete":
                        int delete = new Company().DeleteCompanyByCompanyId(int.Parse(id));
                        long addressid = GetAddressID(int.Parse(id));
                        int deleteAddress = new Addresses().DeleteAddressesByAddressId(addressid);
                        if (delete == 0)
                            Alert.Show("Data was not deleted");
                        else
                        {
                            this.LoadCompanyListTable();
                        }
                        break;

                }
            }
            catch (Exception ex)
            {
                Alert.Show(ex.Message);
            }
        }

        protected void rgSchools_UpdateCommand(Object source, GridCommandEventArgs e)
        {
            var editedItem = e.Item as GridEditableItem;

            if (editedItem == null) return;

            //Get the new values:
            var newValues = new Hashtable();
            e.Item.OwnerTableView.ExtractValuesFromItem(newValues, editedItem);
            int id = DataIntegrity.ConvertToInt(editedItem.GetDataKeyValue("ID").ToString());
            string name = newValues["Name"] == null ? string.Empty : newValues["Name"].ToString();
            int? page = DataIntegrity.ConvertToNullableInt(newValues["Page"]);
            int district = DataIntegrity.ConvertToInt(newValues["District"]);
            string abbreviation = newValues["Abbreviation"] == null ? string.Empty : newValues["Abbreviation"].ToString();
            string phone = newValues["Phone"] == null ? string.Empty : newValues["Phone"].ToString();
            string cluster = newValues["Cluster"] == null ? string.Empty : newValues["Cluster"].ToString();
            string schoolType = newValues["SchoolType"] == null ? string.Empty : newValues["SchoolType"].ToString();
            string schoolId = newValues["SchoolID"] == null ? string.Empty : newValues["SchoolID"].ToString();
            string portalFlag = newValues["PortalFlag"] == null ? string.Empty : newValues["PortalFlag"].ToString();

            if (id < 1) return;

            ThinkgateSchool school = new ThinkgateSchool(id, name, page, district, abbreviation, phone, cluster, schoolType, schoolId, portalFlag);

            school.UpdateSchool();
            LoadSchools();

        }

 /// <summary>
 /// 删除事件
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 protected void GridUser_DeleteCommand(object sender, GridCommandEventArgs e)
 {
     //获取Grid的主键值
     string GridKey = e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["UserID"].ToString();
     UserBLL UserBLLs = new UserBLL();
     string strGetuserID = HttpContext.Current.User.Identity.Name;
     if (strGetuserID == GridKey)
     {
         //当前用户不能删除！ 警告
         string strInfo = GetGlobalResourceObject("en_US", "UserManagerForm_lblDesc_DeleteInfo").ToString();
         RadWindowManager1.RadAlert(strInfo, 300, 100, "Warn", "");
         return;
     }
     if (GridKey != string.Empty)
     {
         tblUser UserObjs;
         UserObjs = UserBLLs.GetByID(GridKey);
         if (UserObjs.UserName == "admin")
         {
             //管理员不能删除！ 警告Admin Can't delete!
             string strInfo = GetGlobalResourceObject("en_US", "UserManagerForm_lblDesc_DeleteInfoAdmin").ToString();
             RadWindowManager1.RadAlert(strInfo, 300, 100, "Warn", "");
             return;
         }
         UserBLLs.Delete(GridKey);
         RoleUserBLL Role_UserBLLs = new RoleUserBLL();
         //删除关系表
         Role_UserBLLs.Delete(GridKey);
     }
     this.GridViewData();
 }