public Dictionary <string, string> ColumnLikelihood(string SchemaName, string SchemaCoumnName, string InputCoumnName, int ColumnPosition)
{
MongoCollection <EmployeeSchema> collection = database.GetCollection <EmployeeSchema>("KPEmployeeSchema");
var query = Query <EmployeeSchema> .EQ(e => e.Name, SchemaName);
EmployeeSchema objEmployeeSchema = collection.Find(query).FirstOrDefault();
string ReferenceColumn = string.Empty;
Dictionary <string, string> ColumnReferencePair = new Dictionary <string, string>();
if (objEmployeeSchema != null)
{
List <string[]> ColummReferenceTableArray = objEmployeeSchema.ReferenceTable;
string ReferenceTable = ColummReferenceTableArray[ColumnPosition][1];
if (ReferenceTable != "KPPassThroughDictionary")
{
MongoCollection <EmployeeReference> ReferenceTablecollection = database.GetCollection <EmployeeReference>(ReferenceTable);
var EmployeeQuery = Query <EmployeeReference> .EQ(e => e.Key, InputCoumnName);
EmployeeReference objEmployeeReference = ReferenceTablecollection.Find(EmployeeQuery).FirstOrDefault();
if (objEmployeeReference != null)
{
ReferenceColumn = objEmployeeReference.Reference;
}
ColumnReferencePair.Add(objEmployeeSchema.Data[ColumnPosition][1], ReferenceColumn);
}
else
{
ColumnReferencePair.Add(objEmployeeSchema.Data[ColumnPosition][1], InputCoumnName);
}
}
return(ColumnReferencePair);
}
public List <EmployeeSample> InsertEmployeeSchema(EmployeeSchema EmpSchema)
{
List <EmployeeSample> EmpoyeeList = new List <EmployeeSample>();
string[] lines = System.IO.File.ReadAllLines(@"G:\VS2013 Projects\ASP MVC\KuttyPayan\KuttyPayan.DBReaderLibrary\DBInput\EmployeeInput.txt");
foreach (string line in lines)
{
EmployeeSample objEmpoyee = new EmployeeSample();
string InputData = line;
string[] Words = InputData.Split('\t');
int EmpID = Convert.ToInt32(Words[0].Trim());
string EmpName = Words[1].Trim();
string EmpDesig = Words[2].Trim();
string EmpAddr = Words[3].Trim();
objEmpoyee.EmpId = EmpID;
objEmpoyee.EmpName = EmpName;
objEmpoyee.EmpDesig = EmpDesig;
objEmpoyee.EmpAddress = EmpAddr;
EmpoyeeList.Add(objEmpoyee);
}
return(EmpoyeeList);
}
