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