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);
}
}