public void writeData(string recKey, dataLine data, int logID)
{
string connectionString;
SqlConnection cnn;
connectionString = ConfigurationManager.ConnectionStrings["LoggerDB"].ConnectionString;
cnn = new SqlConnection(connectionString);
try
{
cnn.Open();
SqlCommand command;
SqlDataAdapter dataAdapter = new SqlDataAdapter();
String sql = "";
if ((data.group1.Length > 100) ||
(data.group2.Length > 100) ||
(data.group3.Length > 100) ||
(data.group4.Length > 100) ||
(data.group5.Length > 100) ||
(data.group7.Length > 100))
{
Console.WriteLine("error");
}
sql = @"INSERT INTO loginfo(logkey, group1, group2, group3, group4, group5, group6, group7, group8,prjKey, logID)
VALUES('" + recKey + "','" +
data.group1 + "','" +
data.group2 + "','" +
data.group3 + "','" +
data.group4 + "','" +
data.group5 + "','" +
data.group6 + "','" +
data.group7 + "','" +
WebUtility.HtmlEncode(data.group8 + data.group9) + "','" +
Key + "','" + logID + "')";
command = new SqlCommand(sql, cnn);
dataAdapter.InsertCommand = new SqlCommand(sql, cnn);
dataAdapter.InsertCommand.ExecuteNonQuery();
command.Dispose();
cnn.Close();
}
catch (SqlException sqlEx)
{
Console.WriteLine(sqlEx.ToString());
}
}
public void uploadLog(string filename)
{
addLogToProject(this.pKey);
int logID = attachLogToProject(this.pKey, filename);
// create dictionary
Dictionary <string, dataLine> dicData = new Dictionary <string, dataLine>();
WriteLog("c:", "test.txt", "Testing Testing");
string[] lstLines = File.ReadAllLines(filename);
int repLine = 0;
int recProcessed = 0;
int recSkipped = 0;
int readRecs = 0;
int recExtent = 0;
string prevTimeStamp = "";
long lineProcess = 0;
string strLine = null;
//foreach (string strLine in lstLines)
while (lineProcess < lstLines.Length)
{
strLine = lstLines[lineProcess];
dataLine record = new dataLine();
if (strLine == "")
{
recSkipped++;
lineProcess++;
continue;
}
if (strLine.Substring(0, 1) != "[")
{
recSkipped++;
lineProcess++;
continue;
}
lineProcess++;
while (lineProcess < lstLines.Length && lstLines[lineProcess] != "" &&
lstLines[lineProcess].Substring(0, 1) != "[")
{
strLine += lstLines[lineProcess] + System.Environment.NewLine;
lineProcess++;
}
readRecs++;
//
Regex openGroup9 = new Regex(@"(\[.*\])(\[.*\])(\[.*\])(\[.*\])(\[.*\])(\[.*\])(\[.*\])(\[.*\])?(.*)");
Regex openGroup8 = new Regex(@"(\[.*\])(\[.*\])(\[.*\])(\[.*\])(\[.*\])(\[.*\])(\[.*\])?(.*)");
Regex closeGroup = new Regex("]");
Regex dateGroup = new Regex(@"\d\d\d\d-\d\d-\d\d.\d\d:\d\d:\d\d-\d\d\d");
MatchCollection openGroupContent = openGroup9.Matches(strLine);
if (openGroupContent.Count == 0)
{
openGroupContent = openGroup8.Matches(strLine);
}
string strDate = "";
foreach (Match item in openGroupContent[0].Groups)
{
string strLineSub = "";
if (strLine.Length != item.Value.Length)
{
strLineSub = strLine.Substring(item.Value.Length, strLine.Length - item.Value.Length);
recExtent = recExtent + strLineSub.Split('\n').Length;
}
foreach (Group group in item.Groups)
{
if (group.Value == strLine)
{
recProcessed++;
continue;
}
MatchCollection matches = dateGroup.Matches(group.Value);
group.Value.Replace(@"'", @"''");
switch (group.Name)
{
case "0":
strDate = matches[0].Value;
break;
case "1":
record.group1 = group.Value.Replace(@"'", @"''");
break;
case "2":
record.group2 = group.Value.Replace(@"'", @"''");
break;
case "3":
record.group3 = group.Value.Replace(@"'", @"''");
break;
case "4":
record.group4 = group.Value.Replace(@"'", @"''");
break;
case "5":
record.group5 = group.Value.Replace(@"'", @"''");
break;
case "6":
record.group6 = group.Value.Replace(@"'", @"''");
break;
case "7":
record.group7 = group.Value.Replace(@"'", @"''");
break;
case "8":
record.group8 = group.Value.Replace(@"'", @"''") + strLineSub;
break;
default:
record.group9 = group.Value.Replace(@"'", @"''");
break;
}
if (group.Name == "1")
{
strDate = matches[0].Value;
record.group0 = matches[0].Value;
if (strDate == prevTimeStamp)
{
repLine++;
}
else
{
repLine = 0;
}
}
if (group.Name == (item.Groups.Count - 1).ToString())
{
//repLine = 0;
bool flagAdd = false;
while (!flagAdd)
{
try
{
// add the data to the dictionary
//groupsData = groupsData + group.Value + strLineSub;
//dataLine rec = new dataLine();
string recKey = strDate + "-" + repLine.ToString();
dicData.Add(recKey, record);
int recCount = dicData.Count;
// insert data into db
writeData(recKey, record, logID);
prevTimeStamp = strDate;
flagAdd = true;
//repLine++;
}
catch (System.ArgumentException e)
{
repLine++;
}
}
}
}
break;
}
}
/* Console.WriteLine("Records Processed {0}", recProcessed);
* Console.WriteLine("Records Skipped {0}", recSkipped);
* Console.WriteLine("Records read {0}", readRecs);
* Console.WriteLine("Records Extended {0}", recExtent);
* Console.ReadKey();*/
}
