protected void gdvSubList_RowCommand(object sender, GridViewCommandEventArgs e) { try { ListManagementDataContext dbList = new ListManagementDataContext(SystemSetting.SageFrameConnectionString); int entryId = int.Parse(e.CommandArgument.ToString()); if (e.CommandName == "Delete") { try { var deleteList = dbList.sp_ListEntryDeleteByID(entryId, true, GetCurrentCultureName); // ShowMessage(SageMessageTitle.Information.ToString(), "List is deleted successfully", "", SageMessageType.Success); ShowMessage(SageMessageTitle.Information.ToString(), GetSageMessage("ListSettings", "ListIsDeletedSuccessfully"), "", SageMessageType.Success); } catch (Exception ex) { ProcessException(ex); } } else if (e.CommandName == "SortUp") { try { var sortList = dbList.sp_ListSortOrderUpdate(entryId, true, GetCurrentCultureName); // ShowMessage(SageMessageTitle.Information.ToString(), "The List is shifted up successfully", "", SageMessageType.Success); ShowMessage(SageMessageTitle.Information.ToString(), GetSageMessage("ListSettings", "TheListIsShiftedUpSuccessfully"), "", SageMessageType.Success); } catch (Exception ex) { ProcessException(ex); } } else if (e.CommandName == "SortDown") { try { var sortList = dbList.sp_ListSortOrderUpdate(entryId, false, GetCurrentCultureName); // ShowMessage(SageMessageTitle.Information.ToString(), "The List is shifted downn successfully", "", SageMessageType.Success); ShowMessage(SageMessageTitle.Information.ToString(), GetSageMessage("ListSettings", "TheListIsShiftedDownSuccessfully"), "", SageMessageType.Success); } catch (Exception ex) { ProcessException(ex); } } else if (e.CommandName == "Edit") { try { HideControls(); ViewState["ENTRYID"] = entryId; var editList = dbList.sp_GetListEntrybyNameValueAndEntryID("", "", entryId, GetCurrentCultureName); foreach (sp_GetListEntrybyNameValueAndEntryIDResult getListEntry in editList) { txtEntryText.Text = getListEntry.Text; txtEntryValue.Text = getListEntry.Value; txtCurrencyCode.Text = getListEntry.CurrencyCode; txtDisplayLocale.Text = getListEntry.DisplayLocale; chkActive.Checked = (bool)getListEntry.IsActive; AddEditMode(); // ShowMessage(SageMessageTitle.Information.ToString(), "List is edited successfully", "", SageMessageType.Success); //ShowMessage(SageMessageTitle.Information.ToString(), GetSageMessage("ListSettings", "ListIsEditedSuccessfully"), "", SageMessageType.Success); } } catch (Exception ex) { ProcessException(ex); } } if (ViewState["LISTNAME"] != null) { BindGrid(ViewState["LISTNAME"].ToString(), ViewState["PARENTKEY"].ToString()); } } catch (Exception ex) { ProcessException(ex); } }
protected void gdvSubList_RowCommand(object sender, GridViewCommandEventArgs e) { try { ListManagementDataContext dbList = new ListManagementDataContext(SystemSetting.SageFrameConnectionString); int entryId = int.Parse(e.CommandArgument.ToString()); if (e.CommandName == "Delete") { try { var deleteList = dbList.sp_ListEntryDeleteByID(entryId, true,GetCurrentCultureName); // ShowMessage(SageMessageTitle.Information.ToString(), "List is deleted successfully", "", SageMessageType.Success); ShowMessage(SageMessageTitle.Information.ToString(), GetSageMessage("ListSettings", "ListIsDeletedSuccessfully"), "", SageMessageType.Success); } catch (Exception ex) { ProcessException(ex); } } else if (e.CommandName == "SortUp") { try { var sortList = dbList.sp_ListSortOrderUpdate(entryId, true,GetCurrentCultureName); // ShowMessage(SageMessageTitle.Information.ToString(), "The List is shifted up successfully", "", SageMessageType.Success); ShowMessage(SageMessageTitle.Information.ToString(), GetSageMessage("ListSettings", "TheListIsShiftedUpSuccessfully"), "", SageMessageType.Success); } catch (Exception ex) { ProcessException(ex); } } else if (e.CommandName == "SortDown") { try { var sortList = dbList.sp_ListSortOrderUpdate(entryId, false,GetCurrentCultureName); // ShowMessage(SageMessageTitle.Information.ToString(), "The List is shifted downn successfully", "", SageMessageType.Success); ShowMessage(SageMessageTitle.Information.ToString(), GetSageMessage("ListSettings", "TheListIsShiftedDownSuccessfully"), "", SageMessageType.Success); } catch (Exception ex) { ProcessException(ex); } } else if (e.CommandName == "Edit") { try { HideControls(); ViewState["ENTRYID"] = entryId; var editList = dbList.sp_GetListEntrybyNameValueAndEntryID("", "", entryId,GetCurrentCultureName); foreach (sp_GetListEntrybyNameValueAndEntryIDResult getListEntry in editList) { txtEntryText.Text = getListEntry.Text; txtEntryValue.Text = getListEntry.Value; txtCurrencyCode.Text = getListEntry.CurrencyCode; txtDisplayLocale.Text = getListEntry.DisplayLocale; chkActive.Checked = (bool)getListEntry.IsActive; AddEditMode(); // ShowMessage(SageMessageTitle.Information.ToString(), "List is edited successfully", "", SageMessageType.Success); //ShowMessage(SageMessageTitle.Information.ToString(), GetSageMessage("ListSettings", "ListIsEditedSuccessfully"), "", SageMessageType.Success); } } catch (Exception ex) { ProcessException(ex); } } if (ViewState["LISTNAME"] != null) { BindGrid(ViewState["LISTNAME"].ToString(), ViewState["PARENTKEY"].ToString()); } } catch (Exception ex) { ProcessException(ex); } }
private void AddNewList() { string listName = txtListName.Text.Trim(); string value = txtEntryValue.Text.Trim(); string text = txtEntryText.Text.Trim(); int parentId = 0; int level = 0; int definitionId = -1; int portalId = -1;// GetPortalID; string createdBy = GetUsername; bool displayOrder = false; bool isActive = false; string currencyCode = txtCurrencyCode.Text.Trim(); string displayLocale = txtDisplayLocale.Text.Trim(); ListManagementDataContext dbList = new ListManagementDataContext(SystemSetting.SageFrameConnectionString); if (chkShort.Checked == true) { displayOrder = true; } if (chkActive.Checked == true) { isActive = true; } if (ddlParentList.SelectedIndex != 0) { try { parentId = int.Parse(ddlParentEntry.SelectedValue.ToString()); string selectedListName = string.Empty; string[] selectedListNames = SplitString(ddlParentEntry.SelectedItem.Text); selectedListName = selectedListNames[0]; var listLevel = dbList.sp_GetListEntrybyNameValueAndEntryID(selectedListName, "", int.Parse(ddlParentEntry.SelectedValue.ToString()), GetCurrentCultureName); foreach (sp_GetListEntrybyNameValueAndEntryIDResult parentLevel in listLevel) { level = int.Parse(parentLevel.LEVEL.ToString()) + 1; } } catch (Exception ex) { ProcessException(ex); } } try { int ListID = ListManagementController.AddNewList(new ListInfo(listName, value, text, parentId, level, currencyCode, displayLocale, displayOrder, definitionId, "", portalId, isActive, createdBy, GetCurrentCultureName)); if (ListID == 0) { ShowMessage(SageMessageTitle.Notification.ToString(), GetSageMessage("ListSettings", "ListAlreadyExists"), "", SageMessageType.Alert); } else { BindTreeView(); ViewMode(); ShowMessage(SageMessageTitle.Information.ToString(), GetSageMessage("ListSettings", "ListIsAddedSuccessfully"), "", SageMessageType.Success); BindGridOnPageLoad(); } } catch (Exception ex) { ProcessException(ex); } }
private void AddNewList() { string listName = txtListName.Text.Trim(); string value = txtEntryValue.Text.Trim(); string text = txtEntryText.Text.Trim(); int parentId = 0; int level = 0; int definitionId = -1; int portalId = -1;// GetPortalID; string createdBy = GetUsername; bool displayOrder = false; bool isActive = false; string currencyCode = txtCurrencyCode.Text.Trim(); string displayLocale = txtDisplayLocale.Text.Trim(); ListManagementDataContext dbList = new ListManagementDataContext(SystemSetting.SageFrameConnectionString); if (chkShort.Checked == true) { displayOrder = true; } if (chkActive.Checked == true) { isActive = true; } if (ddlParentList.SelectedIndex != 0) { try { parentId = int.Parse(ddlParentEntry.SelectedValue.ToString()); string selectedListName = string.Empty; string[] selectedListNames = SplitString(ddlParentEntry.SelectedItem.Text); selectedListName = selectedListNames[0]; var listLevel = dbList.sp_GetListEntrybyNameValueAndEntryID(selectedListName, "", int.Parse(ddlParentEntry.SelectedValue.ToString()),GetCurrentCultureName); foreach (sp_GetListEntrybyNameValueAndEntryIDResult parentLevel in listLevel) { level = int.Parse(parentLevel.LEVEL.ToString()) + 1; } } catch (Exception ex) { ProcessException(ex); } } try { int ListID = ListManagementController.AddNewList(new ListInfo(listName, value, text, parentId, level, currencyCode, displayLocale, displayOrder, definitionId, "", portalId, isActive, createdBy, GetCurrentCultureName)); if (ListID==0) { ShowMessage(SageMessageTitle.Notification.ToString(), GetSageMessage("ListSettings", "ListAlreadyExists"), "", SageMessageType.Alert); } else { BindTreeView(); ViewMode(); ShowMessage(SageMessageTitle.Information.ToString(), GetSageMessage("ListSettings", "ListIsAddedSuccessfully"), "", SageMessageType.Success); BindGridOnPageLoad(); } } catch (Exception ex) { ProcessException(ex); } }