public static string GetQuery(QueryBank queryBank)
{
switch (queryBank)
{
case QueryBank.AllActiveCustomers:
return("SelectAllCustomers");
case QueryBank.CustomerById:
return("GetCustomerById");
case QueryBank.SenderDetailsByPostStatus:
return("GetCustomersByPostStatusProcedure");
case QueryBank.PostDetailsBySenderId:
return("GetPostsByCustomerWhoCreatedItProcedure");
case QueryBank.SenderAndReceiverWithPostNotDelivered:
return("GetFullDetailsWithPostNotDeliveredProcedure");
case QueryBank.GetCustomer:
return("GetCustomer");
default:
return("SelectAllCustomers");
}
}
internal List <object> GetQueryData(QueryBank id)
{
IQueries data = (from quer in this._ListOfQueries
where quer.GetQueryID() == id
select quer).FirstOrDefault();
return(data.GetQueryData());
}
public ClickView(Dictionary <string, string> Paramaters, QueryBank id)
{
this._ID = id;
this._AllowedParamaterKeys = new List <string>()
{
"User_Type"
};
_Paramaters = Paramaters;
}
public Infiniti(Dictionary <string, string> Paramaters, QueryBank id)
{
this._ID = id;
this._AllowedParamaterKeys = new List <string>()
{
"Password",
"Enable"
};
_Paramaters = Paramaters;
}
public ActionResult <Dictionary <string, string> > PostParam(QueryBank queryBank, Dictionary <string, string> parameters)
{
parameters.Remove("queryBank");
var request = new GetResultFromQueryBankRequest
{
QueryBank = queryBank,
Parameters = parameters
};
var results = adapter.GetDictionary(request);
return(Ok(results));
}
private void BuildFromQueryBank(QueryBank queryBank)
{
BuildStoredProc(StaticQuery.GetQuery(queryBank));
}
