public void openQueryer(string conectionString, string conName) { try { Datasource QueryerDS = new Datasource(conectionString, conName); if (QueryerDS.isConnected() == true) { QueryerForm QueryerQ = new QueryerForm(QueryerDS, "mid"); if (QueryerQS != null) { QueryerQ.index = QueryerQS.Length; } if (QueryerADS != null) { QueryerDS.index = QueryerADS.Length; } QueryerQ.nameindex = "Queryer" + QueryerQ.index; QueryerQ.MdiParent = this; QueryerQ.Show(); QueryerQ.Focus(); QueryerQS = QueryerQS.AddItemToArray(QueryerQ); QueryerADS = QueryerADS.AddItemToArray(QueryerDS); } } catch (Exception err) { errorLog(System.Reflection.MethodBase.GetCurrentMethod().Name, err); } }
private void SearchForm_KeyDown(object sender, KeyEventArgs e) { if (e.Control && e.KeyCode == Keys.R) { searchColumns = searchColumns.Clear(); foreach (object col in columnBox.CheckedItems) { searchColumns = searchColumns.AddItemToArray(col.ToString()); } Form f = SearchGrid.FindForm(); if (f.GetType() == typeof(QueryForm)) { QueryForm SearchParent = (QueryForm)f; offset = SearchParent.doReplace(searchBox.Text.ToString(), replaceBox.Text.ToString(), offset, exactChk.Checked, caseSensetiveChk.Checked, searchColumns); } if (f.GetType() == typeof(QueryerForm)) { QueryerForm SearchParent = (QueryerForm)f; offset = SearchParent.doReplace(searchBox.Text.ToString(), replaceBox.Text.ToString(), offset, exactChk.Checked, caseSensetiveChk.Checked, searchColumns); } } if (e.KeyCode == Keys.Escape) { this.DialogResult = DialogResult.OK; this.Close(); } }
private void SearchForm_KeyDown(object sender, KeyEventArgs e) { if (e.Control && e.KeyCode == Keys.R) { searchColumns = searchColumns.Clear(); foreach (object col in columnBox.CheckedItems) { searchColumns = searchColumns.AddItemToArray(col.ToString()); } Form f = FilterGrid.FindForm(); if (f.GetType() == typeof(QueryForm)) { QueryForm FilterParent = (QueryForm)f; offset = FilterParent.doAutocase(caseBox.Text, offset, searchColumns); } if (f.GetType() == typeof(QueryerForm)) { QueryerForm FilterParent = (QueryerForm)f; offset = FilterParent.doAutocase(caseBox.Text, offset, searchColumns); } } if (e.KeyCode == Keys.Escape) { this.DialogResult = DialogResult.OK; this.Close(); } }
void OnValidate() { if (isParent) { // if there is a sprite component on here too, consider it a child as well childrenSprites = transform.GetComponentsInChildren <SpriteRenderer>(true); SpriteRenderer sr = GetComponent <SpriteRenderer>(); if (sr != null) { childrenSprites = childrenSprites.AddItemToArray(sr); } } }
public void errorLog(String Class, Exception ErrorMsg) { try { Error = Error.AddItemToArray(DateTime.UtcNow.ToString("yyyy-MM-dd HH:mm:ss") + " [" + Class + "] " + ErrorMsg.Message); } catch (Exception e) { Console.Write(e.Message); } try { using (var bugform = new BugReportForm(Error)) { var result = bugform.ShowDialog(); if (result == DialogResult.OK) { } } } catch (Exception err) { errorLog(System.Reflection.MethodBase.GetCurrentMethod().Name, err); } }
private void SearchBtn_Click(object sender, EventArgs e) { searchColumns = searchColumns.Clear(); foreach (object col in columnBox.CheckedItems) { searchColumns = searchColumns.AddItemToArray(col.ToString()); } Form f = SearchGrid.FindForm(); if (f.GetType() == typeof(QueryForm)) { QueryForm SearchParent = (QueryForm)f; offset = SearchParent.doReplace(searchBox.Text.ToString(), replaceBox.Text.ToString(), offset, exactChk.Checked, caseSensetiveChk.Checked, searchColumns); } if (f.GetType() == typeof(QueryerForm)) { QueryerForm SearchParent = (QueryerForm)f; offset = SearchParent.doReplace(searchBox.Text.ToString(), replaceBox.Text.ToString(), offset, exactChk.Checked, caseSensetiveChk.Checked, searchColumns); } }
private void SearchBtn_Click(object sender, EventArgs e) { searchColumns = searchColumns.Clear(); foreach (object col in columnBox.CheckedItems) { searchColumns = searchColumns.AddItemToArray(col.ToString()); } Form f = HashGrid.FindForm(); if (f.GetType() == typeof(QueryForm)) { QueryForm HashParent = (QueryForm)f; offset = HashParent.doHash(caseBox.Text, offset, searchColumns); } if (f.GetType() == typeof(QueryerForm)) { QueryerForm HashParent = (QueryerForm)f; offset = HashParent.doHash(caseBox.Text, offset, searchColumns); } }
private void textBox1_TextChanged(object sender, EventArgs e) { offset = 0; if (searchBox.Text.Length > 2) { searchColumns = searchColumns.Clear(); foreach (object col in columnBox.CheckedItems) { searchColumns = searchColumns.AddItemToArray(col.ToString()); } Form f = SearchGrid.FindForm(); if (f.GetType() == typeof(QueryForm)) { QueryForm SearchParent = (QueryForm)f; offset = SearchParent.doSearch(searchBox.Text.ToString(), offset, exactChk.Checked, caseSensetiveChk.Checked, searchColumns); } if (f.GetType() == typeof(QueryerForm)) { QueryerForm SearchParent = (QueryerForm)f; offset = SearchParent.doSearch(searchBox.Text.ToString(), offset, exactChk.Checked, caseSensetiveChk.Checked, searchColumns); } } }
public void tryConvert2(bool preview) { //try { string[] Columns = new string[0]; object[] Rows = new string[0]; string[] Row = new string[0]; string lines = ""; string trylines = ""; string line = ""; int maxtrylines = 1000 * 100000; int maxtryrecords = 100000; if (preview == true) { maxtrylines = 1000; maxtryrecords = 3; } int records = 0; int linenum = 0; int pos = 0; int startPos = 0; int endPos = 0; bool startFound = false; bool endFound = false; int ColumnsDone = 0; convertGrid.Rows.Clear(); convertGrid.Columns.Clear(); StreamReader tmpf = new StreamReader(filename.Text); StringBuilder sb = new StringBuilder(); while (line != null && linenum < maxtrylines && records < maxtryrecords) { string recordString = ""; line = tmpf.ReadLine(); lines += line + "\n"; trylines = lines; if (trylines != "") { if (prefix.Text.Length > 0) { trylines = trylines.Replace(prefix.Text, ""); } if (subfix.Text.Length > 0) { trylines = trylines.Replace(subfix.Text, ""); } if (strip.Text.Length > 0) { trylines = trylines.Replace(strip.Text, ""); } if (trylines.Contains(start.Text) && startFound == false) { startFound = true; startPos = trylines.IndexOf(start.Text, pos); pos = startPos; } if (trylines.Contains(end.Text) && endFound == false && startFound == true) { endFound = true; endPos = trylines.IndexOf(end.Text, pos); pos = endPos; } if (startFound == true && endFound == true) { recordString = trylines.Substring(startPos, endPos - startPos + 1); lines = ""; pos = 0; startFound = false; endFound = false; startPos = 0; endPos = 0; records++; Row = Row.Clear(); recordString = recordString.Replace(start.Text, ""); recordString = recordString.Replace(end.Text, ""); string[] rawlines = recordString.Split(seperator.Text.ToCharArray()); //Columns if (Columns.Count() == 0) { foreach (string rawline in rawlines) { string rline = rawline.Replace("\n", ""); rline = rline.TrimEnd(); rline = rline.TrimStart(); string[] rawcol = rline.Split(delimiter.Text.ToCharArray()); if (rawcol.Count() == 3) { if (Columns.Contains(rawcol[0].Trim()) == false) { Columns = Columns.AddItemToArray(rawcol[0].Trim()); } else { break; } } } foreach (string col in Columns) { convertGrid.Columns.Add(col.ToString(), col.ToString()); } if (ColumnsDone == 0) { ColumnsDone = 1; } if (preview == false && ColumnsDone == 1) { sb.AppendLine(string.Join(";", Columns)); File.Delete(outputFile); File.WriteAllText(outputFile, sb.ToString()); sb.Clear(); ColumnsDone = 2; } } //Rows foreach (string rawline in rawlines) { string rline = rawline.Replace("\n", ""); rline = rline.TrimEnd(); rline = rline.TrimStart(); string[] rawcol = rline.Split(delimiter.Text.ToCharArray()); if (rawcol == null) { rawcol.AddItemToArray(""); } if (rawcol.Count() == 3) { Row = Row.AddItemToArray(rawcol[2].Trim()); if (Row.Count() == Columns.Count()) { Rows = Rows.AddItemToArray(Row); DataGridViewRow gvrawRow = (DataGridViewRow)convertGrid.Rows[0].Clone(); int i = 0; foreach (string rcol in Row) { if (gvrawRow.Cells.Count > i) { gvrawRow.Cells[i].Value = rcol.ToString(); } else { gvrawRow.Cells[i].Value = rcol.ToString(); } i++; } convertGrid.Rows.Add(gvrawRow); if (preview == false) { sb.AppendLine(string.Join(";", Row)); File.AppendAllText(outputFile, sb.ToString()); sb.Clear(); } Row = Row.Clear(); } } } } } linenum++; fileBox.Text = trylines; Application.DoEvents(); } fileBox.Text = trylines; tmpf.Close(); //} catch(Exception err) { // thrawRow err; //} }
public int LoadCsvDataIntoSqlServer(string fileName, bool withTruncate) { using (var db = new DomainsEntities()) { var srcs = db.tbSrcs.ToDictionary(g => g.Name, g => g.Id); var sts = db.tbStatus.ToDictionary(g => g.Name, g => g.Id); var createdCount = 0; var fn = string.Format("{0}\\{1}", _outputFolder, fileName); using (var textFieldParser = new TextFieldParser(fn)) { textFieldParser.TextFieldType = FieldType.Delimited; textFieldParser.Delimiters = new[] { "," }; textFieldParser.HasFieldsEnclosedInQuotes = true; var dataTable = new DataTable("tbDomainsFromSrc"); // Add the columns in the temp table dataTable.Columns.Add("Domain"); dataTable.Columns.Add("Price"); dataTable.Columns.Add("ExpDate");//, typeof(DateTime)); dataTable.Columns.Add("Source", typeof(Int32)); dataTable.Columns.Add("IdInSource"); dataTable.Columns.Add("Age"); dataTable.Columns.Add("Status", typeof(Int32)); dataTable.Columns.Add("SrcFile"); // dataTable.Columns.Add("Name"); dataTable.Columns.Add("Tld"); dataTable.Columns.Add("Length"); using (var sqlConnection = new SqlConnection(_connectionString)) { sqlConnection.Open(); if (withTruncate) { // Truncate the live table using (var sqlCommand = new SqlCommand(_truncateLiveTableCommandText, sqlConnection)) { sqlCommand.ExecuteNonQuery(); } } // Create the bulk copy object var sqlBulkCopy = new SqlBulkCopy(sqlConnection) { DestinationTableName = "tbDomainsFromSrc" }; // Setup the column mappings, anything ommitted is skipped sqlBulkCopy.ColumnMappings.Add("Domain", "Domain"); sqlBulkCopy.ColumnMappings.Add("Price", "Price"); sqlBulkCopy.ColumnMappings.Add("ExpDate", "ExpDate"); sqlBulkCopy.ColumnMappings.Add("Source", "Source"); sqlBulkCopy.ColumnMappings.Add("IdInSource", "IdInSource"); sqlBulkCopy.ColumnMappings.Add("Age", "Age"); sqlBulkCopy.ColumnMappings.Add("SrcFile", "SrcFile"); sqlBulkCopy.ColumnMappings.Add("Status", "Status"); // sqlBulkCopy.ColumnMappings.Add("Name", "Name"); sqlBulkCopy.ColumnMappings.Add("Tld", "Tld"); sqlBulkCopy.ColumnMappings.Add("Length", "Length"); // Loop through the CSV and load each set of 100,000 records into a DataTable // Then send it to the LiveTable while (!textFieldParser.EndOfData) { string[] temp = textFieldParser.ReadFields(); if (createdCount > 0) { temp[0] = temp[0].ToLower(); if (temp.Length > 7) { temp = MergeItemsInArray(temp, 1);// for price with comma } // add src temp = temp.AddItemToArray(fileName.Replace(".csv", "")); // prepare date temp[2] = GetDateValue(temp[2]); // src & status temp[3] = Convert.ToString(srcs[temp[3]]); temp[6] = Convert.ToString(sts[temp[6]]); // 3 calc fields var name = temp[0].Split('.')[0]; var tld = temp[0].Substring(temp[0].IndexOf('.') + 1); temp = temp.AddItemToArray(name); temp = temp.AddItemToArray(tld); temp = temp.AddItemToArray(name.Length.ToString()); //temp[temp.Length] = fileName; dataTable.Rows.Add(temp); //dataTable.Rows.Add(textFieldParser.ReadFields()); } createdCount++; if (createdCount % _batchSize == 0 && createdCount > 0) { InsertDataTable(sqlBulkCopy, sqlConnection, dataTable); //break; } } // Don't forget to send the last batch under 100,000 InsertDataTable(sqlBulkCopy, sqlConnection, dataTable); sqlConnection.Close(); return(createdCount); // dataTable.Rows.Count; } } } }