public string SqlSelect(string conectionstring, AngularModel command)
{
var sqlconnect = new SqlConnectionType();
SerializeJson serializeJson = new SerializeJson();
switch (command.Id)
{
case 1:
return(serializeJson.JsonLibary((SysNum)sqlconnect.SelectFullParametrSqlReader <string, string>(conectionstring, command.Command, typeof(SysNum))));
case 12:
return(serializeJson.JsonLibary((Mail)sqlconnect.SelectFullParametrSqlReader <string, string>(conectionstring, command.Command, typeof(Mail))));
case 13:
return(serializeJson.JsonLibary((ModelFull)sqlconnect.SelectFullParametrSqlReader <string, string>(conectionstring, command.Command, typeof(ModelFull))));
case 14:
return
(serializeJson.JsonLibary(
(Soprovod)
sqlconnect.SelectFullParametrSqlReader <string, string>(conectionstring, command.Command,
typeof(Soprovod))));
case 21: return(serializeJson.JsonLibary((No)sqlconnect.SelectFullParametrSqlReader <string, string>(conectionstring, command.Command, typeof(No))));
default:
return("Данная комманда не определена!!!");
}
}
/// <summary>
/// Обработка всех комманд с сервера и возврат данных надо тестить
/// </summary>
/// <param name="command">WCf модель взаимодействия с сайтом</param>
/// <returns></returns>
public async Task <string> ModelSqlSelect(AngularModel command)
{
var connect = command.Db == "Work" ? _parametrService.ConectWork : _parametrService.ConectTest;
var selectfull = new SelectFull();
return(await Task.Factory.StartNew(() => selectfull.SqlSelect(connect, command)));
}
