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