private void openInsideGridView()
{
if (!GridViewInner.Visible)
{
// Get the list of files & folders in the lowerDirectory
// Populate FSItems
//NetworkDrives.MapDrive("iboxx");
MyGridView.setCurrentDirectoryInfo(getLowerDirectory());
//NetworkDrives.DisconnectDrive("iboxx");
MyGridView.FSItems = populateFSItems();
if (MyGridView.FSItems.Count != 0)
{
// Set gvInsideFolder DataSource equal to myGridview.FSItems and Bind Data
// Change checkbox visibility to true for expanded details/folders
// Return to current folder on myGridView
GridViewInner.DataSource = MyGridView.FSItems;
GridViewInner.DataBind();
displayFileNameAsLiteral();
displayRenameAndMoveColumns();
changeRadioButtonVisibility();
//NetworkDrives.MapDrive("iboxx");
MyGridView.setCurrentDirectoryInfo(DestinationCurrentFolder);
//NetworkDrives.DisconnectDrive("iboxx");
}
}
}
public XtraGridPopupMenu_PivotXtraForm(MyGridView sourceGridView)
{
InitializeComponent();
this.sourceGridView = sourceGridView;
chartConfigurationBarXUC1.InitPanel(pivotGridControl1, chartControl1);
sourceGridView.ColumnFilterChanged += sourceGridView_ColumnFilterChanged;
tableBindingSource.DataSource = sourceGridView.DataSource;
tableBindingSource.ResetBindings(true);
//Build monthes list
monthNamesListBindingSource.DataSource = BuildMonthNames();
InitNewReport(sourceGridView);
//AddXtraDateFields(tableBindingSource); We will using Split Date Field
pivotGridControl1.RefreshData();
//Apply filter to dataSource
string filter = DevExpress.Data.Filtering.CriteriaToWhereClauseHelper.GetDataSetWhere(sourceGridView.ActiveFilterCriteria);
pivotGridControl1.Prefilter.Criteria = sourceGridView.ActiveFilterCriteria;
gridInfo = (XtraGridViewInfo)sourceGridView.Tag;
string instanceUQNameSuffix = gridInfo != null && gridInfo.GridViewDBKey != null?gridInfo.GridViewDBKey.ToString() : "";
pivotGridControl1.Name += instanceUQNameSuffix;
}
public override void CurrentContent_Sorting(object sender, GridViewSortEventArgs e)
{
e.SortDirection = SortDirection.Descending;
if ((this.ViewState["ClickSortField"] != null) && (this.ViewState["ClickSortField"].ToString() == e.SortExpression))
{
if ((this.ViewState["SortDirection"] != null) && (this.ViewState["SortDirection"].ToString() == "ASC"))
{
this.ViewState["SortDirection"] = "DESC";
}
else
{
this.ViewState["SortDirection"] = "ASC";
}
}
else
{
this.ViewState["SortDirection"] = "DESC";
}
this.ViewState["ClickSortField"] = e.SortExpression;
string str = (string)this.ViewState["SortDirection"];
this.ClickSortExpression = "it." + e.SortExpression + ((str == "ASC") ? "" : (" " + str));
this.RenderPage();
MyGridView view = (MyGridView)sender;
string str2 = (str == "ASC") ? view.SortedAscendingHeaderStyle.CssClass : view.SortedDescendingHeaderStyle.CssClass;
view.HeaderRow.Cells[this.GetColumnIndex(e.SortExpression, view.Columns)].CssClass = str2;
}
protected void Page_Load(object sender, EventArgs e)
{
columns = new List <string>();
columns.Add("merkki");
columns.Add("malli");
columns.Add("vm");
columns.Add("myyntiHinta");
ds = new DataSet();
ds.ReadXml(ConfigurationManager.AppSettings["WanhatAutot"]);
dt = ds.Tables[1];
DataTable dataTableRandomRows = dt.Clone();
int[] randomNumbers = GetRandomNumbers(dt.Columns.Count, 4);
foreach (int i in randomNumbers)
{
dataTableRandomRows.ImportRow(dt.Rows[i]);
}
dataViewAll = dt.DefaultView;
dataViewRandomRows = dataTableRandomRows.DefaultView;
MyGridView.DataSource = dataViewRandomRows.ToTable(false, columns.ToArray());
MyGridView.DataBind();
FillDropDownListMerkit();
}
private void setMyGridView(object sender)
{
if (sender.GetType() == typeof(RadioButton))
{
// Cast sender as a Gridview
sender = (GridView)(sender as RadioButton).Parent.Parent.Parent.Parent;
}
GridView gvSender = (GridView)sender;
if (gvSender.ClientID == "gvSource")
{
this.MyGVSource.Gridview = gvSender;
this.MyGridView = this.MyGVSource;
}
else if (gvSender.ClientID == "gvDestination")
{
this.MyGVDestination.Gridview = gvSender;
this.MyGridView = this.MyGVDestination;
}
else
{
MyGridView newMyGridview = new MyGridView();
newMyGridview.Gridview = gvSender;
this.MyGridView = newMyGridview;
}
}
private void GridView_ItemClick(object sender, ItemClickEventArgs e)
{
var gridViewItem = MyGridView.ContainerFromItem(e.ClickedItem) as GridViewItem;
ContentItemDataModel item = (ContentItemDataModel)gridViewItem.Content;
ViewModel.EditingItem = item;
Frame.Navigate(typeof(EditItemFrame));
}
public void CurrentBindData <T>(MyGridView objGridView, ObjectQuery <T> objObjectQuery, string fields) where T : EntityObject
{
int recordCount = 0;
objGridView.DataSource = objObjectQuery.GetPage <T>(fields, this.SearchCondition <T>(), this.SearchSortExpression(), this.PageSize, this.PageIndex, out recordCount);
objGridView.RecordCount = recordCount;
objGridView.PageSize = this.PageSize;
objGridView.PageIndex = this.PageIndex;
objGridView.DataBind();
}
public void CurrentBindData <T>(MyGridView objGridView, PageBindData objPageBindData, string fields = "*") where T : class
{
int recordCount = 0;
objGridView.DataSource = this.BindDataing(objPageBindData(this.SearchCondition <T>(), this.SearchSortExpression(), this.PageSize, this.PageIndex, out recordCount, fields));
objGridView.RecordCount = recordCount;
objGridView.PageSize = this.PageSize;
objGridView.PageIndex = this.PageIndex;
objGridView.DataBind();
}
public XtraGridPopupMenu_ColumnsReorderXtraForm(MyGridView gridView)
{
InitializeComponent();
view = gridView;
ReadColumnsData(view);
ReadViewOptions(view);
hiddenGridViewColumnsBindingSource.Filter = string.Format("IsVisible = {0} ", false);
visibleGridViewColumnsBindingSource.Filter = string.Format("IsVisible = {0} ", true);
}
public void CurrentBindData(MyGridView objGridView, string tableNameOrCommandText, PageBindTableData objPageBindData, string fields = "*")
{
int recordCount = 0;
objGridView.DataSource = this.BindDataing(objPageBindData(tableNameOrCommandText, this.SearchConditionSql(), this.SearchSortExpression(), this.PageSize, this.PageIndex, out recordCount, fields));
objGridView.RecordCount = recordCount;
objGridView.PageSize = this.PageSize;
objGridView.PageIndex = this.PageIndex;
objGridView.DataBind();
}
public void CurrentBindData(MyGridView objGridView, PageSolrBindData objPageBindData, string fields = "*")
{
long recordCount = 0L;
objGridView.DataSource = this.BindDataing(objPageBindData(fields, this.SearchConditionSolrSql(), "", this.PageSize, this.PageIndex, this.SearchSolrSortExpression(), out recordCount, ""));
objGridView.RecordCount = int.Parse(recordCount.ToString());
objGridView.PageSize = this.PageSize;
objGridView.PageIndex = this.PageIndex;
objGridView.DataBind();
}
public void CurrentBindData(MyGridView objGridView, ObjectQuery <DbDataRecord> objObjectQuery)
{
int recordCount = 0;
objGridView.DataSource = objObjectQuery.GetPage <DbDataRecord>(this.Condition, this.SearchSortExpression(), this.PageSize, this.PageIndex, out recordCount);
objGridView.RecordCount = recordCount;
objGridView.PageSize = this.PageSize;
objGridView.PageIndex = this.PageIndex;
objGridView.DataBind();
}
private async void GoToButton_Click(object sender, RoutedEventArgs e)
{
int.TryParse(GoToIntex.Text, out int goToIntex);
ItemPlacement itemPlacement = (ItemPlacement)ItemPlacementComboBox.SelectedItem;
bool disableAnimation = DisableAnimationToggleSwitch.IsOn;
bool scrollIfVisibile = ScrollIfVisibileToggleSwitch.IsOn;
int.TryParse(AdditionalHorizontalOffsetTextBox.Text, out int additionalHorizontalOffset);
int.TryParse(AdditionalHorizontalOffsetTextBox.Text, out int additionalVerticalOffset);
await MyGridView.SmoothScrollIntoViewWithIndex(goToIntex, itemPlacement, disableAnimation, scrollIfVisibile, additionalHorizontalOffset, additionalVerticalOffset);
}
public void CurrentBindData(MyGridView objGridView, string tableNameOrCommandText, PageBindTableData objPageBindData, Action <DataSet> OnDataBinding, string fields = "*")
{
int recordCount = 0;
DataSet set = objPageBindData(tableNameOrCommandText, this.SearchConditionSql(), this.SearchSortExpression(), this.PageSize, this.PageIndex, out recordCount, fields);
objGridView.DataSource = set;
objGridView.RecordCount = recordCount;
objGridView.PageSize = this.PageSize;
objGridView.PageIndex = this.PageIndex;
if (OnDataBinding != null)
{
OnDataBinding(set);
}
objGridView.DataBind();
}
public void CurrentBindData <T>(MyGridView objGridView, PageBindData objPageBindData, Action <DataSet> OnDataBinding, string fields = "*") where T : class
{
int recordCount = 0;
DataSet set = objPageBindData(this.SearchCondition <T>(), this.SearchSortExpression(), this.PageSize, this.PageIndex, out recordCount, fields);
objGridView.DataSource = set;
objGridView.RecordCount = recordCount;
objGridView.PageSize = this.PageSize;
objGridView.PageIndex = this.PageIndex;
if (OnDataBinding != null)
{
OnDataBinding(set);
}
objGridView.DataBind();
}
public void CurrentBindData(MyGridView objGridView, PageSolrBindData objPageBindData, Action <DataSet> OnDataBinding, string fields = "*")
{
long recordCount = 0L;
DataSet set = objPageBindData(fields, this.SearchConditionSolrSql(), "", this.PageSize, this.PageIndex, this.SearchSolrSortExpression(), out recordCount, "");
objGridView.DataSource = set;
objGridView.RecordCount = int.Parse(recordCount.ToString());
objGridView.PageSize = this.PageSize;
objGridView.PageIndex = this.PageIndex;
if (OnDataBinding != null)
{
OnDataBinding(set);
}
objGridView.DataBind();
}
public void CurrentBindData(MyGridView objGridView, IQueryable <T> objectQuery)
{
Expression <Func <T, bool> > condition = this.Condition;
int num = 0;
if (condition != null)
{
objectQuery = objectQuery.Where <T>(condition);
}
num = objectQuery.Count <T>();
objGridView.RecordCount = num;
objGridView.PageSize = base.PageSize;
objGridView.PageIndex = base.PageIndex;
objGridView.DataBind();
}
protected void DropDownListMerkit_SelectedIndexChanged(object sender, EventArgs e)
{
TextBoxHaku.Text = "";
if (DropDownListMerkit.SelectedItem.ToString() == "")
{
MyGridView.DataSource = dataViewAll.ToTable(false, columns.ToArray());
MyGridView.DataBind();
}
else
{
dataViewAll.RowFilter = "merkki = '" + DropDownListMerkit.SelectedItem.ToString() + "'";
MyGridView.DataSource = dataViewAll.ToTable(false, columns.ToArray());
MyGridView.DataBind();
}
}
private List <MyFile> populateGridView(MyGridView myGridview, Label lblCurrentFolder)
{
// Get Files & Folders in the CurrentFolder
myGridview.setCurrentDirectoryInfo();
if (!SearchMode || (SearchMode && myGridview.GridViewName != "gvDestination"))
{
myGridview.FSItems?.Clear();
// Update Gridview
if (!SearchMode)
{
lblCurrentFolder.Text = myGridview.getCurrentFolderLabelText();
}
myGridview.updateMyGridviewDataSource();
}
searchFunctionVisibility();
return(myGridview.FSItems);
}
public void CurrentBindData(MyGridView objGridView, IQueryable <T> objectQuery)
{
Expression <Func <T, bool> > condition = this.Condition;
Expression <Func <T, bool> > predicate = base.QueryModel.ToConditioExpressionLinq <T>();
int recordCount = 0;
if (condition != null)
{
objectQuery = objectQuery.Where <T>(condition);
}
if (predicate != null)
{
objectQuery = objectQuery.Where <T>(predicate);
}
objGridView.DataSource = objectQuery.GetPage <T>(this.SearchSortExpression(), this.PageSize, this.PageIndex, out recordCount);
objGridView.RecordCount = recordCount;
objGridView.PageSize = this.PageSize;
objGridView.PageIndex = this.PageIndex;
objGridView.DataBind();
}
public string openFolderViaLinkButton(string currentFolder)
{
if (currentFolder == "Source")
{
this.CurrentFolder = this.SourceCurrentFolder;
this.MyGridView = this.MyGVSource;
}
else if (currentFolder == "Destination")
{
this.CurrentFolder = this.DestinationCurrentFolder;
this.MyGridView = this.MyGVDestination;
}
setMyFileOpenFolder(CurrentFolder);
//NetworkDrives.MapDrive("iboxx");
if (CommandArgument == "..")
{
MyGridView.setCurrentDirectoryInfo(Path.GetDirectoryName(MyFile.FullName));
}
else
{
// //for each character
// //if value of 160
// //replace with 32
// char[] charArray = CommandArgument.ToCharArray();
// for (int i = 0; i < charArray.Length; i++) {
// if (charArray[i] == 160) {
// charArray[i] = (char)32;
// }
// }
// //CommandArgument = string.Join("", charArray);
// CommandArgument = new string(charArray);
MyGridView.setCurrentDirectoryInfo(Path.Combine(MyFile.FullName, CommandArgument));
}
////NetworkDrives.DisconnectDrive("iboxx");
return(MyGridView.CurrentFolder);
}
public void ApplyFieldSettings(MyGridView gv, GridColumn grdCol, bool enableAutoFormat)
{
//Avoid access to null when field is complex name Like Name!Key or Name!
var c = gv.Columns[ColumnName] ?? gv.Columns[$"{ColumnName}!Key"];
if (c == null)
{
Debug.WriteLine($"{ColumnName} has been scapped from apply settings");
return;
}
//Save Column information in grid column Tag
GridColumnInfo info = new GridColumnInfo()
{
ColumnLablel = this
};
grdCol.Tag = info;
// gv.Columns.Remove()
c.Caption = ChooseValueForCurrentLang(MyEnums.UILabelType.FieldCaption);
c.ToolTip = ChooseValueForCurrentLang(MyEnums.UILabelType.FieldHelp);
if (!enableAutoFormat)
{
return; //Exit for non formated grid view
}
Size columnSize = TextRenderer.MeasureText("".PadLeft(Width, 'A'), grdCol.AppearanceCell.Font);
c.Width = IsHidden ? 0: columnSize.Width;
c.OptionsColumn.ReadOnly = this.IsDisabled;
c.OptionsColumn.AllowEdit = !IsDisabled;
c.OptionsEditForm.Visible = IsDisabled ? DevExpress.Utils.DefaultBoolean.False : DevExpress.Utils.DefaultBoolean.Default;
c.Visible = !IsHidden;
c.VisibleIndex = IsHidden ? -1 : VisibleOrder;
c.OptionsEditForm.VisibleIndex = IsHidden ? -1 : VisibleOrder;
}
protected void MyGridView_Sorting(object sender, GridViewSortEventArgs e)
{
string sortDirection = "ASC";
string sortExpression = ViewState["SortExpression"] as string;
DataTable dt2 = dt.Clone();
dt2.Columns["myyntiHinta"].DataType = Type.GetType("System.Int32");
dt2.Columns["vm"].DataType = Type.GetType("System.Int32");
foreach (DataRow dr in dt.Rows)
{
dt2.ImportRow(dr);
}
dt2.AcceptChanges();
DataView dv = dt2.DefaultView;
if (sortExpression == e.SortExpression)
{
string lastDirection = ViewState["SortDirection"] as string;
if ((lastDirection != null) && (lastDirection == "ASC"))
{
sortDirection = "DESC";
}
}
dv.Sort = e.SortExpression + " " + sortDirection;
// Save new values in ViewState.
ViewState["SortDirection"] = sortDirection;
ViewState["SortExpression"] = e.SortExpression;
MyGridView.DataSource = dt2.DefaultView.ToTable(false, columns.ToArray());
MyGridView.DataBind();
}
protected void ButtonHaku_Click(object sender, EventArgs e)
{
if (TextBoxHaku.Text == "")
{
DropDownListMerkit.Text = "";
MyGridView.DataSource = dataViewAll.ToTable(false, columns.ToArray());
MyGridView.DataBind();
}
else
{
dataViewAll.RowFilter = "merkki = '" + TextBoxHaku.Text + "'";
if (dataViewAll.Count == 0)
{
DropDownListMerkit.Text = "";
}
else
{
DropDownListMerkit.Text = TextBoxHaku.Text.Substring(0, 1).ToUpper() + TextBoxHaku.Text.Substring(1, TextBoxHaku.Text.Length - 1);
}
MyGridView.DataSource = dataViewAll.ToTable(false, columns.ToArray());
MyGridView.DataBind();
}
}
public override string GetDesignTimeHtml()
{
// Make the full extent of the control more visible in the designer.
// If the border style is None or NotSet, change the border to
// a wide, blue, dashed line. Include the caption within the border.
MyGridView myGV = (MyGridView)Component;
string markup = null;
int charX;
// Check if the border style should be changed.
if (myGV.BorderStyle == BorderStyle.NotSet ||
myGV.BorderStyle == BorderStyle.None)
{
BorderStyle oldBorderStyle = myGV.BorderStyle;
Unit oldBorderWidth = myGV.BorderWidth;
Color oldBorderColor = myGV.BorderColor;
// Set the design-time properties and catch any exceptions.
try
{
myGV.BorderStyle = BorderStyle.Dashed;
myGV.BorderWidth = Unit.Pixel(3);
myGV.BorderColor = Color.Blue;
// Call the base method to generate the markup.
markup = base.GetDesignTimeHtml();
}
catch (Exception ex)
{
markup = GetErrorDesignTimeHtml(ex);
}
finally
{
// Restore the properties to their original settings.
myGV.BorderStyle = oldBorderStyle;
myGV.BorderWidth = oldBorderWidth;
myGV.BorderColor = oldBorderColor;
}
}
else
// Call the base method to generate the markup.
markup = base.GetDesignTimeHtml();
// Look for a <caption> tag.
if ((charX = markup.IndexOf(capTag)) > 0)
{
// Replace the first caption with
// "tr><td colspan=9 align=center".
// It is okay if the colspan exceeds the
// number of columns in the table.
markup = markup.Remove(charX,
capTag.Length).Insert(charX, trOpen);
// Replace the second caption with "td></tr".
if ((charX = markup.IndexOf(capTag, charX)) > 0)
markup = markup.Remove(charX,
capTag.Length).Insert(charX, trClose);
}
return markup;
} // GetDesignTimeHtml
private void DownButton_Click(object sender, RoutedEventArgs e)
{
MyGridView.SmoothScrollNavigation(105, ScrollNavigationDirection.Down);
}
private void bindGridview(GridView gridview, MyGridView myGridView, Label lblCurrentPath)
{
gridview.DataSource = populateGridView(myGridView, lblCurrentPath);
gridview.DataBind();
myGridView.Gridview = gridview;
}
public void setMyEvent(object sender, MyGridView myGVSource, MyGridView myGVDestination)
{
this.MyGVSource = myGVSource;
this.MyGVDestination = myGVDestination;
setMyGridView(sender);
}
