static void Main(string[] args)
{
KuttyPayan.MongodbLibrary.KuttyPayanMongodbClass ObjClass = new MongodbLibrary.KuttyPayanMongodbClass();
KuttyPayan.DBReaderLibrary.KuttyPayanDbReaderClass ObjDbRead = new DBReaderLibrary.KuttyPayanDbReaderClass();
//List<Dictionary> KPDictionary = ObjDbRead.FileReadMethod();
//ObjClass.KuttyPayanMethod(KPDictionary);
//List<POSTags> KPTags = ObjDbRead.TagReadMethod();
//ObjClass.KuttyPayanMethod(KPTags);
//List<EmployeeSample> Employees = ObjDbRead.InsertEmployees();
//bool Status = ObjClass.KuttyPayanEmployeeInsert(Employees);
EmployeeSchema EmpSchema = new EmployeeSchema();
EmpSchema.Name = "update";
EmpSchema.Length = "2";
EmpSchema.Type = "DB";
string[] Column1 = { "column1", "KPActionDictionary" };
string[] Column2 = { "column2", "KPTableDictionary" };
EmpSchema.ReferenceTable = new List <string[]>();
EmpSchema.ReferenceTable.Add(Column1);
EmpSchema.ReferenceTable.Add(Column2);
EmpSchema.Data = new List <string[]>();
EmpSchema.Data.Add(new string[] { "column1", "action" });
EmpSchema.Data.Add(new string[] { "column2", "tablename" });
bool Status = ObjClass.KuttyPayanEmployeeSchemaInsert(EmpSchema);
}
public CRUDSchema KPFindCRUDSchemaMethod(EmployeeSchema InputSchema, SchemaEntityClass SchemaEntity)
{
MongoCollection <CRUDSchema> collection = database.GetCollection <CRUDSchema>("KPCRUDSchema");
var query = Query <CRUDSchema> .EQ(e => e.MappedSchema, InputSchema.Name);
List <CRUDSchema> CRUDSchemaList = collection.Find(query).ToList();
CRUDSchema objCRUDSchema = new CRUDSchema();
List <string[]> CRUDSChemaColumns = new List <string[]>();
List <string> EmployeeSchemaColumns = new List <string>();
List <WordSchemaReferenceValueClass> objEntityList = new List <WordSchemaReferenceValueClass>();
objEntityList = SchemaEntity.WordSchemaReferenceValueCollection;
StringBuilder QueryBuilder = new StringBuilder();
Dictionary <string, string> MatchCRUDSchema = new Dictionary <string, string>();
for (int i = 0; i < CRUDSchemaList.Count; i++)
{
for (int ColumnPos = 0; ColumnPos < CRUDSchemaList[i].column.Count; ColumnPos++)
{
string CRUDColumn = string.Empty;
string EmployeeColumn = string.Empty;
var column = CRUDSchemaList[i].column.ElementAt(ColumnPos);
if (column.Count() > 1)
{
if (column[1] == objEntityList[ColumnPos].SchemaValue)
{
CRUDColumn = objEntityList[ColumnPos].SchemaValue;
//EmployeeColumn=
//QueryBuilder.Append(column[i]);
}
}
else
{
if (column[0] == objEntityList[ColumnPos].SchemaReference)
{
EmployeeColumn = objEntityList[ColumnPos].SchemaValue;
QueryBuilder.Append(objEntityList[ColumnPos].SchemaReference);
}
}
MatchCRUDSchema.Add(EmployeeColumn, CRUDColumn);
}
CRUDSChemaColumns.Add(CRUDSchemaList[i].column[0]);
EmployeeSchemaColumns.Add(objEntityList[i].SchemaReference);
}
//if(CRUDSchemaList.Count>1)
//{
objCRUDSchema = CRUDSchemaList.Where(a => a.column[0][1] == "select").FirstOrDefault();
return(objCRUDSchema);
//}
//else
//{
// return CRUDSchemaList.First();
//}
}
public EmployeeSchema KPFindEmployeeSchemaMethod(SchemaEntityClass EmployeeSchema)
{
MongoCollection <EmployeeSchema> collection = database.GetCollection <EmployeeSchema>("KPEmployeeSchema");
var query = Query <EmployeeSchema> .EQ(e => e.Name, EmployeeSchema.SchemaName);
EmployeeSchema objEmployeeSchema = collection.Find(query).FirstOrDefault();
return(objEmployeeSchema);
}
public bool KuttyPayanEmployeeSchemaInsert(EmployeeSchema EmployeeSchema)
{
try
{
MongoCollection <EmployeeSchema> Employeecollection = database.GetCollection <EmployeeSchema>("KPEmployeeSchema");
Employeecollection.Insert(EmployeeSchema);
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public void EmployeeTestSuccess()
{
Mock <IDependencyResolver> mockRepository = new Mock <IDependencyResolver>();
EmployeeSchema controller = new EmployeeSchema(mockRepository.Object);
Mock <IEmployeeRepo> mockEmp = new Mock <IEmployeeRepo>();
mockEmp.Setup(m => m.GetEmployees()).Returns(_employees);
Schema schema = new Schema {
Query = new EmployeeQuery(mockEmp.Object)
};
string json = controller.Execute(_ =>
{
_.Schema = schema;
_.Query = "{employees{name}}";
});
string expectedData = _employeesName.Replace("'", "\"");
Assert.True(json.Equals(expectedData));
}
public CRUDSchema FindCRUDSchema(EmployeeSchema SchemaName, SchemaEntityClass SchemaEntity)
{
return(KPDBObj.KPFindCRUDSchemaMethod(SchemaName, SchemaEntity));
}