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))); }