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 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 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(); } }
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_ItemCommand(object sender, GridCommandEventArgs e) { foreach (GridItem Item in RadGrid1.Items) { } }
protected void RadGrid1_InsertCommand(object source, GridCommandEventArgs e) { var editableItem = ((GridEditableItem)e.Item); Hashtable values = new Hashtable(); editableItem.ExtractValues(values); try { var roleName = values["RoleName"] as string; if (roleName == null || string.IsNullOrEmpty(roleName.Trim())) { ShowErrorMessage(Pharma.Administrator_Default_RadGrid1_InsertCommand_Please_provide_role_name_to_add); e.Canceled = true; } else { var result = repo.Add(roleName.Trim()); if(!result) { ShowErrorMessage("Role name must be unique, please try again with the another name"); e.Canceled = true; } } } catch (System.Exception) { ShowErrorMessage(Pharma.Administrator_Default_RadGrid1_InsertCommand_can_not_add__please_try_again_later_or_contact_admnistrator_); e.Canceled = true; } }
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(); }
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_UpdateCommand(object source, GridCommandEventArgs e) { GridEditFormItem gdItem = (e.Item as GridEditFormItem); var editableItem = ((GridEditableItem)e.Item); Hashtable values = new Hashtable(); editableItem.ExtractValues(values); var id = (int)editableItem.GetDataKeyValue("Id"); try { var posName = values["PositionName"] as string; if (posName == null || string.IsNullOrEmpty(posName.Trim())) { ShowErrorMessage(Pharma.Please_provide_role_name_to_update); e.Canceled = true; } else { var result = repo.Edit(id, posName.Trim()); if (!result) { ShowErrorMessage("Position Name is unique, please choose another name."); e.Canceled = true; } } } catch (Exception ex) { ShowErrorMessage(ex.Message); e.Canceled = true; } }
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 _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); } } } }
/// <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 grdIndexFields_InsertCommand(object sender, GridCommandEventArgs e) { var editableItem = ((GridEditableItem)e.Item); //populate its properties Hashtable values = new Hashtable(); editableItem.ExtractValues(values); RadComboBox combo = editableItem.FindControl("ddlFormFields") as RadComboBox; string ffID = combo.SelectedValue; GRASPEntities db = new GRASPEntities(); //create new entity IndexField idx = new IndexField(); idx.FormFieldID = Convert.ToDecimal(ffID); idx.IndexID = Convert.ToInt32(grdIndex.SelectedValue.ToString()); db.IndexFields.Add(idx); try { //submit chanages to Db db.SaveChanges(); } catch(System.Exception ex) { SetMessage(ex.Message); } }
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 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; } } }
/// <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(); }
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 rGridAddress_DeleteCommand(object sender, GridCommandEventArgs e) { GridEditableItem eeditedItem = e.Item as GridEditableItem; int iAddrID = 0; iAddrID = Convert.ToInt32(eeditedItem.OwnerTableView.DataKeyValues[eeditedItem.ItemIndex]["AddrID"]); BLL.DeleteSampleAddress(iAddrID); }
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 rgValPermitido_InsertCommand(object sender, GridCommandEventArgs e) { UserControl uc = (UserControl)e.Item.FindControl(GridEditFormItem.EditFormUserControlID); int tipoValor = int.Parse(((RadDropDownList)uc.FindControl("ddlTipoValor")).SelectedValue.ToString()); string valor = ((RadTextBox)uc.FindControl("txtValor")).Text; string descripcion = ((RadTextBox)uc.FindControl("txtDescripcion")).Text; if (validarControl(tipoValor, valor, descripcion)) { Consulta c = new Consulta(); try { DatosEstructuraArchivo d = new DatosEstructuraArchivo(0, valor, descripcion); d.tipoValor = c.consultarTipoValorOBJ(tipoValor); d.estructuraArchivo = c.consultarEstructuraArchivo(this.ddlTipoArchivo.SelectedValue, int.Parse(this.ddlNumColumna.SelectedValue.ToString())); guardarDatos(d); } catch(Exception ex){ Logger.generarLogError(ex.Message, new System.Diagnostics.StackFrame(true), ex); this.RadWindowManager1.RadAlert(Utilities.errorMessage(), 400, 200, Utilities.windowTitle(TypeMessage.error_message), null, Utilities.pathImageMessage(TypeMessage.error_message)); e.Canceled = true; } } else { e.Canceled = true; } }
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 grdReviewList_ItemCommand(object sender, GridCommandEventArgs e) { DataTable a = GetDataInfo(); switch (e.CommandName) { case "DeleteRow": a.Rows.RemoveAt((e.Item).ItemIndex); rebindData(); break; case "EditRow": var row = a.Rows[(e.Item).ItemIndex]; if (CreditAccountForUpdate.Text != "" && CreditAccountForUpdate.Text == row["WorkingAccId"].ToString()) { return; } var accopen = new SavingAccountDAO().GetAccountOpenByTypeAndCustomerID("P", row["WorkingAccId"].ToString()); if (accopen!=null){ rcbCreditAccount.Items.Add(new RadComboBoxItem(accopen.Title,accopen.AccountCode) ); } rcbPaymentMethod.SelectedValue = row["PaymentMethod"].ToString(); tbCreditAmount.Value = Convert.ToDouble(row["CreditAmount"].ToString()); rcbCreditAccount.SelectedValue = row["WorkingAccId"].ToString(); CreditAccountForUpdate.Text = row["WorkingAccId"].ToString(); break; default: grdReviewList.DataSource = a; grdReviewList.Rebind(); break; } }
protected void gDoc_ItemCommand(object source, GridCommandEventArgs e) { //FileUpload fu = e.Item.FindControl("fuPath") as FileUpload; //HiddenField hf = e.Item.FindControl("hfPath") as HiddenField; //if (fu != null && fu.HasFile) // if (fu.PostedFile != null) // if (fu.PostedFile.ContentLength != 0) // { // try // { // String destDir = Server.MapPath("Docs"); // String fileName = Path.GetFileName(fu.PostedFile.FileName).Replace(' ', '_'); // String destPath = Path.Combine(destDir, fileName); // hf.Value = fileName; // fu.PostedFile.SaveAs(destPath); // } // catch (Exception err) // { // } // } }
protected void RGrid_SubSysCode_ItemCommand(object sender, GridCommandEventArgs e) { if (e.CommandName == "Del") { string subSysCodeId = Convert.ToString(e.CommandArgument); bool isDelete = false; Model.Log logModel = new Model.Log(); logModel.OperationItem = "删除子类"; logModel.Operator = user.UserInfo.UserID; logModel.OperationTime = DateTime.Now; try { Model.SysCodeDetail scdModel = new Model.SysCodeDetail(); logModel.OperationDetail = "子类编号:" + scdModel.SYSCodeDetialID + " - 子类内容:" + scdModel.SYSCodeDetialContext; isDelete = scd.Delete(subSysCodeId); if (isDelete) { logModel.Memo = "成功"; } else { logModel.Memo = "失败!"; } } catch (Exception ex) { logModel.Memo = "异常:" + ex.Message; } finally { log.Add(logModel); if (isDelete) { int delNo = -1; List<Model.SysCodeDetail> sysCodeDetailList = (List<Model.SysCodeDetail>)ViewState["SubSysCodeList"]; for(int i =0;i<sysCodeDetailList.Count;i++) { string tstr = sysCodeDetailList[i].SYSCodeDetialID; if (tstr.Equals(subSysCodeId)) { delNo = i; break; } } if (delNo != -1) { sysCodeDetailList.RemoveAt(delNo); } RGrid_SubSysCode.DataSource = sysCodeDetailList; RGrid_SubSysCode.DataBind(); RadScriptManager.RegisterStartupScript(Page, GetType(), "c1", "OpenAlert('恭喜!删除成功!');", true); } else { RadScriptManager.RegisterStartupScript(Page, GetType(), "c2", "OpenAlert('抱歉!删除失败!<br />请检查该小类是否存在未移除的关联!');", true); } } } }
protected void RadGrid1_UpdateCommand(object sender, GridCommandEventArgs e) { var item = e.Item as GridEditableItem; EntityKey = int.Parse(item.GetDataKeyValue(RadGridKey).ToString()); var values = new Hashtable(); item.ExtractValues(values); BLL.Users.Update(EntityKey, values); }
protected void radgridDevice_EditCommand(object sender, GridCommandEventArgs e) { }
protected void rgPersonal_UpdateCommand(object sender, GridCommandEventArgs e) { GrabarActualizar(sender, e, "Edit"); }
protected void GrdApprovedJobs_ItemCommand(object sender, GridCommandEventArgs e) { if (e.CommandName == "Select") { GridDataItem dataitem = e.Item as GridDataItem; string ReqID = dataitem["REQUEST_ID"].Text; OracleConnection conn = new OracleConnection(myConn); conn.Open(); try { OracleCommand cmd_change_management_validation = conn.CreateCommand(); cmd_change_management_validation.CommandText = "SELECT IT.REQUEST_ID, CM.IT_REQUEST_ID, CM.REQUEST_ID, IT.STATUS, IT.JOB_TYPE, IT.SYSTEM_TYPE, CM.STATUS " + "FROM WF_IT_REQUEST_REGISTER IT, WF_CM_REQUEST_REGISTER CM " + "WHERE IT.REQUEST_ID = CM.IT_REQUEST_ID AND IT.REQUEST_ID = '" + ReqID + "' AND IT.STATUS = 'APPROVE' "; OracleDataReader odr_get_matching_recored_count = cmd_change_management_validation.ExecuteReader(); DataTable dt_records = new DataTable(); dt_records.Load(odr_get_matching_recored_count); if (dt_records.Rows.Count != 0) { odr_get_matching_recored_count.Close(); conn.Clone(); Response.Redirect("~/Views/ITWorkflow/IT_WF_Dashboard_New.aspx?ecode=e_01", false); } else { odr_get_matching_recored_count.Close(); conn.Close(); Response.Redirect("~/Views/ChangeManagement/IntimateChange.aspx?ReqID=" + ReqID, false); } } catch (Exception ex) { throw ex; } } if (e.CommandName == "SelectID") { GridDataItem dataitem = e.Item as GridDataItem; string ReqID = dataitem["REQUEST_ID"].Text; Response.Redirect("HelpDeskView.aspx?ReqID=" + ReqID, false); OracleConnection conn = new OracleConnection(myConn); conn.Open(); try { OracleCommand cmd_change_management_validation = conn.CreateCommand(); cmd_change_management_validation.CommandText = "SELECT IT.REQUEST_ID, CM.IT_REQUEST_ID, CM.REQUEST_ID, IT.STATUS, IT.JOB_TYPE, IT.SYSTEM_TYPE, CM.STATUS " + "FROM WF_IT_REQUEST_REGISTER IT, WF_CM_REQUEST_REGISTER CM " + "WHERE IT.REQUEST_ID = CM.IT_REQUEST_ID AND IT.REQUEST_ID = '" + ReqID + "' AND IT.STATUS = 'APPROVE' "; OracleDataReader odr_get_matching_recored_count = cmd_change_management_validation.ExecuteReader(); DataTable dt_records = new DataTable(); dt_records.Load(odr_get_matching_recored_count); if (dt_records.Rows.Count != 0) { odr_get_matching_recored_count.Close(); conn.Clone(); Response.Redirect("~/Views/ITWorkflow/IT_WF_Dashboard_New.aspx?ecode=e_02", false); } else { Response.Redirect("~/Views/ITWorkflow/IT_WF_Dashboard_New.aspx?ecode=e_03", false); } } catch (Exception ex) { throw ex; } } }
protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e) { }
protected void RG_Skills_ItemCommand(object source, GridCommandEventArgs e) { try { if (Mode == 0) { if (e.CommandName == "Edit_Rec") { GridDataItem dtItem = (GridDataItem)e.Item; int index = dtItem.ItemIndex; Label lblID = new Label(); Label lblLastUsed = new Label(); Label lbl_ExpertID = new Label(); lblID = RG_Skills.Items[index].FindControl("lbl_Skill_ID") as Label; lblLastUsed = RG_Skills.Items[index].FindControl("lbl_Skill_LastUsed") as Label; lbl_ExpertID = RG_Skills.Items[index].FindControl("lbl_Skill_Exp_ID") as Label; rcb_Skill.SelectedIndex = rcb_Skill.FindItemIndexByValue(lblID.Text); rcb_YearLastUsed.SelectedIndex = rcb_YearLastUsed.FindItemIndexByText(lblLastUsed.Text); //rcb_ExpertLevel.SelectedItem.Text = Convert.ToString(lbl_ExpertID.Text).Trim(); rcb_ExpertLevel.SelectedIndex = Convert.ToInt32(lbl_ExpertID.Text); btn_Skill_Add.Visible = false; if (Convert.ToInt32(Session["WRITEFACILITY"]) == 2) { btn_Skill_Correct.Visible = false; } else { btn_Skill_Correct.Visible = true; } rcb_Skill.Enabled = false; Mode = 1; } } else { if (e.CommandName == "Edit_Rec") { GridDataItem dtItem = (GridDataItem)e.Item; int index = dtItem.ItemIndex; Label lbl_ID = new Label(); Label lblID = new Label(); Label lbl_ExpertID = new Label(); Label lblLastUsed = new Label(); lbl_ID = RG_Skills.Items[index].FindControl("lblID") as Label; lblID = RG_Skills.Items[index].FindControl("lbl_Skill_ID") as Label; lblLastUsed = RG_Skills.Items[index].FindControl("lbl_Skill_LastUsed") as Label; lbl_ExpertID = RG_Skills.Items[index].FindControl("lbl_Skill_Exp_ID") as Label; rcb_Skill.SelectedIndex = rcb_Skill.FindItemIndexByValue(lblID.Text); rcb_YearLastUsed.SelectedIndex = rcb_YearLastUsed.FindItemIndexByText(lblLastUsed.Text); rcb_ExpertLevel.SelectedValue = Convert.ToString(lbl_ExpertID.Text).Trim(); _lbl_ID = lbl_ID.Text; btn_Skill_Add.Visible = false; if (Convert.ToInt32(Session["WRITEFACILITY"]) == 2) { btn_Skill_Correct.Visible = false; } else { btn_Skill_Correct.Visible = true; } rcb_Skill.Enabled = false; Mode = 2; } } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frmEmpSkills", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e) { //RadGrid2.SelectedIndexes.Clear(); }
protected void RadOtherVaccine_EditCommand(object sender, GridCommandEventArgs e) { //GetImmunisationDetaisOther(); RadOtherVaccine.DataSource = (DataTable)ViewState["TblImmunisation"]; RadOtherVaccine.DataBind(); }
protected void OnItemCommand(object sender, GridCommandEventArgs e) { if (e.CommandName == "RowClick") { } }
protected void RadGrid1_InsertCommand(object source, GridCommandEventArgs e) { try { GridEditableItem editedItem = e.Item as GridEditableItem; GridEditManager editMan = editedItem.EditManager; int i = 2; int j = 0; dt = (DataTable)Session[SessionContents.FPS_AddProspect_DataTable]; dr = dt.NewRow(); foreach (GridColumn column in e.Item.OwnerTableView.RenderColumns) { if (column is IGridEditableColumn) { IGridEditableColumn editableCol = (column as IGridEditableColumn); if (editableCol.IsEditable) { IGridColumnEditor editor = editMan.GetColumnEditor(editableCol); string editorType = editor.ToString(); string editorText = "unknown"; object editorValue = null; if (editor is GridTextColumnEditor) { editorText = (editor as GridTextColumnEditor).Text; editorValue = (editor as GridTextColumnEditor).Text; } if (editor is GridBoolColumnEditor) { editorText = (editor as GridBoolColumnEditor).Value.ToString(); editorValue = (editor as GridBoolColumnEditor).Value; } if (editor is GridDropDownColumnEditor) { editorText = (editor as GridDropDownColumnEditor).SelectedValue; editorValue = (editor as GridDropDownColumnEditor).SelectedValue; } if (editor is GridTemplateColumnEditor) { if (i != 3) { TextBox txt = (TextBox)e.Item.FindControl("txtIPName"); editorText = txt.Text; editorValue = txt.Text; } else if (i == 3) { TextBox txt = (TextBox)e.Item.FindControl("txtIPComments"); editorText = txt.Text; editorValue = txt.Text; } } try { dr[i] = editorText; } catch (Exception ex) { RadGrid1.Controls.Add(new LiteralControl("<strong>Unable to set value of column '" + column.UniqueName + "'</strong> - " + ex.Message)); e.Canceled = true; break; } } i++; } } if (dr.ItemArray[2].ToString() != "") { dt.Rows.Add(dr); Session[SessionContents.FPS_AddProspect_DataTable] = dt; Rebind(false); } else { ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "Message", "javascript:ValidateIPTextBox();", true); } } catch (Exception ex) { e.Canceled = true; throw ex; } }
protected void rgPersonal_InsertCommand(object sender, GridCommandEventArgs e) { GrabarActualizar(sender, e, "add"); }
/// <summary> /// 添加权限 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void RG_Power_InsertCommand(object sender, GridCommandEventArgs e) { var editedItem = e.Item as GridEditableItem; var info = new CompanyInvoicePowerInfo(); Guid parentPowerID = Guid.NewGuid(); info.PowerID = parentPowerID; if (editedItem != null) { info.FilialeID = new Guid(((DropDownList)editedItem.FindControl("DDL_Filiale")).SelectedValue); info.BranchID = new Guid(((DropDownList)editedItem.FindControl("DDL_Branch")).SelectedValue); info.PositionID = new Guid(((DropDownList)editedItem.FindControl("DDL_Position")).SelectedValue); info.AuditorID = new Guid(((DropDownList)editedItem.FindControl("DDL_Personnel")).SelectedValue); info.InvoicesType = int.Parse(((DropDownList)editedItem.FindControl("DDL_InvoiceType")).SelectedValue); } info.BindingType = (int)CompanyFundReceiptPowerBindType.DirectBind; info.CompanyID = CompanyID; info.ParentPowerID = Guid.Empty; try { _companyInvoicePower.InsertCompanyInvoicePower(info); CompanyClassInfo companyClassInfo = _companyClass.GetCompanyClass(CompanyID); if (companyClassInfo.CompanyClassId != Guid.Empty) { IList <CompanyClassInfo> classList = _companyClass.GetChildCompanyClassList(CompanyID).ToList(); if (classList.Count > 0) { foreach (CompanyClassInfo cInfo in classList) { info.PowerID = Guid.NewGuid(); info.BindingType = (int)CompanyFundReceiptPowerBindType.ExpandBind; info.CompanyID = cInfo.CompanyClassId; info.ParentPowerID = parentPowerID; _companyInvoicePower.InsertCompanyInvoicePower(info); IList <CompanyCussentInfo> cussentList = _companyCussent.GetCompanyCussentList(cInfo.CompanyClassId).ToList(); if (cussentList.Count > 0) { foreach (CompanyCussentInfo cussentInfo in cussentList) { info.PowerID = Guid.NewGuid(); info.BindingType = (int)CompanyFundReceiptPowerBindType.ExpandBind; info.CompanyID = cussentInfo.CompanyId; info.ParentPowerID = parentPowerID; _companyInvoicePower.InsertCompanyInvoicePower(info); } } } } else { IList <CompanyCussentInfo> cussentList = _companyCussent.GetCompanyCussentList(CompanyID).ToList(); if (cussentList.Count > 0) { foreach (CompanyCussentInfo cussentInfo in cussentList) { info.PowerID = Guid.NewGuid(); info.BindingType = (int)CompanyFundReceiptPowerBindType.ExpandBind; info.CompanyID = cussentInfo.CompanyId; info.ParentPowerID = parentPowerID; _companyInvoicePower.InsertCompanyInvoicePower(info); } } } } RG_Power.Rebind(); } catch (Exception ex) { RAM.Alert("权限添加失败!" + ex); } }
protected void RadGrid1_UpdateCommand(object source, GridCommandEventArgs e) { GridEditableItem editedItem = e.Item as GridEditableItem; string ch_label = null; Int32 ch_status_int; Int32 ch_type_int; string enb_ind_str; string int_ind_str; decimal area_id_dec; string displayname = User.Identity.Name; Int32 trolley_type_int; decimal Chuteid = decimal.Parse(editedItem.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["chute_id"].ToString()); RadTextBox chlabel = (RadTextBox)editedItem.FindControl("ch_label_TextBox"); ch_label = chlabel.Text.ToString(); //RadComboBox chstatus = (RadComboBox)editedItem.FindControl("ch_status_RadComboBox"); RadComboBox chtype = (RadComboBox)editedItem.FindControl("ch_type_RadComboBox"); RadComboBox enbind = (RadComboBox)editedItem.FindControl("ch_enb_ind_RadComboBox"); //RadComboBox intind = (RadComboBox)editedItem.FindControl("ch_int_ind_RadComboBox"); RadComboBox areaid = (RadComboBox)editedItem.FindControl("ch_area_RadComboBox"); RadComboBox trolleytype = (RadComboBox)editedItem.FindControl("trolleytype_RadComboBox"); //ch_status_int = Int32.Parse(chstatus.SelectedValue); ch_status_int = 3; ch_type_int = Int32.Parse(chtype.SelectedValue); enb_ind_str = enbind.SelectedValue.ToString(); //int_ind_str = intind.SelectedValue.ToString(); area_id_dec = decimal.Parse(areaid.SelectedValue); if (ch_type_int == 2)//multi chute { trolley_type_int = Int32.Parse(trolleytype.SelectedValue); } else { trolley_type_int = 0; } ChuteDAO chuteinsert = new ChuteDAO(); try { decimal chuteid = chuteinsert.Update_Chute(Chuteid, ch_label, ch_status_int, ch_type_int, enb_ind_str, area_id_dec, displayname, trolley_type_int); if (chuteid == 0) { // display error string err_msg = "Error while updating Chute ID: " + Chuteid; HandleError(err_msg, 1); } else if (chuteid == -1) { string err_msg = "Area in Use. Cannot update Chute"; HandleError(err_msg, 1); } else { HandleError("Chute Updated", 0); } } catch (Exception ex_upd) { string err = ex_upd.Message; HandleError(err, 1); } BindData(); }
//添加属性 protected void FieldGrid_InsertCommand(object sender, GridCommandEventArgs e) { var editedItem = (GridEditableItem)e.Item; var fieldId = Guid.NewGuid(); Guid parentfieldId; string fieldName; string fieldValue; FieldInfo fieldInfo; switch (editedItem.OwnerTableView.DataMember) { case "TopField": { parentfieldId = Guid.Empty; fieldName = ((TextBox)editedItem.FindControl("TB_FieldName")).Text; fieldValue = ((TextBox)editedItem.FindControl("TB_FieldValue")).Text; try { fieldInfo = new FieldInfo { FieldId = fieldId, ParentFieldId = parentfieldId, FieldName = fieldName, FieldValue = fieldValue }; string errorMessage; var result = _goodsFieldSao.AddField(fieldInfo, out errorMessage); if (result) { //商品属性添加操作记录添加 var personnelInfo = CurrentSession.Personnel.Get(); WebControl.AddOperationLog(personnelInfo.PersonnelId, personnelInfo.RealName, fieldId, "", OperationPoint.GoodsAttributeManager.Add.GetBusinessInfo(), string.Empty); //WebControl.AddCommodityAttributeOperation(HRS.Enum.OperationTypePoint.OperationLogTypeEnum.CommodityAttribute, CurrentSession.Personnel.Get().PersonnelId, fieldId, fieldName + fieldValue, HRS.Enum.OperationTypePoint.CommodityAttributeState.AddAttribute, string.Empty); FieldGrid.Rebind(); } else { RAM.Alert("操作无效!" + errorMessage); } } catch { RAM.Alert("商品属性信息添加失败!"); } } break; case "CombField": { GridDataItem parentItem = editedItem.OwnerTableView.ParentItem; parentfieldId = new Guid(parentItem.GetDataKeyValue("FieldId").ToString()); fieldName = ((Label)parentItem.FindControl("LB_FieldName")).Text; fieldValue = ((TextBox)editedItem.FindControl("TB_FieldValue")).Text; try { fieldInfo = new FieldInfo { FieldId = fieldId, ParentFieldId = parentfieldId, FieldName = fieldName, FieldValue = fieldValue }; string errorMessage; var result = _goodsFieldSao.AddField(fieldInfo, out errorMessage); if (result) { //商品属性添加操作记录添加 var personnelInfo = CurrentSession.Personnel.Get(); WebControl.AddOperationLog(personnelInfo.PersonnelId, personnelInfo.RealName, fieldId, "", OperationPoint.GoodsAttributeManager.Add.GetBusinessInfo(), string.Empty); //WebControl.AddCommodityAttributeOperation(HRS.Enum.OperationTypePoint.OperationLogTypeEnum.CommodityAttribute, CurrentSession.Personnel.Get().PersonnelId, fieldId, fieldName + fieldValue, HRS.Enum.OperationTypePoint.CommodityAttributeState.AddAttribute, string.Empty); editedItem.OwnerTableView.Rebind(); } else { RAM.Alert("操作无效!" + errorMessage); } } catch { RAM.Alert("商品属性信息添加失败!"); } } break; } }
protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e) { if (e.CommandName == "QuickUpdate") { string ProjectCategoryID, IsShowOnMenu, IsShowOnHomePage, IsAvailable; var oProjectCategory = new ProjectCategory(); foreach (GridDataItem item in RadGrid1.Items) { ProjectCategoryID = item.GetDataKeyValue("ProjectCategoryID").ToString(); IsShowOnMenu = ((CheckBox)item.FindControl("chkIsShowOnMenu")).Checked.ToString(); IsShowOnHomePage = ((CheckBox)item.FindControl("chkIsShowOnHomePage")).Checked.ToString(); IsAvailable = ((CheckBox)item.FindControl("chkIsAvailable")).Checked.ToString(); oProjectCategory.ProjectCategoryQuickUpdate( ProjectCategoryID, IsShowOnMenu, IsShowOnHomePage, IsAvailable ); } } else if (e.CommandName == "DeleteSelected") { var oProjectCategory = new ProjectCategory(); var errorList = ""; foreach (GridDataItem item in RadGrid1.SelectedItems) { var isChildCategoryExist = oProjectCategory.ProjectCategoryIsChildrenExist(item.GetDataKeyValue("ProjectCategoryID").ToString()); var ProjectCategoryName = ((Label)item.FindControl("lblProjectCategoryName")).Text; var ProjectCategoryNameEn = ((Label)item.FindControl("lblProjectCategoryNameEn")).Text; if (isChildCategoryExist) { errorList += ", " + ProjectCategoryName; } else { string strImageName = ((HiddenField)item.FindControl("hdnImageName")).Value; if (!string.IsNullOrEmpty(strImageName)) { string strSavePath = Server.MapPath("~/res/projectcategory/" + strImageName); if (File.Exists(strSavePath)) { File.Delete(strSavePath); } } } } if (!string.IsNullOrEmpty(errorList)) { e.Canceled = true; string strAlertMessage = "Danh mục <b>\"" + errorList.Remove(0, 1).Trim() + "\"</b> đang có danh mục con hoặc sản phẩm.<br /> Xin xóa danh mục con hoặc sản phẩm trong danh mục này hoặc thiết lập hiển thị = \"không\"."; lblError.Text = strAlertMessage; } } else if (e.CommandName == "PerformInsert" || e.CommandName == "Update") { var command = e.CommandName; var row = command == "PerformInsert" ? (GridEditFormInsertItem)e.Item : (GridEditFormItem)e.Item; var FileImageName = (RadUpload)row.FindControl("FileImageName"); string strProjectCategoryName = ((RadTextBox)row.FindControl("txtProjectCategoryName")).Text.Trim(); string strProjectCategoryNameEn = ((RadTextBox)row.FindControl("txtProjectCategoryNameEn")).Text.Trim(); string strProjectCategoryLink = ((RadTextBox)row.FindControl("txtProjectCategoryLink")).Text.Trim(); string strProjectCategoryLinkEn = ((RadTextBox)row.FindControl("txtProjectCategoryLinkEn")).Text.Trim(); string strConvertedProjectCategoryName = Common.ConvertTitle(strProjectCategoryName); string strDescription = HttpUtility.HtmlDecode(FCKEditorFix.Fix(((RadEditor)row.FindControl("txtDescription")).Content.Trim())); string strDescriptionEn = HttpUtility.HtmlDecode(FCKEditorFix.Fix(((RadEditor)row.FindControl("txtDescriptionEn")).Content.Trim())); string strContent = HttpUtility.HtmlDecode(FCKEditorFix.Fix(((RadEditor)row.FindControl("txtContent")).Content.Trim())); string strContentEn = HttpUtility.HtmlDecode(FCKEditorFix.Fix(((RadEditor)row.FindControl("txtContentEn")).Content.Trim())); string strMetaTitle = ((RadTextBox)row.FindControl("txtMetaTitle")).Text.Trim(); string strMetaTitleEn = ((RadTextBox)row.FindControl("txtMetaTitleEn")).Text.Trim(); string strMetaDescription = ((RadTextBox)row.FindControl("txtMetaDescription")).Text.Trim(); string strMetaDescriptionEn = ((RadTextBox)row.FindControl("txtMetaDescriptionEn")).Text.Trim(); string strImageName = FileImageName.UploadedFiles.Count > 0 ? FileImageName.UploadedFiles[0].GetName() : ""; string strParentID = ((RadComboBox)row.FindControl("ddlParent")).SelectedValue; if ("".Equals(strParentID)) { strParentID = "17"; } string strIsAvailable = ((CheckBox)row.FindControl("chkIsAvailable")).Checked.ToString(); string strIsShowOnMenu = ((CheckBox)row.FindControl("chkIsShowOnMenu")).Checked.ToString(); string strIsShowOnHomePage = ((CheckBox)row.FindControl("chkIsShowOnHomePage")).Checked.ToString(); var oProjectCategory = new ProjectCategory(); if (e.CommandName == "PerformInsert") { strImageName = oProjectCategory.ProjectCategoryInsert( strProjectCategoryName, strProjectCategoryNameEn, strProjectCategoryLink, strProjectCategoryLinkEn, strConvertedProjectCategoryName, strDescription, strDescriptionEn, strContent, strContentEn, strMetaTitle, strMetaTitleEn, strMetaDescription, strMetaDescriptionEn, strImageName, strParentID, strIsShowOnMenu, strIsShowOnHomePage, strIsAvailable ); string strFullPath = "~/res/projectcategory/" + strImageName; if (!string.IsNullOrEmpty(strImageName)) { FileImageName.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath)); ResizeCropImage.ResizeByCondition(strFullPath, 40, 40); } RadGrid1.Rebind(); } else { var dsUpdateParam = ObjectDataSource1.UpdateParameters; var strProjectCategoryID = row.GetDataKeyValue("ProjectCategoryID").ToString(); var strOldImageName = ((HiddenField)row.FindControl("hdnImageName")).Value; var strOldImagePath = Server.MapPath("~/res/projectcategory/" + strOldImageName); dsUpdateParam["ProjectCategoryName"].DefaultValue = strProjectCategoryName; dsUpdateParam["ProjectCategoryNameEn"].DefaultValue = strProjectCategoryNameEn; dsUpdateParam["ProjectCategoryLink"].DefaultValue = strProjectCategoryLink; dsUpdateParam["ProjectCategoryLinkEn"].DefaultValue = strProjectCategoryLinkEn; dsUpdateParam["ConvertedProjectCategoryName"].DefaultValue = strConvertedProjectCategoryName; dsUpdateParam["Description"].DefaultValue = strDescription; dsUpdateParam["DescriptionEn"].DefaultValue = strDescriptionEn; dsUpdateParam["Content"].DefaultValue = strContent; dsUpdateParam["ContentEn"].DefaultValue = strContentEn; dsUpdateParam["ImageName"].DefaultValue = strImageName; dsUpdateParam["ParentID"].DefaultValue = strParentID; dsUpdateParam["IsShowOnMenu"].DefaultValue = strIsShowOnMenu; dsUpdateParam["IsShowOnHomePage"].DefaultValue = strIsShowOnHomePage; dsUpdateParam["IsAvailable"].DefaultValue = strIsAvailable; if (!string.IsNullOrEmpty(strImageName)) { var strFullPath = "~/res/projectcategory/" + strConvertedProjectCategoryName + "-" + strProjectCategoryID + strImageName.Substring(strImageName.LastIndexOf('.')); if (File.Exists(strOldImagePath)) { File.Delete(strOldImagePath); } FileImageName.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath)); ResizeCropImage.ResizeByCondition(strFullPath, 40, 40); } } } if (e.CommandName == "DeleteImage") { var oProjectCategory = new ProjectCategory(); var lnkDeleteImage = (LinkButton)e.CommandSource; var s = lnkDeleteImage.Attributes["rel"].ToString().Split('#'); var strProjectCategoryID = s[0]; var strImageName = s[1]; oProjectCategory.ProjectCategoryImageDelete(strProjectCategoryID); DeleteImage(strImageName); RadGrid1.Rebind(); } }
protected void rdgItemList_ItemCommand(object sender, GridCommandEventArgs e) { LoadItemList(); }
/// <summary> /// Grid1_RowCommand /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Grid1_RowCommand(object sender, GridCommandEventArgs e) { }
protected void gvReports_ItemCommand(object sender, GridCommandEventArgs e) { }
protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e) { if (e.CommandName == "alpha" || e.CommandName == "NoFilter") { String value = null; switch (e.CommandName) { case ("alpha"): { value = string.Format("{0}%", e.CommandArgument); break; } case ("NoFilter"): { value = "%"; break; } } ObjectDataSource1.SelectParameters["ProjectTitle"].DefaultValue = value; ObjectDataSource1.DataBind(); RadGrid1.Rebind(); } else if (e.CommandName == "QuickUpdate") { string ProjectID, Priority, IsHot, IsNew, IsShowOnHomePage, IsAvailable; var oProject = new Project(); foreach (GridDataItem item in RadGrid1.Items) { ProjectID = item.GetDataKeyValue("ProjectID").ToString(); Priority = ((RadNumericTextBox)item.FindControl("txtPriority")).Text.Trim(); IsHot = ((CheckBox)item.FindControl("chkIsHot")).Checked.ToString(); IsNew = ((CheckBox)item.FindControl("chkIsNew")).Checked.ToString(); IsShowOnHomePage = ((CheckBox)item.FindControl("chkIsShowOnHomePage")).Checked.ToString(); IsAvailable = ((CheckBox)item.FindControl("chkIsAvailable")).Checked.ToString(); oProject.ProjectQuickUpdate( ProjectID, IsHot, IsNew, IsShowOnHomePage, IsAvailable, Priority ); } } else if (e.CommandName == "DeleteSelected") { string OldImageName; var oProject = new Project(); string errorList = "", ProjectName = ""; foreach (GridDataItem item in RadGrid1.SelectedItems) { try { var ProjectID = item.GetDataKeyValue("ProjectID").ToString(); ProjectName = item["ProjectTitle"].Text; oProject.ProjectDelete(ProjectID); OldImageName = ((HiddenField)item.FindControl("hdnImageName")).Value; DeleteImage(OldImageName); } catch (Exception ex) { lblError.Text = ex.Message; if (ex.Message == ((int)ErrorNumber.ConstraintConflicted).ToString()) { errorList += ", " + ProjectName; } } } if (!string.IsNullOrEmpty(errorList)) { e.Canceled = true; string strAlertMessage = "Dự án <b>\"" + errorList.Remove(0, 1).Trim() + " \"</b> đang chứa thư viện ảnh, file download hoặc video .<br /> Xin xóa ảnh, file download hoặc video trong dự án này hoặc thiết lập hiển thị = \"không\"."; lblError.Text = strAlertMessage; } RadGrid1.Rebind(); } else if (e.CommandName == "PerformInsert" || e.CommandName == "Update") { var command = e.CommandName; var row = command == "PerformInsert" ? (GridEditFormInsertItem)e.Item : (GridEditFormItem)e.Item; var FileImageName = (RadUpload)row.FindControl("FileImageName"); string ProjectID = ((HiddenField)row.FindControl("hdnProjectID")).Value; string OldImageName = ((HiddenField)row.FindControl("hdnOldImageName")).Value; string ImageName = FileImageName.UploadedFiles.Count > 0 ? FileImageName.UploadedFiles[0].GetName() : ""; string Priority = ((RadNumericTextBox)row.FindControl("txtPriority")).Text.Trim(); string MetaTittle = ((TextBox)row.FindControl("txtMetaTittle")).Text.Trim(); string MetaDescription = ((TextBox)row.FindControl("txtMetaDescription")).Text.Trim(); string ProjectTitle = ((TextBox)row.FindControl("txtProjectTitle")).Text.Trim(); string ConvertedProjectTitle = Common.ConvertTitle(ProjectTitle); string Description = ((RadTextBox)row.FindControl("txtDescription")).Text.Trim(); //HttpUtility.HtmlDecode(FCKEditorFix.Fix(((RadEditor)row.FindControl("txtDescription")).Content.Trim())); string Content = HttpUtility.HtmlDecode(FCKEditorFix.Fix(((RadEditor)row.FindControl("txtContent")).Content.Trim())); string Tag = ((TextBox)row.FindControl("txtTag")).Text.Trim(); string ProjectCategoryID = ((RadComboBox)row.FindControl("ddlProjectCategory")).SelectedValue; if ("".Equals(ProjectCategoryID)) { ProjectCategoryID = "35"; } string IsHot = ((CheckBox)row.FindControl("chkIsHot")).Checked.ToString(); string IsNew = ((CheckBox)row.FindControl("chkIsNew")).Checked.ToString(); string IsShowOnHomePage = ((CheckBox)row.FindControl("chkIsShowOnHomePage")).Checked.ToString(); string IsAvailable = ((CheckBox)row.FindControl("chkIsAvailable")).Checked.ToString(); string MetaTittleEn = ((TextBox)row.FindControl("txtMetaTittleEn")).Text.Trim(); string MetaDescriptionEn = ((TextBox)row.FindControl("txtMetaDescriptionEn")).Text.Trim(); string ProjectTitleEn = ((TextBox)row.FindControl("txtProjectTitleEn")).Text.Trim(); string DescriptionEn = ((RadTextBox)row.FindControl("txtDescriptionEn")).Text.Trim(); //((RadEditor)row.FindControl("txtDescriptionEn")).Content.Trim(); string ContentEn = ((RadEditor)row.FindControl("txtContentEn")).Content.Trim(); string TagEn = ((TextBox)row.FindControl("txtTagEn")).Text.Trim(); if (e.CommandName == "PerformInsert") { var oProject = new Project(); ImageName = oProject.ProjectInsert( ImageName, MetaTittle, MetaDescription, ProjectTitle, ConvertedProjectTitle, Description, Content, Tag, MetaTittleEn, MetaDescriptionEn, ProjectTitleEn, DescriptionEn, ContentEn, TagEn, ProjectCategoryID, IsHot, IsNew, IsShowOnHomePage, IsAvailable, Priority ); string strFullPath = "~/res/project/" + ImageName; if (!string.IsNullOrEmpty(ImageName)) { FileImageName.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath)); ResizeCropImage.ResizeByCondition(strFullPath, 800, 800); ResizeCropImage.CreateThumbNailByCondition("~/res/project/", "~/res/project/thumbs/", ImageName, 120, 120); } RadGrid1.Rebind(); } else { var dsUpdateParam = ObjectDataSource1.UpdateParameters; var strOldImagePath = Server.MapPath("~/res/project/" + OldImageName); var strOldThumbImagePath = Server.MapPath("~/res/project/thumbs/" + OldImageName); dsUpdateParam["ConvertedProjectTitle"].DefaultValue = ConvertedProjectTitle; dsUpdateParam["ImageName"].DefaultValue = ImageName; dsUpdateParam["ProjectCategoryID"].DefaultValue = ProjectCategoryID; dsUpdateParam["IsHot"].DefaultValue = IsHot; dsUpdateParam["IsNew"].DefaultValue = IsNew; dsUpdateParam["IsShowOnHomePage"].DefaultValue = IsShowOnHomePage; dsUpdateParam["IsAvailable"].DefaultValue = IsAvailable; if (!string.IsNullOrEmpty(ImageName)) { if (File.Exists(strOldImagePath)) { File.Delete(strOldImagePath); } if (File.Exists(strOldThumbImagePath)) { File.Delete(strOldThumbImagePath); } ImageName = (string.IsNullOrEmpty(ConvertedProjectTitle) ? "" : ConvertedProjectTitle + "-") + ProjectID + ImageName.Substring(ImageName.LastIndexOf('.')); string strFullPath = "~/res/project/" + ImageName; FileImageName.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath)); ResizeCropImage.ResizeByCondition(strFullPath, 800, 800); ResizeCropImage.CreateThumbNailByCondition("~/res/project/", "~/res/project/thumbs/", ImageName, 120, 120); } } } if (e.CommandName == "DeleteImage") { var oProject = new Project(); var lnkDeleteImage = (LinkButton)e.CommandSource; var s = lnkDeleteImage.Attributes["rel"].ToString().Split('#'); var strProjectID = s[0]; var ImageName = s[1]; oProject.ProjectImageDelete(strProjectID); DeleteImage(ImageName); RadGrid1.Rebind(); } }
protected void gridCapturas_ItemCommand(object sender, GridCommandEventArgs e) { Int64?_idCampo = null; bool bit = true; if (e.CommandName == "pdfArchivos") { foreach (GridDataItem item in gridCapturas.MasterTableView.Items) { if (item.Selected == true) { _idCampo = convertir.toNInt64(item.GetDataKeyValue("Idlaboratorio")); loadarchivospdfs(_idCampo); bit = true; break; } } } if (e.CommandName == "editGrid") { foreach (GridDataItem item in gridCapturas.MasterTableView.Items) { if (item.Selected == true) { _idCampo = convertir.toNInt64(item.GetDataKeyValue("Idlaboratorio")); Session["getIdInstalacionGrid"] = _idCampo; Session["getTipoOp"] = 2; string script = "function f(){openRadWindow(); Sys.Application.remove_load(f);}Sys.Application.add_load(f);"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", script, true); bit = true; break; } } } if (e.CommandName == "delGrid") { foreach (GridDataItem item in gridCapturas.MasterTableView.Items) { if (item.Selected == true) { _idCampo = convertir.toNInt64(item.GetDataKeyValue("Idlaboratorio")); Session["getIdInstalacionGrid"] = _idCampo; string script = "function f(){callConfirm(); Sys.Application.remove_load(f);}Sys.Application.add_load(f);"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", script, true); bit = true; break; } } } if (e.CommandName == "addGrid") { if (Session["getIDInstalacion"] != null) { Session["getTipoOp"] = 1; string script = "function f(){openRadWindow(); Sys.Application.remove_load(f);}Sys.Application.add_load(f);"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", script, true); } else { windowManager1.RadAlert("Debe seleccionar la instalación del centro....", 300, 100, "Registros", null); } bit = true; } if (bit == false) { windowManager1.RadAlert("Debe seleccionar un registro....", 300, 100, "Registros", null); } }
protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e) { if (e.CommandName == "alpha" || e.CommandName == "NoFilter") { String value = null; switch (e.CommandName) { case ("alpha"): { value = string.Format("{0}%", e.CommandArgument); break; } case ("NoFilter"): { value = "%"; break; } } ObjectDataSource1.SelectParameters["ArticleTitle"].DefaultValue = value; ObjectDataSource1.DataBind(); RadGrid1.Rebind(); } else if (e.CommandName == "QuickUpdate") { string ArticleID, Priority, IsShowOnHomePage, IsHot, IsNew, IsAvailable; var oArticle = new Article(); foreach (GridDataItem item in RadGrid1.Items) { ArticleID = item.GetDataKeyValue("ArticleID").ToString(); Priority = ((RadNumericTextBox)item.FindControl("txtPriority")).Text.Trim(); IsShowOnHomePage = ((CheckBox)item.FindControl("chkIsShowOnHomePage")).Checked.ToString(); IsHot = ((CheckBox)item.FindControl("chkIsHot")).Checked.ToString(); IsNew = ((CheckBox)item.FindControl("chkIsNew")).Checked.ToString(); IsAvailable = ((CheckBox)item.FindControl("chkIsAvailable")).Checked.ToString(); oArticle.ArticleQuickUpdate( ArticleID, IsShowOnHomePage, IsHot, IsNew, IsAvailable, Priority ); } } else if (e.CommandName == "DeleteSelected") { string OldImageName; var oArticle = new Article(); foreach (GridDataItem item in RadGrid1.SelectedItems) { OldImageName = ((HiddenField)item.FindControl("hdnImageName")).Value; DeleteImage(OldImageName); } } else if (e.CommandName == "PerformInsert" || e.CommandName == "Update") { var command = e.CommandName; var row = command == "PerformInsert" ? (GridEditFormInsertItem)e.Item : (GridEditFormItem)e.Item; var FileImageName = (RadUpload)row.FindControl("FileImageName"); var oArticle = new Article(); string strArticleID = ((HiddenField)row.FindControl("hdnArticleID")).Value; string strOldImageName = ((HiddenField)row.FindControl("hdnOldImageName")).Value; string strImageName = FileImageName.UploadedFiles.Count > 0 ? FileImageName.UploadedFiles[0].GetName() : ""; string strPriority = ((RadNumericTextBox)row.FindControl("txtPriority")).Text.Trim(); string strMetaTittle = ((TextBox)row.FindControl("txtMetaTittle")).Text.Trim(); string strMetaDescription = ((TextBox)row.FindControl("txtMetaDescription")).Text.Trim(); string strArticleTitle = ((TextBox)row.FindControl("txtArticleTitle")).Text.Trim(); string strConvertedArticleTitle = Common.ConvertTitle(strArticleTitle); string strDescription = HttpUtility.HtmlDecode(FCKEditorFix.Fix(((RadEditor)row.FindControl("txtDescription")).Content.Trim())); string strContent = HttpUtility.HtmlDecode(FCKEditorFix.Fix(((RadEditor)row.FindControl("txtContent")).Content.Trim())); string strTag = ((TextBox)row.FindControl("txtTag")).Text.Trim(); string strArticleCategoryID = "8";// ((RadComboBox)row.FindControl("ddlCategory")).SelectedValue; string strIsShowOnHomePage = ((CheckBox)row.FindControl("chkIsShowOnHomePage")).Checked.ToString(); string strIsHot = ((CheckBox)row.FindControl("chkIsHot")).Checked.ToString(); string strIsNew = ((CheckBox)row.FindControl("chkIsNew")).Checked.ToString(); string strIsAvailable = ((CheckBox)row.FindControl("chkIsAvailable")).Checked.ToString(); string strMetaTittleEn = ((TextBox)row.FindControl("txtMetaTittleEn")).Text.Trim(); string strMetaDescriptionEn = ((TextBox)row.FindControl("txtMetaDescriptionEn")).Text.Trim(); string strArticleTitleEn = ((TextBox)row.FindControl("txtArticleTitleEn")).Text.Trim(); string strDescriptionEn = ((RadEditor)row.FindControl("txtDescriptionEn")).Content.Trim(); string strContentEn = ((RadEditor)row.FindControl("txtContentEn")).Content.Trim(); string strTagEn = ((TextBox)row.FindControl("txtTagEn")).Text.Trim(); if (e.CommandName == "PerformInsert") { strImageName = oArticle.ArticleInsert( strImageName, strMetaTittle, strMetaDescription, strArticleTitle, strConvertedArticleTitle, strDescription, strContent, strTag, strMetaTittleEn, strMetaDescriptionEn, strArticleTitleEn, strDescriptionEn, strContentEn, strTagEn, strArticleCategoryID, strIsShowOnHomePage, strIsHot, strIsNew, strIsAvailable, strPriority ); string strFullPath = "~/res/article/" + strImageName; if (!string.IsNullOrEmpty(strImageName)) { FileImageName.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath)); //ResizeCropImage.ResizeByCondition(strFullPath, 800, 800); ResizeCropImage.CreateThumbNailByCondition("~/res/article/", "~/res/article/thumbs/", strImageName, 120, 120); } RadGrid1.Rebind(); } else { var dsUpdateParam = ObjectDataSource1.UpdateParameters; var strOldImagePath = Server.MapPath("~/res/article/" + strOldImageName); var strOldThumbImagePath = Server.MapPath("~/res/article/thumbs/" + strOldImageName); dsUpdateParam["ArticleTitle"].DefaultValue = strArticleTitle; dsUpdateParam["ConvertedArticleTitle"].DefaultValue = strConvertedArticleTitle; dsUpdateParam["ImageName"].DefaultValue = strImageName; dsUpdateParam["ArticleCategoryID"].DefaultValue = strArticleCategoryID; dsUpdateParam["IsShowOnHomePage"].DefaultValue = strIsShowOnHomePage; dsUpdateParam["IsHot"].DefaultValue = strIsHot; dsUpdateParam["IsNew"].DefaultValue = strIsNew; dsUpdateParam["IsAvailable"].DefaultValue = strIsAvailable; if (!string.IsNullOrEmpty(strImageName)) { if (File.Exists(strOldImagePath)) { File.Delete(strOldImagePath); } if (File.Exists(strOldThumbImagePath)) { File.Delete(strOldThumbImagePath); } strImageName = (string.IsNullOrEmpty(strConvertedArticleTitle) ? "" : strConvertedArticleTitle + "-") + strArticleID + strImageName.Substring(strImageName.LastIndexOf('.')); string strFullPath = "~/res/article/" + strImageName; FileImageName.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath)); //ResizeCropImage.ResizeByCondition(strFullPath, 800, 800); ResizeCropImage.CreateThumbNailByCondition("~/res/article/", "~/res/article/thumbs/", strImageName, 120, 120); } } } if (e.CommandName == "DeleteImage") { var oArticle = new Article(); var lnkDeleteImage = (LinkButton)e.CommandSource; var s = lnkDeleteImage.Attributes["rel"].ToString().Split('#'); var strArticleID = s[0]; var strImageName = s[1]; oArticle.ArticleImageDelete(strArticleID); DeleteImage(strImageName); RadGrid1.Rebind(); } }
public bool SubmitRecord(object sender, GridCommandEventArgs e) { DayCarePL.Logger.Write(DayCarePL.LogType.INFO, DayCarePL.ModuleToLog.SchoolYear, "SubmitRecord", "Submit record method called", DayCarePL.Common.GUID_DEFAULT); Guid SchoolYearId = new Guid(); bool result = false; try { DayCarePL.Logger.Write(DayCarePL.LogType.DEBUG, DayCarePL.ModuleToLog.SchoolYear, "SubmitRecord", "Debug Submit Record Of SchoolYear", DayCarePL.Common.GUID_DEFAULT); DayCareBAL.SchoolYearService proxySchoolYear = new DayCareBAL.SchoolYearService(); DayCarePL.SchoolYearProperties objSchoolYear = new DayCarePL.SchoolYearProperties(); GridDataItem item = (GridDataItem)e.Item; var InsertItem = e.Item as Telerik.Web.UI.GridEditableItem; Telerik.Web.UI.GridEditManager editMan = InsertItem.EditManager; if (InsertItem != null) { foreach (GridColumn column in e.Item.OwnerTableView.RenderColumns) { if (column is GridEditableColumn) { IGridEditableColumn editTableColumn = (column as IGridEditableColumn); if (editTableColumn.IsEditable) { IGridColumnEditor editor = editMan.GetColumnEditor(editTableColumn); switch (column.UniqueName) { case "Year": { objSchoolYear.Year = (e.Item.FindControl("ddlYear") as DropDownList).SelectedValue; break; } case "StartDate": { objSchoolYear.StartDate = (e.Item.FindControl("rdpStartDate") as RadDatePicker).SelectedDate.Value; break; } case "EndDate": { if ((e.Item.FindControl("rdpEndDate") as RadDatePicker).SelectedDate != null) { objSchoolYear.EndDate = (e.Item.FindControl("rdpEndDate") as RadDatePicker).SelectedDate.Value; } else { objSchoolYear.EndDate = null; } break; } case "Comment": { objSchoolYear.Comments = (e.Item.FindControl("txtComment") as TextBox).Text; break; } case "CurrentId": { objSchoolYear.CurrentId = (editor as GridCheckBoxColumnEditor).Value; break; } } } } } if (objSchoolYear.EndDate != null) { if (objSchoolYear.StartDate > objSchoolYear.EndDate) { MasterAjaxManager = this.Page.Master.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager; MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", "Start Date must be less than End Date.", "false")); return(false); } } if (Session["SchoolId"] != null) { objSchoolYear.SchoolId = new Guid(Session["SchoolId"].ToString()); } if (e.CommandName != "PerformInsert") { if (Session["StaffId"] != null) { objSchoolYear.LastModifiedById = new Guid(Session["StaffId"].ToString()); } objSchoolYear.Id = new Guid(e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["Id"].ToString()); if (!objSchoolYear.Year.Trim().Equals(hdnName.Value.Trim())) { bool ans = proxySchoolYear.CheckDuplicateSchoolYear(objSchoolYear.Year, objSchoolYear.Id, objSchoolYear.SchoolId); if (ans) { MasterAjaxManager = this.Page.Master.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager; MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", "School Year Already Exist", "false")); return(false); } } } else { if (Session["StaffId"] != null) { objSchoolYear.CreatedById = new Guid(Session["StaffId"].ToString()); } bool ans = proxySchoolYear.CheckDuplicateSchoolYear(objSchoolYear.Year, objSchoolYear.Id, objSchoolYear.SchoolId); if (ans) { MasterAjaxManager = this.Page.Master.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager; MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", "School Year Already Exist", "false")); return(false); } } hdnName.Value = ""; SchoolYearId = proxySchoolYear.Save(objSchoolYear, new Guid(Session["CurrentSchoolYearId"].ToString())); if (!SchoolYearId.ToString().Equals(DayCarePL.Common.GUID_DEFAULT)) { MasterAjaxManager = this.Page.Master.FindControl("RadAjaxManager1") as Telerik.Web.UI.RadAjaxManager; MasterAjaxManager.ResponseScripts.Add(string.Format("ShowMessage('{0}','{1}')", "Saved Successfully", "false")); if (objSchoolYear.CurrentId == true) { Session["CurrentSchoolYearId"] = SchoolYearId; } result = true; Session["SchoolYearMessage"] = true; } else { result = false; } } } catch (Exception ex) { DayCarePL.Logger.Write(DayCarePL.LogType.EXCEPTION, DayCarePL.ModuleToLog.SchoolYear, "SubmitRecord", ex.Message.ToString(), DayCarePL.Common.GUID_DEFAULT); result = false; } return(result); }
protected void radgridDevice_InsertCommand(object sender, GridCommandEventArgs e) { GridEditFormInsertItem insertedItem = (GridEditFormInsertItem)e.Item; if (e.Item.OwnerTableView.Name == "Service") { Entities.User u = GetCurrentUser(); string s = e.Item.OwnerTableView.ParentItem.GetDataKeyValue("ID").ToString();;//e.Item.Parent.ite dsService.InsertParameters.Add(new Parameter("DeviceID", DbType.Int32, s)); dsService.InsertParameters.Add(new Parameter("TypeID", DbType.Int32, (insertedItem["ServiceType"].Controls[0] as RadComboBox).SelectedValue)); dsService.InsertParameters.Add(new Parameter("dateIn", DbType.DateTime, (insertedItem["DateInService"].Controls[0] as RadDatePicker).SelectedDate.ToString())); //Заменить текущим юзером dsService.InsertParameters.Add(new Parameter("userID", DbType.Int32, u.ID.ToString())); Parameter p = new Parameter(); p.Direction = ParameterDirection.Output; p.Name = "ID"; p.DbType = DbType.Int32; dsService.InsertParameters.Add(p); dsService.Insert(); radWM.RadAlert("Тип обслуживания был успешно добавлен.", 300, 200, "", "123"); } if (e.Item.OwnerTableView.Name == "Device") { dsDevices.InsertParameters.Add(new Parameter("fn", DbType.String, (insertedItem["FN"].Controls[0] as TextBox).Text)); dsDevices.InsertParameters.Add(new Parameter("title", DbType.String, (insertedItem["Title"].Controls[0] as TextBox).Text)); dsDevices.InsertParameters.Add(new Parameter("description", DbType.String, (insertedItem["Description"].Controls[0] as TextBox).Text)); dsDevices.InsertParameters.Add(new Parameter("typeid", DbType.Int32, (insertedItem["DeviceType"].Controls[0] as RadComboBox).SelectedValue)); Parameter p = new Parameter(); p.Direction = ParameterDirection.Output; p.Name = "ID"; p.DbType = DbType.Int32; dsDevices.InsertParameters.Add(p); dsDevices.Insert(); radWM.RadAlert("Устройство было успешно добавлено.", 300, 200, "", "123"); } if (e.Item.OwnerTableView.Name == "Works") { string s = e.Item.OwnerTableView.ParentItem.GetDataKeyValue("ID").ToString(); dsEventWork.InsertParameters["EventID"].DefaultValue = s; dsEventWork.InsertParameters["TypeWorkID"].DefaultValue = (insertedItem["WorkType"].Controls[0] as RadComboBox).SelectedValue; dsEventWork.Insert(); radWM.RadAlert("Вид работы \"" + (insertedItem["WorkType"].Controls[0] as RadComboBox).SelectedItem.Text + "\" был успешно добавлен.", 300, 200, "", "123"); } if (e.Item.OwnerTableView.Name == "WP") { //string s = e.Item.OwnerTableView.ParentItem.GetDataKeyValue("ID").ToString(); dsWP.InsertParameters.Add("LocationID", DbType.Int32, (insertedItem["WPLocation"].Controls[0] as RadComboBox).SelectedValue); dsWP.InsertParameters.Add("Title", DbType.String, (insertedItem["Title"].Controls[0] as TextBox).Text); dsWP.InsertParameters.Add("LF", DbType.Double, (insertedItem["LineFirst"].Controls[0] as TextBox).Text); dsWP.InsertParameters.Add("LS", DbType.Double, (insertedItem["LineSecond"].Controls[0] as TextBox).Text); dsWP.InsertParameters.Add("D", DbType.Int32, (insertedItem["D"].Controls[0] as TextBox).Text); dsWP.InsertParameters.Add("DCalc", DbType.Int32, (insertedItem["DCalc"].Controls[0] as TextBox).Text); dsWP.InsertParameters.Add("Qmin", DbType.Int32, (insertedItem["QMin"].Controls[0] as TextBox).Text); dsWP.InsertParameters.Add("Qmax", DbType.Int32, (insertedItem["QMax"].Controls[0] as TextBox).Text); dsWP.InsertParameters.Add("Comment", DbType.String, (insertedItem["Comment"].Controls[0] as TextBox).Text); dsWP.InsertParameters.Add("TypeID", DbType.Int32, (insertedItem["WPType"].Controls[0] as RadComboBox).SelectedValue); dsWP.InsertParameters.Add("StartDate", DbType.DateTime, (insertedItem["StartDate"].Controls[0] as RadDatePicker).SelectedDate.ToString()); dsWP.Insert(); radWM.RadAlert("Водоузел был успешно добавлен.", 300, 200, "", "123"); } if (e.Item.OwnerTableView.Name == "Device") { dsDevices.InsertParameters.Add(new Parameter("fn", DbType.String, (insertedItem["FN"].Controls[0] as TextBox).Text)); dsDevices.InsertParameters.Add(new Parameter("title", DbType.String, (insertedItem["Title"].Controls[0] as TextBox).Text)); dsDevices.InsertParameters.Add(new Parameter("description", DbType.String, (insertedItem["Description"].Controls[0] as TextBox).Text)); dsDevices.InsertParameters.Add(new Parameter("typeid", DbType.Int32, (insertedItem["DeviceType"].Controls[0] as RadComboBox).SelectedValue)); dsDevices.Insert(); radWM.RadAlert("Устройство было успешно добавлено.", 300, 200, "", "123"); } if (e.Item.OwnerTableView.Name == "Event") { Entities.User u = GetCurrentUser(); string s = e.Item.OwnerTableView.ParentItem.GetDataKeyValue("ID").ToString();;//e.Item.Parent.ite dsEvents.InsertParameters["WPID"].DefaultValue = s; dsEvents.InsertParameters["WPTypeEventID"].DefaultValue = (insertedItem["EventType"].Controls[0] as RadComboBox).SelectedValue; dsEvents.InsertParameters["WPEventSourceTypeID"].DefaultValue = (insertedItem["EventSource"].Controls[0] as RadComboBox).SelectedValue; dsEvents.InsertParameters["DateIn"].DefaultValue = (insertedItem["DateInService"].Controls[0] as RadDatePicker).SelectedDate.ToString(); dsEvents.InsertParameters["UserID"].DefaultValue = u.ID.ToString(); dsEvents.Insert(); e.Item.Edit = false; radWM.RadAlert("Выезд был успешно добавлен.", 300, 200, "", "123"); //radgrid.Rebind(); } e.Item.Edit = false; e.Canceled = false; //radgridDevice.Rebind(); }
protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e) { if (e.CommandName == "alpha" || e.CommandName == "NoFilter") { String value = null; switch (e.CommandName) { case ("alpha"): { value = string.Format("{0}%", e.CommandArgument); break; } case ("NoFilter"): { value = "%"; break; } } ObjectDataSource1.SelectParameters["CompanyName"].DefaultValue = value; ObjectDataSource1.DataBind(); RadGrid1.Rebind(); } else if (e.CommandName == "QuickUpdate") { string AdsBannerID, Priority, IsAvailable; var oAdsBanner = new AdsBanner(); foreach (GridDataItem item in RadGrid1.Items) { AdsBannerID = item.GetDataKeyValue("AdsBannerID").ToString(); Priority = ((RadNumericTextBox)item.FindControl("txtPriority")).Text.Trim(); IsAvailable = ((CheckBox)item.FindControl("chkIsAvailable")).Checked.ToString(); oAdsBanner.AdsBannerQuickUpdate( AdsBannerID, Priority, IsAvailable ); } } else if (e.CommandName == "DeleteSelected") { var oAdsBanner = new AdsBanner(); foreach (GridDataItem item in RadGrid1.SelectedItems) { string strFileName = ((HiddenField)item.FindControl("hdnFileName")).Value; if (!string.IsNullOrEmpty(strFileName)) { string strSavePath = Server.MapPath("~/res/advertisement/" + strFileName); if (File.Exists(strSavePath)) { File.Delete(strSavePath); } } } } else if (e.CommandName == "PerformInsert" || e.CommandName == "Update") { var command = e.CommandName; var row = command == "PerformInsert" ? (GridEditFormInsertItem)e.Item : (GridEditFormItem)e.Item; var FileFileName = (RadUpload)row.FindControl("FileFileName"); var dpFromDate = (RadDatePicker)row.FindControl("dpFromDate"); var dpToDate = (RadDatePicker)row.FindControl("dpToDate"); string strCompanyName = HttpUtility.HtmlDecode(FCKEditorFix.Fix(((RadEditor)row.FindControl("txtCompanyName")).Content.Trim()));//((TextBox)row.FindControl("txtCompanyName")).Text.Trim(); //string strTitle = ((TextBox)row.FindControl("txtTitle")).Text.Trim(); //string strDescription = ((TextBox)row.FindControl("txtDescription")).Text.Trim(); string strConvertedAdsBannerName = Common.ConvertTitle(strCompanyName); string strFileName = FileFileName.UploadedFiles.Count > 0 ? FileFileName.UploadedFiles[0].GetName() : ""; string strIsAvailable = ((CheckBox)row.FindControl("chkIsAvailable")).Checked.ToString(); string strPriority = ((RadNumericTextBox)row.FindControl("txtPriority")).Text.Trim(); string strFromDate = dpFromDate.SelectedDate.HasValue ? dpFromDate.SelectedDate.Value.ToString("MM/dd/yyyy") : ""; string strToDate = dpToDate.SelectedDate.HasValue ? dpToDate.SelectedDate.Value.ToString("MM/dd/yyyy") : ""; string strAdsCategoryID = "11";// ((RadComboBox)row.FindControl("ddlCategory")).SelectedValue; string strWebsite = ((TextBox)row.FindControl("txtWebsite")).Text.Trim(); double ratio = 0; if (!string.IsNullOrEmpty(strFileName)) { string strTempPath = Server.MapPath(FileFileName.TargetFolder + strFileName); if (IsImageFormat(strFileName)) { System.Drawing.Image img = System.Drawing.Image.FromFile(strTempPath); ratio = (double)img.Width / (img.Height == 0 ? 1 : img.Height); img.Dispose(); } else { SwfParser swfParser = new SwfParser(); Rectangle rectangle = swfParser.GetDimensions(strTempPath); ratio = (double)rectangle.Width / (rectangle.Height == 0 ? 1 : rectangle.Height); } string[] files = Directory.GetFiles(Server.MapPath(FileFileName.TargetFolder)); foreach (string filePath in files) { File.Delete(filePath); } } var oAdsBanner = new AdsBanner(); if (e.CommandName == "PerformInsert") { strFileName = oAdsBanner.AdsBannerInsert( strFileName, strConvertedAdsBannerName, strAdsCategoryID, strCompanyName, strWebsite, strFromDate, strToDate, strPriority, strIsAvailable, ratio == 0 ? "" : ratio.ToString().Replace(',', '.') ); string strFullPath = "~/res/advertisement/" + strFileName; if (!string.IsNullOrEmpty(strFileName)) { FileFileName.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath)); if (IsImageFormat(strFileName)) { //ResizeCropImage.ResizeByCondition(strFullPath, 800, 800); } } RadGrid1.Rebind(); } else { var dsUpdateParam = ObjectDataSource1.UpdateParameters; var strAdsBannerID = row.GetDataKeyValue("AdsBannerID").ToString(); var strOldFileName = ((HiddenField)row.FindControl("hdnFileName")).Value; var strOldImagePath = Server.MapPath("~/res/advertisement/" + strOldFileName); dsUpdateParam["FileName"].DefaultValue = strFileName; dsUpdateParam["ConvertedAdsBannerName"].DefaultValue = strConvertedAdsBannerName; dsUpdateParam["AdsCategoryID"].DefaultValue = strAdsCategoryID; dsUpdateParam["FromDate"].DefaultValue = strFromDate; dsUpdateParam["ToDate"].DefaultValue = strToDate; dsUpdateParam["IsAvailable"].DefaultValue = strIsAvailable; dsUpdateParam["Ratio"].DefaultValue = ratio == 0 ? "" : ratio.ToString().Replace(',', '.'); if (!string.IsNullOrEmpty(strFileName)) { var strFullPath = "~/res/advertisement/" + (string.IsNullOrEmpty(strConvertedAdsBannerName) ? "" : strConvertedAdsBannerName + "-") + strAdsBannerID + strFileName.Substring(strFileName.LastIndexOf('.')); if (File.Exists(strOldImagePath)) { File.Delete(strOldImagePath); } FileFileName.UploadedFiles[0].SaveAs(Server.MapPath(strFullPath)); if (IsImageFormat(strFileName)) { //ResizeCropImage.ResizeByCondition(strFullPath, 654, 654); } } } } if (e.CommandName == "DeleteImage") { var oAdsBanner = new AdsBanner(); var lnkDeleteImage = (LinkButton)e.CommandSource; var s = lnkDeleteImage.Attributes["rel"].ToString().Split('#'); var strAdsBannerID = s[0]; var strFileName = s[1]; oAdsBanner.AdsBannerDelete(strAdsBannerID); DeleteImage(strFileName); RadGrid1.Rebind(); } }
protected void radgridDevice_UpdateCommand(object sender, GridCommandEventArgs e) { GridEditableItem updatedItem = (GridEditableItem)e.Item; if (e.Item.OwnerTableView.Name == "Service") { string s = e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["ID"].ToString(); dsService.UpdateParameters.Add(new Parameter("ID", DbType.Int32, s)); dsService.UpdateParameters.Add(new Parameter("ServiceTypeID", DbType.Int32, (updatedItem["ServiceType"].Controls[0] as RadComboBox).SelectedValue)); dsService.UpdateParameters.Add(new Parameter("dateIn", DbType.DateTime, (updatedItem["DateInService"].Controls[0] as RadDatePicker).SelectedDate.ToString())); dsService.Update(); radWM.RadAlert("Тип обслуживания был успешно обновлен.", 300, 200, "", "123"); } if (e.Item.OwnerTableView.Name == "Device") { string s = e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["ID"].ToString(); dsDevices.UpdateParameters.Add(new Parameter("ID", DbType.Int32, s)); dsDevices.UpdateParameters.Add(new Parameter("fn", DbType.String, (updatedItem["FN"].Controls[0] as TextBox).Text)); dsDevices.UpdateParameters.Add(new Parameter("title", DbType.String, (updatedItem["Title"].Controls[0] as TextBox).Text)); dsDevices.UpdateParameters.Add(new Parameter("description", DbType.String, (updatedItem["Description"].Controls[0] as TextBox).Text)); dsDevices.UpdateParameters.Add(new Parameter("typeid", DbType.Int32, (updatedItem["DeviceType"].Controls[0] as RadComboBox).SelectedValue)); dsDevices.Update(); radWM.RadAlert("Устройство было успешно обновлено.", 300, 200, "", "123"); } if (e.Item.OwnerTableView.Name == "Event") { Entities.User u = GetCurrentUser(); string s = e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["ID"].ToString(); dsEvents.UpdateParameters["ID"].DefaultValue = s; dsEvents.UpdateParameters["WPTypeEventID"].DefaultValue = (updatedItem["EventType"].Controls[0] as RadComboBox).SelectedValue; dsEvents.UpdateParameters["WPEventSourceTypeID"].DefaultValue = (updatedItem["EventSource"].Controls[0] as RadComboBox).SelectedValue; dsEvents.UpdateParameters["DateIn"].DefaultValue = (updatedItem["DateInService"].Controls[0] as RadDatePicker).SelectedDate.ToString(); dsEvents.UpdateParameters["UserID"].DefaultValue = u.ID.ToString(); dsEvents.Update(); e.Item.Edit = false; radWM.RadAlert("Выезд был успешно обновлен.", 300, 200, "", "123"); //radgrid.Rebind(); } if (e.Item.OwnerTableView.Name == "WP") { string s = e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["ID"].ToString(); dsWP.UpdateParameters.Add("ID", DbType.Int32, s); dsWP.UpdateParameters.Add("LocationID", DbType.Int32, (updatedItem["WPLocation"].Controls[0] as RadComboBox).SelectedValue); dsWP.UpdateParameters.Add("Title", DbType.String, (updatedItem["Title"].Controls[0] as TextBox).Text); dsWP.UpdateParameters.Add("LF", DbType.Double, (updatedItem["LineFirst"].Controls[0] as TextBox).Text); dsWP.UpdateParameters.Add("LS", DbType.Double, (updatedItem["LineSecond"].Controls[0] as TextBox).Text); dsWP.UpdateParameters.Add("D", DbType.Int32, (updatedItem["D"].Controls[0] as TextBox).Text); dsWP.UpdateParameters.Add("DCalc", DbType.Int32, (updatedItem["DCalc"].Controls[0] as TextBox).Text); dsWP.UpdateParameters.Add("Qmin", DbType.Int32, (updatedItem["QMin"].Controls[0] as TextBox).Text); dsWP.UpdateParameters.Add("Qmax", DbType.Int32, (updatedItem["QMax"].Controls[0] as TextBox).Text); dsWP.UpdateParameters.Add("Comment", DbType.String, (updatedItem["Comment"].Controls[0] as TextBox).Text); dsWP.UpdateParameters.Add("TypeID", DbType.Int32, (updatedItem["WPType"].Controls[0] as RadComboBox).SelectedValue); dsWP.UpdateParameters.Add("StartDate", DbType.DateTime, (updatedItem["StartDate"].Controls[0] as RadDatePicker).SelectedDate.ToString()); dsWP.Update(); radgrid.Rebind(); radWM.RadAlert("Водовод был успешно обновлён.", 300, 200, "", "123"); } e.Canceled = false; //radgrid.Rebind(); }
// clear form input controls for insert/update // grid export functions protected void gvEmployee_ItemCommand(object sender, GridCommandEventArgs e) { RadGrid grid = (sender as RadGrid); if (e.CommandName == RadGrid.InitInsertCommandName) { grid.MasterTableView.ClearEditItems(); } if (e.CommandName == RadGrid.EditCommandName) { e.Item.OwnerTableView.IsItemInserted = false; } if (e.CommandName == RadGrid.RebindGridCommandName) { grid.MasterTableView.ClearEditItems(); e.Item.OwnerTableView.IsItemInserted = false; if (htSearchParams != null) { htSearchParams.Clear(); } } if (e.CommandName == RadGrid.ExportToExcelCommandName) { exporting = true; grid.GridLines = GridLines.Both; grid.BorderStyle = BorderStyle.Solid; grid.BorderWidth = Unit.Pixel(1); grid.ExportSettings.HideStructureColumns = true; grid.ExportSettings.FileName = "noDetailTable"; grid.ExportSettings.IgnorePaging = true; grid.ExportSettings.ExportOnlyData = true; grid.ExportSettings.OpenInNewWindow = true; grid.MasterTableView.UseAllDataFields = true; grid.ExportSettings.Excel.Format = GridExcelExportFormat.Xlsx; foreach (GridDataItem item in grid.Items) { item["ExpandColumn"].Visible = false; } //have the nested tables render only when the user expands them via the UI, so they are not present in the export output grid.MasterTableView.HierarchyLoadMode = GridChildLoadMode.ServerOnDemand; grid.MasterTableView.DetailTables[0].HierarchyLoadMode = GridChildLoadMode.ServerOnDemand; if (e.Item.OwnerTableView.DataMember == "EmployeeMaster") { grid.MasterTableView.GetColumn("ExpType").Visible = false; grid.MasterTableView.GetColumn("defval").Visible = false; grid.MasterTableView.GetColumn("EditEmployee").Visible = false; grid.MasterTableView.GetColumn("DeleteEmployee").Visible = false; int NofCols = (e.Item.OwnerTableView.Columns.Count) - 5; Session["_NOfColumns"] = NofCols; } else if (e.Item.OwnerTableView.DataMember == "EmpExpTypeDetail") { e.Item.OwnerTableView.GetColumn("EditExpenseType").Visible = false; e.Item.OwnerTableView.GetColumn("DeleteExpenseType").Visible = false; e.Item.OwnerTableView.GetColumn("ExpSubType").Visible = false; int NofCols = (e.Item.OwnerTableView.Columns.Count) - 3; Session["_NOfColumns"] = NofCols; } else if (e.Item.OwnerTableView.DataMember == "EmpExpSubTypeDetail") { e.Item.OwnerTableView.GetColumn("DeleteExpenseSubType").Visible = false; int NofCols = (e.Item.OwnerTableView.Columns.Count) - 2; Session["_NOfColumns"] = NofCols; } grid.MasterTableView.ExportToExcel(); //grid.GridLines = GridLines.Both; //grid.BorderStyle = BorderStyle.Solid; //grid.BorderWidth = Unit.Pixel(1); //grid.ExportSettings.ExportOnlyData = true; //grid.ExportSettings.HideStructureColumns = true; //grid.MasterTableView.HierarchyLoadMode = GridChildLoadMode.ServerOnDemand; //grid.MasterTableView.DetailTables[0].HierarchyLoadMode = GridChildLoadMode.ServerOnDemand; //foreach (GridDataItem item in grid.Items) //{ // item["ExpandColumn"].Visible = false; //} //if (e.Item.OwnerTableView.DataMember == "EmployeeMaster") //{ // grid.MasterTableView.GetColumn("ExpType").Visible = false; // grid.MasterTableView.GetColumn("defval").Visible = false; // grid.MasterTableView.GetColumn("EditEmployee").Visible = false; // grid.MasterTableView.GetColumn("DeleteEmployee").Visible = false; // grid.MasterTableView.ExportToExcel(); //} //else if (e.Item.OwnerTableView.DataMember == "EmpExpTypeDetail") //{ // GridTableHierarchySetEditability(grid.MasterTableView, true); // grid.MasterTableView.ExportToExcel(); //} //else if (e.Item.OwnerTableView.DataMember == "EmpExpSubTypeDetail") //{ // GridTableHierarchySetEditability(grid.MasterTableView, true); // grid.MasterTableView.ExportToExcel(); //} } if (e.CommandName == RadGrid.ExportToCsvCommandName) { exporting = true; grid.GridLines = GridLines.Both; grid.BorderStyle = BorderStyle.Solid; grid.BorderWidth = Unit.Pixel(1); grid.ExportSettings.ExportOnlyData = false; grid.MasterTableView.EnableHierarchyExpandAll = false; foreach (GridDataItem item in grid.Items) { item["ExpandColumn"].Visible = false; } if (e.Item.OwnerTableView.DataMember == "EmployeeMaster") { grid.MasterTableView.GetColumn("ExpType").Visible = false; grid.MasterTableView.GetColumn("defval").Visible = false; grid.MasterTableView.GetColumn("EditEmployee").Visible = false; grid.MasterTableView.GetColumn("DeleteEmployee").Visible = false; } else if (e.Item.OwnerTableView.DataMember == "EmpExpTypeDetail") { GridTableHierarchySetEditability(grid.MasterTableView, true); } else if (e.Item.OwnerTableView.DataMember == "EmpExpSubTypeDetail") { GridTableHierarchySetEditability(grid.MasterTableView, true); } grid.MasterTableView.ExportToCSV(); } if (e.CommandName == RadGrid.ExportToPdfCommandName) { exporting = true; grid.GridLines = GridLines.Both; grid.BorderStyle = BorderStyle.Solid; grid.BorderWidth = Unit.Pixel(1); foreach (GridDataItem item in grid.Items) { item["ExpandColumn"].Visible = false; } if (e.Item.OwnerTableView.DataMember == "EmployeeMaster") { grid.MasterTableView.GetColumn("ExpType").Visible = false; grid.MasterTableView.GetColumn("defval").Visible = false; grid.MasterTableView.GetColumn("EditEmployee").Visible = false; grid.MasterTableView.GetColumn("DeleteEmployee").Visible = false; } else if (e.Item.OwnerTableView.DataMember == "EmpExpTypeDetail") { GridTableHierarchySetEditability(grid.MasterTableView, true); } else if (e.Item.OwnerTableView.DataMember == "EmpExpSubTypeDetail") { GridTableHierarchySetEditability(grid.MasterTableView, true); } grid.MasterTableView.ExportToPdf(); } if (e.CommandName == "Print") { Button btnPrint = (Button)e.Item.FindControl("btnOvertimePrint"); RadComboBox ddlPrintOptions = (RadComboBox)e.Item.FindControl("ddlPrintOptions"); if (ddlPrintOptions != null) { if (!string.IsNullOrEmpty(ddlPrintOptions.Text)) { String qstring = clsEncryption.EncryptData(ddlPrintOptions.Text); //btnPrint.Attributes["onclick"] = String.Format("return ShowReport('{0}');", qstring); ScriptManager.RegisterStartupScript(this, Page.GetType(), "mykey", "ShowReport('" + qstring + "');", true); } } } }
protected void GrabarActualizar(object sender, GridCommandEventArgs e, String action) { var editableItem = ((GridEditableItem)e.Item); //create new entity //populate its properties Hashtable values = new Hashtable(); editableItem.ExtractValues(values); RadComboBox oRadComboBox1 = (RadComboBox)e.Item.FindControl("rcbEmpresa"); RadComboBox oRadComboBox2 = (RadComboBox)e.Item.FindControl("rcbGerencia"); RadComboBox oRadComboBox3 = (RadComboBox)e.Item.FindControl("rcbArea"); RadComboBox oRadComboBox_Coordinacion = (RadComboBox)e.Item.FindControl("rcbCoordinacion"); RadComboBox oRadComboBox_Sede = (RadComboBox)e.Item.FindControl("rcbSede"); RadComboBox oRadComboBox_GrupoOrganizacional = (RadComboBox)e.Item.FindControl("rcbGrupoOrganizacional"); RadComboBox oRadComboBox_Puesto = (RadComboBox)e.Item.FindControl("rcbPuesto"); RadComboBox oRadComboBox4 = (RadComboBox)e.Item.FindControl("rcbPerfiles"); BE_PERSONAL oentidad = new BE_PERSONAL(); BL_PERSONAL BL_PERSONAL = new BL_PERSONAL(); Nullable <Guid> ID; if (e.CommandName == RadGrid.PerformInsertCommandName) { ID = Guid.Empty; } else { ID = Guid.Parse(editableItem.GetDataKeyValue("ID").ToString()); } oentidad.ID = (Guid)ID; oentidad.CODIGO_TRABAJO = values["CODIGO_TRABAJO"].ToString(); oentidad.NOMBRES = values["NOMBRES"].ToString(); oentidad.APELLIDO_PATERNO = values["APELLIDO_PATERNO"].ToString(); oentidad.APELLIDO_MATERNO = values["APELLIDO_MATERNO"].ToString(); oentidad.CORREO = values["CORREO"].ToString(); oentidad.NOMBRE_USUARIO = values["NOMBRE_USUARIO"].ToString(); if (!String.IsNullOrEmpty(oRadComboBox1.SelectedValue)) { oentidad.EMPRESA_ID = Guid.Parse(oRadComboBox1.SelectedValue); } else { e.Canceled = true; oRadComboBox1.Text = String.Empty; return; } if (!String.IsNullOrEmpty(oRadComboBox_Sede.SelectedValue)) { oentidad.SEDE_ID = Guid.Parse(oRadComboBox_Sede.SelectedValue); } else { e.Canceled = true; oRadComboBox_Sede.Text = String.Empty; return; } if (!String.IsNullOrEmpty(oRadComboBox2.SelectedValue)) { oentidad.GERENCIA_ID = Guid.Parse(oRadComboBox2.SelectedValue); } else { e.Canceled = true; oRadComboBox2.Text = String.Empty; return; } if (!String.IsNullOrEmpty(oRadComboBox4.SelectedValue)) { oentidad.PERFIL_ID = Int32.Parse(oRadComboBox4.SelectedValue); } else { oRadComboBox4.Text = String.Empty; } if (!String.IsNullOrEmpty(oRadComboBox3.SelectedValue)) { oentidad.AREA_ID = Guid.Parse(oRadComboBox3.SelectedValue); } else { e.Canceled = true; oRadComboBox3.Text = String.Empty; return; } if (!String.IsNullOrEmpty(oRadComboBox_Coordinacion.SelectedValue)) { oentidad.COORDINACION_ID = Guid.Parse(oRadComboBox_Coordinacion.SelectedValue); } else { oRadComboBox_Coordinacion.Text = String.Empty; } if (!String.IsNullOrEmpty(oRadComboBox_Puesto.SelectedValue)) { oentidad.PUESTO_ID = Guid.Parse(oRadComboBox_Puesto.SelectedValue); } else { e.Canceled = true; oRadComboBox_Puesto.Text = String.Empty; return; } if (!String.IsNullOrEmpty(oRadComboBox_GrupoOrganizacional.SelectedValue)) { oentidad.GRUPO_ORGANIZACIONAL_ID = Guid.Parse(oRadComboBox_GrupoOrganizacional.SelectedValue); } else { e.Canceled = true; oRadComboBox_GrupoOrganizacional.Text = String.Empty; return; } if (action == "add") { oentidad.USUARIO_CREACION = USUARIO; oentidad.ESTADO = 1; BL_PERSONAL.InsertarPersonal(oentidad); rgPersonal.Rebind(); } else { oentidad.USUARIO_CREACION = USUARIO; oentidad.ESTADO = 1; BL_PERSONAL.ActualizarPersonal(oentidad); rgPersonal.Rebind(); } }
// grid insert command protected void gvEmployee_InsertCommand(object sender, GridCommandEventArgs e) { Insert_or_Update_EmpExpAssignment(ref e, "Insert"); }
// insert/update function private void Insert_or_Update_EmpExpAssignment(ref GridCommandEventArgs e, string operation) { GridEditableItem editedItem = e.Item as GridEditableItem; try { if (e.Item.OwnerTableView.DataMember == "EmployeeMaster") { //Insert new values Hashtable newValues = new Hashtable(); newValues["@empidd"] = Convert.ToInt32(editedItem.GetDataKeyValue("recidd")); newValues["@empcod"] = Convert.ToInt32(editedItem.GetDataKeyValue("empcod")); newValues["@empfsn"] = editedItem.GetDataKeyValue("empfsn"); newValues["@defval"] = (editedItem.FindControl("cbDefVal") as CheckBox).Checked; RadComboBox ddlExpenseType = (editedItem.FindControl("ddlExpenseType") as RadComboBox); if (ddlExpenseType != null) { if (ddlExpenseType.Items.Count > 0) { Hashtable ht = new Hashtable(); ht.Add("@ID", editedItem.GetDataKeyValue("recidd").ToString()); DataTable dtET = clsDAL.GetDataSet_Payroll("sp_Payroll_Get_EmpExpenseTypeAssignment_Records", ht).Tables[0]; RadGrid rgExp = (ddlExpenseType.Items[0].FindControl("rGrdExpenseType4DDL") as RadGrid); if (rgExp.SelectedItems.Count > 0) { foreach (GridDataItem dataItem in rgExp.SelectedItems) { bool match = false; for (int i = dtET.Rows.Count - 1; i >= 0; i--) { DataRow row = dtET.Rows[i]; if (row["exptidd"].ToString() == dataItem.OwnerTableView.DataKeyValues[dataItem.ItemIndex]["exptidd"].ToString()) { match = true; dtET.Rows.Remove(row); } } if (match == false) { newValues["@exptidd"] = Convert.ToInt32(dataItem.OwnerTableView.DataKeyValues[dataItem.ItemIndex]["exptidd"].ToString()); newValues["@DBMessage"] = ""; string DBMessage = ""; DBMessage = clsDAL.ExecuteNonQuery_payroll("sp_Payroll_Insert_EmployeeExpenseTypeAssignment_Record", newValues, "@DBMessage", System.Data.SqlDbType.NVarChar, 255).ToString(); if ((null != DBMessage) && DBMessage.Contains("ERROR:")) { ShowClientMessage(DBMessage, MessageType.Error); e.Canceled = true; } } } for (int i = dtET.Rows.Count - 1; i >= 0; i--) { Hashtable htValues = new Hashtable(); DataRow row = dtET.Rows[i]; htValues.Add("@exptidd", Convert.ToInt32(row["exptidd"].ToString())); htValues.Add("@empidd", Convert.ToInt32(editedItem.GetDataKeyValue("recidd"))); clsDAL.ExecuteNonQuery_payroll("sp_Payroll_Delete_EmployeeExpenseAssignment_recordDetail", htValues); } } } } ShowClientMessage("Employee expense assignment record saved successfully.", MessageType.Success); //gvEmployee.Rebind(); } if (e.Item.OwnerTableView.DataMember == "EmpExpTypeDetail") { //Insert new values Hashtable newValues = new Hashtable(); newValues["@empidd"] = Convert.ToInt32(editedItem.GetDataKeyValue("empidd")); newValues["@exptidd"] = Convert.ToInt32(editedItem.GetDataKeyValue("exptidd")); GridDataItem ParentItem = e.Item.OwnerTableView.ParentItem as GridDataItem; newValues["@empcod"] = ParentItem.GetDataKeyValue("empcod"); newValues["@empfsn"] = ParentItem.GetDataKeyValue("empfsn"); RadComboBox ddlExpenseSubType = (editedItem.FindControl("ddlExpenseSubType") as RadComboBox); if (ddlExpenseSubType != null) { if (ddlExpenseSubType.Items.Count > 0) { #region delete old records Hashtable ht = new Hashtable(); ht.Add("@empidd", Convert.ToInt32(editedItem.GetDataKeyValue("empidd"))); ht.Add("@exptidd", Convert.ToInt32(editedItem.GetDataKeyValue("exptidd"))); clsDAL.ExecuteNonQuery_payroll("sp_Payroll_Delete_EmployeeExpenseAssignment_recordDetail", ht); #endregion RadGrid rgEmployee = (ddlExpenseSubType.Items[0].FindControl("rGrdExpenseSubType4DDL") as RadGrid); if (rgEmployee.SelectedItems.Count > 0) { foreach (GridDataItem dataItem in rgEmployee.SelectedItems) { newValues["@expsubtidd"] = Convert.ToInt32(dataItem.OwnerTableView.DataKeyValues[dataItem.ItemIndex]["expsubtidd"].ToString()); newValues["@expsubtcod"] = dataItem.OwnerTableView.DataKeyValues[dataItem.ItemIndex]["expsubtcod"].ToString(); newValues["@DBMessage"] = ""; string DBMessage = ""; DBMessage = clsDAL.ExecuteNonQuery_payroll("sp_Payroll_Insert_EmployeeExpenseSubTypeAssignment_Record", newValues, "@DBMessage", System.Data.SqlDbType.NVarChar, 255).ToString(); if ((null != DBMessage) && DBMessage.Contains("ERROR:")) { ShowClientMessage(DBMessage, MessageType.Error); e.Canceled = true; } } } } } ShowClientMessage("Employee expense assignment record saved successfully.", MessageType.Success); //gvEmployee.Rebind(); } } catch (Exception ex) { ShowClientMessage("Unable to save employee expense assignment record. Reason: " + ex.Message, MessageType.Error); e.Canceled = true; } }
protected void grdRequest_ItemCommand(object sender, GridCommandEventArgs e) { try { if (e.CommandName == "Select") { GridDataItem dataitem = e.Item as GridDataItem; DataTable dtcon = CM_Main.SelectJob("CASE11", dataitem["REQUEST_ID"].Text, "", "", "", "", System.DateTime.Now); grdRequest.DataSource = dtcon; grdRequest.DataBind(); BtnUpdate.Enabled = true; BtnReject.Enabled = true; txtReqID.Text = dtcon.Rows[0]["REQUEST_ID"].ToString(); lblCompany.Text = dtcon.Rows[0]["COMPANY"].ToString(); lblStatus.Text = dtcon.Rows[0]["STATUS"].ToString(); lblTitle.Text = dtcon.Rows[0]["TITLE"].ToString(); lblSystem.Text = dtcon.Rows[0]["SYSTEM"].ToString(); lblDescription.Text = dtcon.Rows[0]["DESCRIPTION"].ToString(); lblRequestUser.Text = dtcon.Rows[0]["RU_FULLNAME"].ToString(); lblManager.Text = dtcon.Rows[0]["MAN_FULLNAME"].ToString(); lblImplement.Text = dtcon.Rows[0]["IMP_FULLNAME"].ToString(); lblQA.Text = dtcon.Rows[0]["QA_FULLNAME"].ToString(); lblRelease.Text = dtcon.Rows[0]["RE_FULLNAME"].ToString(); lblRejectRea.Text = dtcon.Rows[0]["REJECT_COMMENT"].ToString(); lblImpact.Text = dtcon.Rows[0]["IMPACT"].ToString(); lblOutage.Text = dtcon.Rows[0]["OUTAGE"].ToString(); lblFallBack.Text = dtcon.Rows[0]["FEEDBACK_PLAN"].ToString(); lblParent.Text = dtcon.Rows[0]["PARENT_ID"].ToString(); lblCreation.Text = dtcon.Rows[0]["REQUEST_DATE"].ToString(); lblStart.Text = dtcon.Rows[0]["START_DATE"].ToString(); lblEnd.Text = dtcon.Rows[0]["END_DATE"].ToString(); lblLastUpdate.Text = dtcon.Rows[0]["LAST_UPDATE_DATE"].ToString(); lblAssign.Text = dtcon.Rows[0]["ASSIGN_DATE"].ToString(); RdGrdEvents.DataSource = CM_Main.SelectJob("CASE10", dataitem["REQUEST_ID"].Text, "", "", "", "", System.DateTime.Now); RdGrdEvents.DataBind(); DataTable dtDocsJobWise = CM_Main.SelectJob("CASE13", txtReqID.Text, "", "", "", "", System.DateTime.Now); if (dtDocsJobWise.Rows.Count >= 1) { RadListBox2.DataSource = dtDocsJobWise; RadListBox2.DataTextField = "DOCUMENT"; RadListBox2.DataValueField = "DOCUMENT"; RadListBox2.DataBind(); } DataTable dt = Main.SelectImages(dtcon.Rows[0]["IT_REQUEST_ID"].ToString(), "BRANCH_IMAGE"); galleryDataList.DataSource = dt; galleryDataList.DataBind(); DataTable dt33 = Main.SelectImages(dtcon.Rows[0]["IT_REQUEST_ID"].ToString(), "BRANCH_DOCS"); DataList2.DataSource = dt33; DataList2.DataBind(); DataTable dtEvents = Main.SelectJobFromRegister("CASE16", dtcon.Rows[0]["IT_REQUEST_ID"].ToString(), "", "", System.DateTime.Now); RadGrdEventsITWF.DataSource = dtEvents; RadGrdEventsITWF.DataBind(); } } catch (Exception ex) { lblError.Text = ex.Message; lblError.Visible = true; return; } }
protected void RadGrid1_UpdateCommand(object source, GridCommandEventArgs e) { try { GridEditableItem editedItem = e.Item as GridEditableItem; GridEditManager editMan = editedItem.EditManager; int i = 2; dt = (DataTable)Session[SessionContents.FPS_AddProspect_DataTable]; dr = dt.NewRow(); foreach (GridColumn column in e.Item.OwnerTableView.RenderColumns) { if (column is IGridEditableColumn) { IGridEditableColumn editableCol = (column as IGridEditableColumn); if (editableCol.IsEditable) { IGridColumnEditor editor = editMan.GetColumnEditor(editableCol); string editorType = editor.ToString(); string editorText = "unknown"; object editorValue = null; if (editor is GridTextColumnEditor) { editorText = (editor as GridTextColumnEditor).Text; editorValue = (editor as GridTextColumnEditor).Text; } if (editor is GridBoolColumnEditor) { editorText = (editor as GridBoolColumnEditor).Value.ToString(); editorValue = (editor as GridBoolColumnEditor).Value; } if (editor is GridDropDownColumnEditor) { editorText = (editor as GridDropDownColumnEditor).SelectedValue; editorValue = (editor as GridDropDownColumnEditor).SelectedValue; } if (editor is GridTemplateColumnEditor) { if (i != 3) { TextBox txt = (TextBox)e.Item.FindControl("txtIPName"); editorText = txt.Text; editorValue = txt.Text; } else if (i == 3) { TextBox txt = (TextBox)e.Item.FindControl("txtIPComments"); editorText = txt.Text; editorValue = txt.Text; } } try { DataRow[] changedrows = dt.Select(); changedrows[editedItem.ItemIndex][column.UniqueName] = editorValue; } catch (Exception ex) { RadGrid1.Controls.Add(new LiteralControl("<strong>Unable to set value of column '" + column.UniqueName + "'</strong> - " + ex.Message)); e.Canceled = true; break; } } i++; } } Session[SessionContents.FPS_AddProspect_DataTable] = dt; Rebind(false); } catch (Exception ex) { e.Canceled = true; throw ex; } }