internal static void Response(Section section, string name)
{
try
{
//Create list of skills
List <string> skillsList = new List <string>();
List <string> expList = new List <string>();
//Get text from tables
skillsList = HelpersMethods.GetTextFromTable(section.Tables[0]); //table with skills
expList = HelpersMethods.GetTextFromTable(section.Tables[1]); // table with exp
#if OLD_PARSE_DEBUG_SKILL
foreach (string s in skillsList)
{
Console.WriteLine(s);
}
#endif
#if OLD_PARSE_DEBUG_EXP
foreach (string s in expList)
{
Console.WriteLine(s);
}
#endif
Console.WriteLine("Parse complete " + name);
//Split and save exp
var expModelList = Helpers.ProcessExps.ProccExp(expList);
expModelList.AddRange(ProcessSkills.ProccSkills(skillsList));
//Processing and save expearence
#if OLD_PARSE_DEBUG_SKILLS_AND_EXP
foreach (ModelSkill s in skillsModelList)
{
Console.WriteLine(s.name + " " + s.level + " " + s.type + " " + s.allNames.Count.ToString());
}
#endif
//HelpersMethods.DeleteSimilarSkills(ref expModelList);
//HelpersMethods.CheckLeadSkill(ref expModelList);
string connectionString = "mongodb://*****:*****@ds046667.mlab.com:46667/workers_db";
MongoClient client = new MongoClient(connectionString);
IMongoDatabase database = client.GetDatabase("workers_db");
database.CreateCollection(name);
var colSkills = database.GetCollection <ModelSkill>(name);
var colLevels = database.GetCollection <SkillLevel>(name + "Lvl");
var data = HelpersMethods.ToModelSkills(expModelList);
colSkills.InsertMany(data.Item1.ToArray());
colLevels.InsertMany(data.Item2.ToArray());
}
catch (Exception ex)
{
Console.WriteLine("EXCEPTION HERE " + name + "\n" + ex.Message);
}
}
internal static void Response(Section section, string name)
{
try
{
//Create list of skills
List <string> expList = new List <string>();
var skillsModelList = new List <BufferClass>();
//Get text from tables
for (int i = 0; i < 6; i++)
{
List <string> str = HelpersMethods.GetTextFromTable(section.Tables[i]);
skillsModelList.AddRange(ProcessSkills.ProccSkills(str));
Console.WriteLine(@"Parse {0} table complete", i + 1);
//After reading, create json model
}
expList = HelpersMethods.GetTextFromTable(section.Tables[7]); // table with exp
#if NEW_PARSE_DEBUG_SKILL
foreach (string s in skillsList)
{
Console.WriteLine(s);
}
foreach (string s in expList)
{
Console.WriteLine(s);
}
Console.ReadKey();
#endif
#if NEW_PARSE_DEBUG_EXP
foreach (string s in expList)
{
Console.WriteLine(s);
}
#endif
Console.WriteLine("Parse complete");
var expModelList = ProcessExps.ProccExp(expList);
expModelList.AddRange(skillsModelList);
#if NEW_PARSE_DEBUG_SKILLS_AND_EXP
foreach (ModelSkill s in skillsModelList)
{
Console.WriteLine(s.name + " " + s.level + " " + s.type + " " + s.allNames.Count.ToString());
}
#endif
//HelpersMethods.DeleteSimilarSkills(ref expModelList);
//HelpersMethods.CheckLeadSkill(ref expModelList);
string connectionString = "mongodb://*****:*****@ds046667.mlab.com:46667/workers_db";
MongoClient client = new MongoClient(connectionString);
IMongoDatabase database = client.GetDatabase("workers_db");
database.CreateCollection(name);
var colSkills = database.GetCollection <ModelSkill>(name);
var colLevels = database.GetCollection <SkillLevel>(name + "Lvl");
var data = HelpersMethods.ToModelSkills(expModelList);
colSkills.InsertMany(data.Item1.ToArray());
colLevels.InsertMany(data.Item2.ToArray());
}
catch
{
Console.WriteLine("Invalid document");
}
}
