[Route("CSAT/CommunicationsMessages/{barcodeid}/{offset}/{pagesize}")] //Full profile with encryptedkit number public async Task <IActionResult> GetFFMatches(string barcodeid, int filterGroupID, string filterName, int offset, int pagesize) { CommTypeListResults retval = null; try { if (MOCKISTRUE) { //MOCK CALL CSATService communicationService = new CSATService(_dataLayerMock, this.connection, barcodeid); retval = await communicationService.GetCommunicationTypeList(filterGroupID, filterName, offset, pagesize); } else { //NOT CURRENTLY BEING USED //SetRequiredValues(); //if (UserNotAuthorized()) //{ // return Unauthorized(); //} //retval = _dataLayer.GetProfileFull(kitnumbers); CSATService communicationService = new CSATService(_dataLayer, this.connection, barcodeid); retval = await communicationService.GetCommunicationTypeList(filterGroupID, filterName, offset, pagesize); } return(Json(retval)); } catch (Exception e) { // log something // LogException(e); return(StatusCode((int)HttpStatusCode.InternalServerError, e)); } }
public async Task<CommTypeListResults> getCommList(string connection, string LapTopBarCode, int filterGroupID, string filterName, int offSet, int pageSize) { //READ FROM MOCK DATA FILES FOR TESTING FROM SDK TO BYPASS DATA ACCESS. try { List<CommTypeList> retval; IEnumerable<CommTypeList> retvalMock; CommTypeListResults queryitems = new CommTypeListResults(); var resourceName = ""; var assembly = Assembly.GetExecutingAssembly(); if (LapTopBarCode == "1") { resourceName = "CSAT.Services.Communication.DataCore.MockData.floorStageComm1.txt"; } else if (LapTopBarCode == "2") { resourceName = "CSAT.Services.Communication.DataCore.MockData.floorStageComm2.txt"; } else if (LapTopBarCode == "3") { resourceName = "CSAT.Services.Communication.DataCore.MockData.floorStageComm3.txt"; } else if (LapTopBarCode == "4") { resourceName = "CSAT.Services.Communication.DataCore.MockData.floorStageComm4.txt"; } using (Stream stream = assembly.GetManifestResourceStream(resourceName)) using (StreamReader r = new StreamReader(stream)) { string json = await r.ReadToEndAsync(); retval = JsonConvert.DeserializeObject<List<CommTypeList>>(json); } if (filterGroupID >0) { retvalMock = from c in retval where c.bucket == (filterGroupID) select c; } else { retvalMock = retval; } if (filterName != null) { retvalMock = from c in retvalMock where c.Message.ToUpper().Contains(filterName) select c; } //lets get total count prior to paging queryitems.totalMatches = retval.Count(); if (pageSize > 0) { retvalMock = retvalMock.Skip(offSet).Take(pageSize); } queryitems.Matches = retvalMock; return queryitems; } catch (Exception e) { return null; } }
public async Task <CommTypeListResults> GetCommunicationTypeList(int filterGroupID, string filterName, int offset, int pagesize) { CommTypeListResults retval = await dataLayer.getCommList(this.dbconnection, this.LapTopBarcodeID, filterGroupID, filterName, offset, pagesize); return(retval); }
public async Task <CommTypeListResults> getCommList(string dbconnection, string LapTopBarCodeID, int filterGroupID, string filterName, int offset, int pageSize) { CommTypeListResults results = new CommTypeListResults(); using (CSATContext _context = new CSATContext(dbconnection)) { try { // var conn = _context.Database.GetDbConnection(); // conn.Open(); //using (var command = conn.CreateCommand()) //{ // //ADDING IN PARAMETERIZED QUERY // command.CommandType = CommandType.StoredProcedure; // command.CommandText = "sp_getCommTypes"; // SqlParameter paramKitOwner = new SqlParameter("@LapTopBarCodeID", LapTopBarCodeID); // paramKitOwner.Direction = ParameterDirection.Input; // paramKitOwner.DbType = DbType.String; // command.Parameters.Add(paramKitOwner); // SqlParameter paramfilterGroupID = new SqlParameter("@filterGroupId", filterGroupID); // paramfilterGroupID.Direction = ParameterDirection.Input; // paramfilterGroupID.DbType = DbType.Int32; // command.Parameters.Add(paramfilterGroupID); // SqlParameter paramfilterName = new SqlParameter("@filtername", filterName); // paramfilterName.Direction = ParameterDirection.Input; // paramfilterName.DbType = DbType.String; // command.Parameters.Add(paramfilterName); // SqlParameter paramfilterOffset = new SqlParameter("@offset", offset); // paramfilterOffset.Direction = ParameterDirection.Input; // paramfilterOffset.DbType = DbType.Int32; // command.Parameters.Add(paramfilterOffset); // SqlParameter paramfilterPageSize = new SqlParameter("@pagesize", pageSize); // paramfilterPageSize.Direction = ParameterDirection.Input; // paramfilterPageSize.DbType = DbType.Int32; // command.Parameters.Add(paramfilterPageSize); //END PARAMETERIZED QUERY //DbDataReader readerCommMatches = await command.ExecuteReaderAsync(); //var commMatchData = readerCommMatches.MapToList<CommTypeList>(); //LETS SET CORRECT IMAGE PATH //foreach (CommTypeList i in commMatchData) //{ // results.totalMatches = i.totalMatches; // //DO MORE STUFF; //} //results.Matches = commMatchData; //results.totalMatches = commMatchData.Count(); //Leave in for new. This is for writing MockDataFile // System.IO.File.WriteAllText(@"C:\projects\FTDNA.Services.GeneticInfo\FTDNA.Services.GeneticInfo.DataCore\MockData\FFmockjson_843.txt", writeFileValue); //System.IO.File.WriteAllText(@"C:\projects\GeneticsSDK\FTDNA.GeneticInfo.SDK\FTDNA.Services.GeneticInfo.SDK\MockData\FFmockjson_843.txt", writeFileValue); // readerCommMatches.Close(); //FAKE RETURN FOR TESTING List <CommTypeList> fakedReturnData = new List <CommTypeList>(); CommTypeList innerObject = new CommTypeList(); innerObject.messageType = CSAT.Services.Communication.DataCore.Enums.MessageType.ProductArrival; innerObject.Message = "Hello CSAT world"; innerObject.name = "Test 1"; fakedReturnData.Add(innerObject); results.Matches = fakedReturnData; results.totalMatches = fakedReturnData.Count(); return(results); // } } catch (Exception e) { //TODO //HAND EXCEPTION CORRECTLY //return StatusCode((int)HttpStatusCode.InternalServerError, e); return(null); } } return(results); }