public async Task <IEnumerable <object> > GetReports(string connectionString, string ProviderName, Param prm)
{
IEnumerable <object> output = null;
switch (ProviderName.ToLower())
{
case "sqlserver":
output = await exSp.GetReport(connectionString, prm);
break;
case "postgresql":
output = await PostgreSQLClass.GetReport(connectionString, prm);
break;
//case "mysql":
// reponse = await MySqlClass.GetChartsData(connectionString, value);
//break;
case "oracle":
break;
}
return(output);
}
public async Task <List <StoreProcedures> > GetAllChartsData(string connectionString, string ProviderName, [FromBody] List <StoreProcedures> value)
{
List <StoreProcedures> reponse = new List <StoreProcedures>();
switch (ProviderName.ToLower())
{
case "sqlserver":
reponse = await exSp.GetChartsData(connectionString, value);
break;
case "postgresql":
reponse = await PostgreSQLClass.GetChartsData(connectionString, value);
break;
case "mysql":
reponse = await MySqlClass.GetChartsData(connectionString, value);
break;
case "oracle":
break;
}
//var reponse = await PostgreSQLClass.GetChartsData(connectionString, value);
//var reponse = await MySqlClass.GetChartsData(connectionString, value);
return(reponse);
}
public async Task <IEnumerable <object> > Get(string connectionString, string StoreProcedureName, string CommondName, int UserId, string ProviderName)
{
IEnumerable <object> output = null;
switch (ProviderName.ToLower())
{
case "sqlserver":
output = await exSp.ExecuteSpGetData(connectionString, StoreProcedureName, CommondName, UserId);
break;
case "postgresql":
output = await PostgreSQLClass.ExecuteSpGetData(connectionString, StoreProcedureName, CommondName, UserId);
break;
//case "mysql":
// reponse = await MySqlClass.GetChartsData(connectionString, value);
//break;
case "oracle":
break;
}
return(output);
}
public async Task <OutputData> FilterDataByParam(string connectionString, string ProviderName, [FromBody] Param value)
{
OutputData outData = new OutputData();
//var reponse = await exSp.GetFilterDataByParam(connectionString, value);
switch (ProviderName.ToLower())
{
case "sqlserver":
outData = await exSp.GetFilterDataByParam(connectionString, value);
break;
case "postgresql":
outData = await PostgreSQLClass.GetFilterDataByParam(connectionString, value);
break;
//case "mysql":
// reponse = await MySqlClass.GetChartsData(connectionString, value);
//break;
case "oracle":
break;
}
return(outData);
}
