public async Task <IList <Alarm> > Get(DateTime?fromDate, DateTime?toDate, List <string> cameraName, List <string> sourceLocation, string licensePlateNumber)
{
var retResults = MapReduceAlarm(fromDate, toDate);
CombineClass combineClass = new CombineClass();
combineClass = GetDetails.Alarm();
List <string> lstJunctionId = new List <string>();
//if (sourceLocation.Count > 0)
// lstJunctionId = from o in sourceLocation where sourceLocation == o.lstJunctionId select o;
//lstJunctionId = sourceLocation.Contains(p=>p).Select(Int32.Parse).ToList();
//string[] arrSourceLocation = (from a in lstJunctionMaster
// where lstJunctionId.Contains(a.JunctionID)
// select a.SourceLocation).ToArray<string>();
//string[] arrPoleIds = { };
//string[] arrCameraGuids = { };
//if (poleIds.Length > 0)
// arrPoleIds = poleIds.Split(',');
//if (cameraGuids.Length > 0)
// arrCameraGuids = cameraGuids.Split(',');
//var glstTraffic = (from a in retResults
// join polecameraMapping in lstPoleCameraMapping on a._id.CamGUID equals polecameraMapping.CameraGUID
// join polemaster in lstPolemaster on polecameraMapping.PoleCameraMappingID equals polemaster.Id
// join junctionmaster in lstJunctionMaster on polemaster.JunctionID equals junctionmaster.JunctionID
// where (arrSourceLocation.Length > 0 ? arrSourceLocation.Contains(junctionmaster.SourceLocation) : true)
// && (arrPoleIds.Length > 0 ? arrPoleIds.Contains(polemaster.Id.ToString()) : true)
// && (arrCameraGuids.Length > 0 ? arrCameraGuids.Contains(polecameraMapping.CameraGUID) : true)
// select new TrafficListModel
// {
// JunctionId = junctionmaster.JunctionID,
// JunctionName = junctionmaster.JunctionName,
// Id = polemaster.Id,
// PoleName = polemaster.Name,
// CameraName = polecameraMapping.CameraName,
// TrafficCount = a.value.TrafficCount,
// ViolationOverallCount = a.value.ViolationOverallCount,
// ViolationHighConfidenceCount = a.value.ViolationHighConfidenceCount,
// SuccessCount = a.value.SuccessCount,
// FailureCount = a.value.FailureCount,
// VehicleNotFoundCount = a.value.VehicleNotFoundCount,
// InvalidRegNoCount = a.value.InvalidRegNoCount,
// SevenDaysCount = a.value.SevenDaysCount,
// MoreOfficeCount = a.value.MoreOfficeCount,
// ImgNotFoundCount = a.value.ImgNotFoundCount,
// ExclusiveCount = a.value.ExclusiveCount,
// NullCountHighConfidence = a.value.NullCountHighConfidence
// });
//return glstTraffic;
return(null);
}
public static CombineClass Alarm()
{
CombineClass combineClass = new CombineClass();
using (IDbConnection dbConnection = new MySqlConnection(DatabaseconnString))
{
try
{
dbConnection.Open();
string sql = "";
sql = "SELECT ID,JunctionID,JunctionName,JunctionLocation,Latitude,Longitude,CameraImageLocation,SourceLocation,AreaID,JunctionIP,AreaCode " +
" FROM junctionmaster where IsDelete=0 order by ID";
combineClass.junctionMaster = dbConnection.Query <JunctionMaster>(sql);
sql = "SELECT ID,Name,JunctionId,Latitude,Longitude,IsDelete,CameraName " +
" FROM polemaster where IsDelete=0 ";
combineClass.poleMaster = dbConnection.Query <PoleMaster>(sql);
sql = "SELECT CameraGuid,CameraName,SourceVMS,ChannelWidth,AnalyticsConfig,CameraURl,Pushed " +
" FROM camera where IsDelete=0 ";
combineClass.camera = dbConnection.Query <Camera>(sql);
sql = "SELECT PoleCameraMappingId,CameraGUID,CameraName,IsDelete FROM polecameramapping where IsDelete=0 ";
combineClass.poleCameraMapping = dbConnection.Query <PoleCameraMapping>(sql);
return(combineClass);
}
catch (Exception ex)
{
throw new NotImplementedException();
}
finally
{
if (dbConnection.State == ConnectionState.Open)
{
dbConnection.Close();
}
}
}
}
