private void RefreshDefinition()
{
filterManager = null;
filterManager = new DgvFilterManager();
alarm_definition = m_ds.GetAlarmDefinition();
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGridView1.DataSource = new DataTable();
dataGridView1.DataSource = alarm_definition;
dataGridView1.Columns["id"].ReadOnly = true;//.Visible = false;
DataGridViewComboBoxColumn c = new DataGridViewComboBoxColumn();
c.DataSource = alarm_definition;
c.Name = alarm_definition.listColumn.ColumnName;
c.ValueMember = "list";
c.DisplayMember = "list";
c.DataSource = m_ds.GetList();
c.DataPropertyName = "list";
dataGridView1.Columns["list"].Visible = false;
dataGridView1.Columns.Insert(1, c);
filterManager.DataGridView = dataGridView1;
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
}
public Form1(string[] args)
{
InitializeComponent();
this.Icon = Properties.Resources.Ryder25;
LNG = new DataSet("language");
fRF = new FindAndReplaceForm(this.lngDataGridView);
filePath = openFileDialog.FileName;
lngDataGridView.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
lngDataGridView.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.DisplayedCells;
lngDataGridView.DefaultCellStyle.WrapMode = DataGridViewTriState.True;
lngDataGridView.AllowUserToAddRows = false;
lngDataGridView.AlternatingRowsDefaultCellStyle.BackColor = System.Drawing.ColorTranslator.FromHtml("#E8EDFF");
DgvFilterManager dgvfm = new DgvFilterManager(lngDataGridView);
// Open With
if (args.Length > 0)
{
if (File.Exists(args[0]) == true)
{
filePath = args[0];
Stream s = File.Open(filePath, FileMode.Open, FileAccess.Read, FileShare.Read);
lngFile = new LngFile(s);
lngDataGridView.DataSource = lngFile.GetDataTable();
this.Text = "Ego Language Editor - " + filePath;
}
}
}
private void Fill()
{
DocumentPaymentsLogic payments = new DocumentPaymentsLogic(manager);
DataGV.AutoGenerateColumns = false;
ListToDataTable listToDataTable = new ListToDataTable();
List <ViewPayment> paymentsList = new List <ViewPayment>();
if (documentId == null)
{
paymentsList = payments.GetAllViewByPeriod(StartDateDTP.Value, EndDateDTP.Value);
}
else
{
paymentsList = payments.GetAllViewByDocumentID(Convert.ToInt32(documentId));
StartDateDTP.Enabled = false;
EndDateDTP.Enabled = false;
}
DataGV.DataSource = listToDataTable.ToDataTable <ViewPayment>(paymentsList);
DgvFilterManager filterManager = new DgvFilterManager(DataGV);
DataGV.Update();
SummaryDataGV.AutoGenerateColumns = true;
var groupResult = from p in paymentsList
group p by new { p.FullEmployeeName, p.PaymentTypeName }
into myGroup
where myGroup.Count() > 0
select new { myGroup.Key.FullEmployeeName, myGroup.Key.PaymentTypeName, Count = myGroup.Count(), Suma = myGroup.Sum(a => a.Suma) };
SummaryDataGV.DataSource = groupResult.ToList();
SummaryDataGV.Update();
}
private void btnConnectQc_Click(object sender, EventArgs e)
{
Cursor.Current = Cursors.WaitCursor;
dgvALM.AutoGenerateColumns = false;
dtALMTestDetails = BuildDataTable();
treeViewALM.Nodes.Clear();
progressBar1.Value = 0;
btnConnectALM.Enabled = false;
if (conn == null)
{
connectToQC();
}
if (conn != null)
{
if (conn.Connected)
{
showTestLabTree();
}
else
{
MessageBox.Show("QC Connection Failed!");
}
}
btnConnectALM.Enabled = true;
DgvFilterManager filterManager = new DgvFilterManager(dgvALM, true);
Cursor.Current = Cursors.Default;
}
private void frmOtherWorks_Shown(object sender, EventArgs e)
{
StagesFilterManager = new DgvFilterManager(dgvStages, true);
SetsFilterManager = new DgvFilterManager(dgvSets, true);
OtherWorksFilterManager = new DgvFilterManager(dgvOtherWorks, true);
dgvStages.ClearSelection();
}
public FormSAPDataTable()
{
InitializeComponent();
DgvFilterManager fm = new DgvFilterManager();
fm.ColumnFilterAdding += fm_ColumnFilterAdding;
fm.DataGridView = dataGridView1;
this.Shown += FormSAPDataTable_Shown;
}
void fm_PopupShowing(object sender, ColumnFilterEventArgs e)
{
DgvFilterManager fm = ((DgvFilterManager)sender);
Rectangle HeaderRectangle = fm.DataGridView.GetCellDisplayRectangle(e.Column.Index, -1, true);
//Show the popup under the column header
fm.FilterHost.Popup.Show(fm.DataGridView, HeaderRectangle.Left, HeaderRectangle.Bottom);
e.Handled = true;
}
private void RefreshLog()
{
filterManager = null;
filterManager = new DgvFilterManager();
int minutes = Convert.ToInt32(this.textBoxDaysBack.Text) * 1440;
this.dataGridView1.DataSource = m_ds.GetLog(minutes);
filterManager.DataGridView = dataGridView1;
}
private void Sample4_Load(object sender, EventArgs e)
{
InitGrid();
DgvFilterManager fm = new DgvFilterManager();
fm.FilterHost = new CustomizedFilterHost();
fm.DataGridView = dataGridView1;
// Customize the popup positioning.
fm.PopupShowing += new ColumnFilterEventHandler(fm_PopupShowing);
}
private void FillDataGV()
{
Compas.Logic.Config.ConfigurationParametersLogic configurationsLogic = new ConfigurationParametersLogic(manager);
ListToDataTable listToDataTable = new ListToDataTable();
DataGV.AutoGenerateColumns = false;
DataGV.DataSource = listToDataTable.ToDataTable <ViewConfigurationParameter>(configurationsLogic.GetAllView());
DgvFilterManager filterManager = new DgvFilterManager(DataGV);
DataGV.Update();
}
private void Fill()
{
CWCarsLogic cars = new CWCarsLogic(manager);
DataGV.AutoGenerateColumns = false;
ListToDataTable listToDataTable = new ListToDataTable();
DataGV.DataSource = listToDataTable.ToDataTable <CWCarView>(cars.GetAllView().ToList());
DgvFilterManager filterManager = new DgvFilterManager(DataGV);
}
public frmNoApproveSets(List <clUser> users)
{
InitializeComponent();
CreateDtUsers();
CreateDgvUsers();
FillDtUsers(users);
dgvChangeDepartmentUser.DataSource = _dtUsers;
UsersFilterManager = new DgvFilterManager(dgvChangeDepartmentUser);
}
public FormReadTable()
{
InitializeComponent();
this.readTableControl1.EventMessage += readTableControl1_EventMessage;
this.readTableControl1.EventGetTable += readTableControl1_EventGetTable;
DgvFilterManager fm = new DgvFilterManager();
fm.ColumnFilterAdding += fm_ColumnFilterAdding;
fm.DataGridView = dataGridView1;
this.textboxLog.KeyDown += textboxLog_KeyDown;
}
private void Sample5_Load(object sender, EventArgs e)
{
// Use this static property to set your culture-specific months naming. Default is full-named english months
DgvMonthYearColumnFilter.MonthCsvList = "Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec";
DgvFilterManager fm = new DgvFilterManager(dataGridView1);
InitGrid();
fm["CustomerId"] = new CustomizedColumnFilter();
fm["RequiredDate"] = new DgvDateRangeColumnFilter();
fm["OrderId"] = new DgvNumRangeColumnFilter();
fm["OrderDate"] = new DgvMonthYearColumnFilter();
((DgvMonthYearColumnFilter)fm["OrderDate"]).YearMin = 2007;
}
private void MainForm_Load(object sender, System.EventArgs e)
{
nameTA.Fill(this.dbDataSet.name);
DgvFilterManager filterManager = new DgvFilterManager(dataGridView1);
dgv.SetGroupOn("phone");
outlookGrid1.BindData(dbDataSet,"name");
outlookGrid1.GroupTemplate = new OutlookGridAlphabeticGroup();
outlookGrid1.GroupTemplate.Column = phoneDataGridViewTextBoxColumn;
outlookGrid1.GroupTemplate.Collapsed = true;
//used custom datarowcomparer
outlookGrid1.Sort(new DataRowComparer(4,ListSortDirection.Ascending));
}
public ImportNrcsSnotel()
{
InitializeComponent();
filterManager = new DgvFilterManager();
var tbl = NrcsSnotelSeries.SnotelSites;
dataGridView1.DataSource = null;
this.dataGridView1.DataSource = tbl;
this.dataGridView1.SelectionChanged += new EventHandler(dataGridView1_SelectionChanged);
dataGridView1.DataError += dataGridView1_DataError;
filterManager.DataGridView = dataGridView1;
buttonOk.Enabled = false;
}
private void Fill()
{
CardsLogic cardsLogic = new CardsLogic(manager);
DataGV.AutoGenerateColumns = false;
List <CardView> view = cardsLogic.GetAll().Select(a => new CardView(a)).ToList();
ListToDataTable listToDataTable = new ListToDataTable();
DataGV.DataSource = listToDataTable.ToDataTable <CardView>(view);
DgvFilterManager filterManager = new DgvFilterManager(DataGV);
DataGV.Update();
}
private void Sample3_Load(object sender, EventArgs e)
{
InitGrid();
DgvFilterManager fm = new DgvFilterManager();
// Using the ColumnFilterAdding event, you may force your preferred filter,
// BEFORE the FilterManager create the predefined filter. This event is
// raised for each column in the grid when you set the DataGridView property
// of the FilterManager.
fm.ColumnFilterAdding += new ColumnFilterEventHandler(fm_ColumnFilterAdding);
fm.DataGridView = dataGridView1; // this raises ColumnFilterAdding events
// After column filters creation however, you can overwrite the created filter.
fm["CustomerID"] = new DgvComboBoxColumnFilter();
}
/// <summary>
/// Loads table of equations from the database.
/// </summary>
private void LoadTable()
{
filterManager = new DgvFilterManager();
tbl = Database.DB().GetSeriesCatalog("Provider ='CalculationSeries'");
this.dataGridView1.DataSource = new DataTable();
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.None;
this.dataGridView1.DataSource = tbl;
var cols = this.dataGridView1.Columns;
var visible = new string[] { "Units", "TimeInterval", "Name", "TableName", "Expression" };
for (int i = 0; i < cols.Count; i++)
{
cols[i].Visible = Array.IndexOf(visible, cols[i].Name) >= 0;
}
dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
filterManager.DataGridView = dataGridView1;
}
private void Sample2_Load(object sender, EventArgs e)
{
InitGrid();
DgvFilterManager fm = new DgvFilterManager();
fm.DataGridView = dataGridView1; //after this line, column filters are created
// Get the created column filter for OrderDate column
OrderDate = ((DgvDateColumnFilter)fm["OrderDate"]);
//Add some new operators
OrderDate.ComboBoxOperator.Items.Insert(0, "This year");
OrderDate.ComboBoxOperator.Items.Insert(1, "1 year ago");
OrderDate.ComboBoxOperator.Items.Insert(2, "2 years ago");
//Change the size to accomodate the length of the new operators
OrderDate.ComboBoxOperator.Width += 30;
OrderDate.DateTimePickerValue.Width -= 30;
OrderDate.DateTimePickerValue.Location = new Point(OrderDate.DateTimePickerValue.Left + 30, OrderDate.DateTimePickerValue.Top);
OrderDate.FilterExpressionBuilding += new CancelEventHandler(OrderDate_FilterExpressionBuilding);
}
private void LoadData()
{
filterManager = null;
filterManager = new DgvFilterManager();
table = null;
string tableName = "";
try
{
tableName = this.comboBoxTableNames.Text;
table = m_server.Table(m_server.PortableTableName(tableName));
this.dataGrid1.DataSource = table;
this.dataGrid1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells;
//this.dataGrid1.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.AutoSize;
filterManager.DataGridView = this.dataGrid1;
}
catch (Exception ex)
{
Logger.WriteLine(ex.Message);
MessageBox.Show(ex.Message);
}
}
private void btnConnectJenkins_Click(object sender, EventArgs e)
{
Cursor.Current = Cursors.WaitCursor;
username = txtUserName.Text;
password = txtPasswpord.Text;
btnConnectJenkins.Enabled = false;
dgvJenkins.AutoGenerateColumns = false;
progressBar2.Value = 0;
joblist = new List <string>();
JenkinServers = new Dictionary <string, List <string> >();
spreadsheetsService = new SpreadsheetsService("AlmJenkinsIntegration");
if (txtUserName.Text.Contains("ngahr"))
{
//oAuth2();
NGAMail();
}
else
{
oAuth2();
//spreadsheetsService.setUserCredentials(txtUserName.Text, txtPasswpord.Text);
}
//Passing Spreadsheet Name
SpreadsheetQuery spreadsheetQuery = new SpreadsheetQuery();
spreadsheetQuery.Title = txtSpreadSheetName.Text;
spreadsheetFeed = spreadsheetsService.Query(spreadsheetQuery);
if (spreadsheetFeed.Entries.Count != 1)
{
MessageBox.Show("Invallid Spreadsheet Name!");
btnConnectJenkins.Enabled = true;
return;
}
AtomLink link = spreadsheetFeed.Entries[0].Links.FindService(GDataSpreadsheetsNameTable.WorksheetRel, null);
WorksheetQuery worksheetQuery = new WorksheetQuery(link.HRef.ToString());
//Passing Worksheet Name
worksheetQuery.Title = txtWorkSheetName.Text;
worksheetFeed = spreadsheetsService.Query(worksheetQuery);
if (worksheetFeed.Entries.Count != 1)
{
MessageBox.Show("Invallid Worksheet Name!");
btnConnectJenkins.Enabled = true;
return;
}
UpdateListFeed();
// define the table's schema
dtJenkinsTestDetails = new DataTable();
dtJenkinsTestDetails.Columns.Add(new DataColumn("TestName", typeof(string)));
dtJenkinsTestDetails.Columns.Add(new DataColumn("Result", typeof(string)));
dtJenkinsTestDetails.Columns.Add(new DataColumn("JenkinsLog", typeof(string)));
dtJenkinsTestDetails.Columns.Add(new DataColumn("ALM", typeof(string)));
foreach (ListEntry worksheetRow in listFeed.Entries)
{
string serverName = worksheetRow.Elements[0].Value.ToString();
if (serverName != string.Empty && serverName.ToLower() != "server" && !JenkinServers.ContainsKey(serverName))
{
JenkinServers.Add(serverName, GetInnerJobs(serverName, listFeed.Entries));
}
DataRow dr = dtJenkinsTestDetails.NewRow();
dr["TestName"] = worksheetRow.Elements[3].Value.ToString();
dr["Result"] = worksheetRow.Elements[4].Value.ToString();
dr["JenkinsLog"] = worksheetRow.Elements[6].Value.ToString();
dr["ALM"] = worksheetRow.Elements[7].Value.ToString();
dtJenkinsTestDetails.Rows.Add(dr);
}
progressBar2.Maximum = JenkinServers.Count;
progressBar2.PerformStep();
BuildJenkinsTree();
dgvJenkins.DataSource = dtJenkinsTestDetails;
lblTestsCount.Text = dtJenkinsTestDetails.Rows.Count.ToString();
lblJobTitle.Text = string.Empty;
DgvFilterManager filterManager = new DgvFilterManager(dgvJenkins, true);
btnConnectJenkins.Enabled = true;
Cursor.Current = Cursors.Default;
}
private void SetupGridViewFilter()
{
filterManager = new DgvFilterManager(dgvData);
}
private void toolStripButtonRefresh_Click(object sender, EventArgs e)
{
try
{
Cursor = Cursors.WaitCursor;
Application.DoEvents();
filterManager = null;
filterManager = new DgvFilterManager();
m_viewTable = Server.Table(baseTableName + "x", this.sqlView);
m_table = Server.Table(baseTableName, "select * from " + baseTableName + " where 2 = 1");
m_viewTable.TableNewRow += m_viewTable_TableNewRow;
//var col = m_viewTable.Columns[0];
//col.AllowDBNull = false;
//col.AutoIncrement = true;
//col.AutoIncrementSeed = -999;
//col.AutoIncrementStep = 1;
this.dataGridView1.DataSource = null;
this.dataGridView1.Columns.Clear();
if (LinkLabelPrimaryKey)
{
var lc = new DataGridViewLinkColumn();
lc.DataPropertyName = m_table.Columns[0].ColumnName;
this.dataGridView1.Columns.Add(lc);
}
this.dataGridView1.DataSource = m_viewTable;
this.dataGridView1.DataError += dataGridView1_DataError;
// Make referenced columns readonly
dataGridView1.Columns[0].ReadOnly = true; // primary key
for (int i = 1; i < m_viewTable.Columns.Count; i++)
{
string colName = m_viewTable.Columns[i].ColumnName;
if (m_table.Columns.IndexOf(colName) < 0)
{
dataGridView1.Columns[colName].ReadOnly = true;
}
else
{
dataGridView1.Columns[colName].ReadOnly = false;
}
}
for (int i = 0; i < comboBoxTableNames.Count; i++)
{
var tbl = Server.Table(baseTableName, "select " + valueMembers[i]
+ ", " + displayMembers[i] + " from " + comboBoxTableNames[i]);
DataGridViewComboBoxColumn c = new DataGridViewComboBoxColumn();
c.DataSource = tbl;
c.Name = displayMembers[i];
c.DataPropertyName = SourceValueName(i);
c.ValueMember = SourceValueName(i);
c.DisplayMember = displayMembers[i];
//DataGridViewTextBoxColumn tc = new DataGridViewTextBoxColumn();
if (hideMemberValues[i])
{
dataGridView1.Columns[SourceValueName(i)].Visible = false;
}
this.dataGridView1.Columns.Insert(columnIndexes[i], c);
//m_table.Columns.Add("s" + displayMembers[i]);
}
filterManager.DataGridView = dataGridView1;
}
finally
{
Cursor = Cursors.Default;
}
}
private void Fill(string columnName)
{
DateTime start = DateTime.Now;
WaresLogic wares = new WaresLogic(manager);
DataGV.AutoGenerateColumns = false;
int?categoryId = null;
int?manufacturerId = null;
int?unitId = null;
//string name = wareFilterUC1.WareName;
if (categoriesFilterUC1.SelectedCategoryID >= 0)
{
categoryId = categoriesFilterUC1.SelectedCategoryID;
}
//manufacturerId = wareFilterUC1.ManufacturerID;
//unitId = wareFilterUC1.UnitID;
BindingSource bs = new BindingSource();
var waresList = wares.GetAllView("", categoryId, manufacturerId, unitId);
// .Select(a => new
//{
// a.ID,
// Name = a.Name,
// UnitName = a.WareUnit != null ? a.WareUnit.Name : "",
// ManufacturerName = a.WareManufacturer != null ? a.WareManufacturer.Name : "",
// CategoryName = a.WareCategory != null ? a.WareCategory.Name : "",
// CategoryID = a.CategoryID,
// SecondaryUnitID = a.SecondaryUnitID != null ? a.SecondaryUnitID : null,
// SecondaryUnitName = a.WareUnit1 != null ? a.WareUnit1.Name : "",
// SecondaryUnitQuantity = a.SecondaryUnitQuantity != null ? a.SecondaryUnitQuantity : null,
// a.WareCodes,
// a.WareTimeLimits
//});//.OrderBy(a => a.CategoryName).ThenBy(a=> a.Name).ToList();
//List<WareView> viewList = new List<WareView>();
DateTime start0 = DateTime.Now;
//foreach (var a in waresList)
//{
// WareView wv = new WareView();
// wv.ID = a.ID;
// wv.CategoryID = a.CategoryID;
// wv.Name = a.Name;
// wv.CategoryName = a.CategoryName;
// wv.ManufacturerName = a.ManufacturerName;
// wv.UnitName = a.UnitName;
// wv.SecondaryUnitID = a.SecondaryUnitID;
// wv.SecondaryUnitName = a.SecondaryUnitName;
// wv.SecondaryUnitQuantity = a.SecondaryUnitQuantity;
// //wv.WareCodes = a.WareCodes.ToList();
// //var lastTimeLimit = (from aa in a.WareTimeLimits
// // where aa.Active == true
// // select aa).FirstOrDefault();
// //if (lastTimeLimit != null)
// // wv.TimeLimit = lastTimeLimit.TimeLimit;
// //else
// // wv.TimeLimit = 0;
// viewList.Add(wv);
//}
DateTime start1 = DateTime.Now;
//BindingListView<WareView> view = new BindingListView<WareView>(viewList);
//bs.DataSource = view;
//bs.Sort = columnName;
view = new SortableBindingList <ViewWare>(waresList);
ListToDataTable listToDataTable = new ListToDataTable();
DataGV.DataSource = listToDataTable.ToDataTable <ViewWare>(waresList);
//DataGV.DataSource = view;
DataGV.Update();
DgvFilterManager filterManager = new DgvFilterManager(DataGV);
DateTime start2 = DateTime.Now;
//MessageBox.Show(start.ToString() + " " + start0.ToString() + " " + start1.ToString() + " " + start2.ToString());
}
