public async Task <ActionResult> Index()
{
/// Reading Class Start *****************************************************************************
GetMeterReadingdetailsclass GetMeterReadingdetailsclassObj = new GetMeterReadingdetailsclass();
GetMeterReadingdetailsclassObj.api_key = "F1AC8019-3BA0-4DFC-A677-27F155B0A012-1584719321";
GetMeterReadingdetailsclassObj.date_start = "2020-03-01T00:00:00";
GetMeterReadingdetailsclassObj.date_end = "2020-04-01T00:00:00";
GetMeterReadingdetailsclassObj.ingest_date_start = "2020-03-01T00:00:00";
GetMeterReadingdetailsclassObj.ingest_date_end = "2020-04-01T00:00:00";
// GetMeterReadingdetailsclassObj.meter_ids = new string[] { "5276711", "5276729", "9999996", "9999997" };
GetMeterReadingdetailsclassObj.meter_ids = new string[] { "9999997" };
GetMeterReadingdetailsclassObj.reading_type = new string[] { "blood_glucose", "blood_pressure", "weight" };
string json = JsonConvert.SerializeObject(GetMeterReadingdetailsclassObj);
string response = await CCMRequestRestAPI.GetResponsePostRequest("https://api.iglucose.com/readings/", json);
/// Reading Class Object End *****************************************************************************
/// json With Array List Object Start *****************************************************************************
//GetMeterReadingByIDsclass MeterReadingByIDsclassObj = new GetMeterReadingByIDsclass();
//MeterReadingByIDsclassObj.api_key = "F1AC8019-3BA0-4DFC-A677-27F155B0A012-1584719321";
//MeterReadingByIDsclassObj.meter_ids = new string[] { "5276711", "234324", "234" };
//string jsonWithArrayList = JsonConvert.SerializeObject(MeterReadingByIDsclassObj);
/// json With Array List Object End *****************************************************************************
// Post Request with Simple Json Object Start ******************************************************************
//GetMeterclass meterobj = new GetMeterclass();
//meterobj.api_key = "F1AC8019-3BA0-4DFC-A677-27F155B0A012-1584719321";
//string json = JsonConvert.SerializeObject(meterobj);
// string response = await CCMRequestRestAPI.GetResponsePostRequest("http://api.iglucose.com/v1/meters/get", json);
// *********
// For future use ******
//**********
//string response = await CCMRequestRestAPI.GetResponse("", "https://reqres.in/api/users?page=2");
//string response = await CCMRequestRestAPI.GetResponse("https://reqres.in/", "/api/users?page=2");
// ListBO = JsonConvert.DeserializeObject<List<ListBO>>(Response);
// ListBO = ListBO.OrderByDescending(x => x.CreatedOn).ToList();
return(View());
}
// GET: APIParser
public async Task <ActionResult> Index()
{
List <PatientDeviceReadingsRequest> PD_RequestList = new List <PatientDeviceReadingsRequest>();
List <PatientDeviceReadingsRequest> FilteredPD_RequestList = new List <PatientDeviceReadingsRequest>();
List <GetMeterReadingdetailsclass> GetMeterReadinglist = new List <GetMeterReadingdetailsclass>();
List <int> ReadingSyncPrimeryKeyID = new List <int>();
bool IsToUpdateSyncDone = false;
PD_RequestList = _db.Database.SqlQuery <PatientDeviceReadingsRequest>("GetPatientReadings").ToList();
if (PD_RequestList.Count % 2 == 0)
{
for (int i = 0; i < PD_RequestList.Count;)
{
if (PD_RequestList[i].PatientId == PD_RequestList[i + 1].PatientId &&
PD_RequestList[i].RPMServiceId == PD_RequestList[i + 1].RPMServiceId &&
PD_RequestList[i].Type == "Attach" && PD_RequestList[i + 1].Type == "Detached"
)
{
FilteredPD_RequestList.Add(PD_RequestList[i]);
FilteredPD_RequestList.Add(PD_RequestList[i + 1]);
i++;
}
i++;
}
}
else
{
for (int i = 0; i < PD_RequestList.Count - 1;)
{
if (PD_RequestList[i].PatientId == PD_RequestList[i + 1].PatientId &&
PD_RequestList[i].RPMServiceId == PD_RequestList[i + 1].RPMServiceId &&
PD_RequestList[i].Type == "Attach" && PD_RequestList[i + 1].Type == "Detached"
)
{
FilteredPD_RequestList.Add(PD_RequestList[i]);
FilteredPD_RequestList.Add(PD_RequestList[i + 1]);
i++;
}
i++;
}
}
GetMeterReadingdetailsclass GetMeterReadingdetailsclassObj;
for (int i = 0; i < FilteredPD_RequestList.Count; i = i + 2)
{
IsToUpdateSyncDone = false;
DateTime date_startObj = new DateTime();
DateTime date_endObj = new DateTime();
date_startObj = (DateTime)FilteredPD_RequestList[i].DatePerformed;
date_endObj = (DateTime)FilteredPD_RequestList[i + 1].DatePerformed;
string date_start = AttachZeroIfRequired(date_startObj.Year) + "-" + AttachZeroIfRequired(date_startObj.Month) + "-" + AttachZeroIfRequired(date_startObj.Day) + "T" + AttachZeroIfRequired(date_startObj.Hour) + ":" + AttachZeroIfRequired(date_startObj.Minute) + ":" + AttachZeroIfRequired(date_startObj.Second);
string date_end = AttachZeroIfRequired(date_endObj.Year) + "-" + AttachZeroIfRequired(date_endObj.Month) + "-" + AttachZeroIfRequired(date_endObj.Day) + "T" + AttachZeroIfRequired(date_endObj.Hour) + ":" + AttachZeroIfRequired(date_endObj.Minute) + ":" + AttachZeroIfRequired(date_endObj.Second);
GetMeterReadingdetailsclassObj = new GetMeterReadingdetailsclass();
GetMeterReadingdetailsclassObj.api_key = "F1AC8019-3BA0-4DFC-A677-27F155B0A012-1584719321";
GetMeterReadingdetailsclassObj.date_start = date_start;
GetMeterReadingdetailsclassObj.date_end = date_end;
GetMeterReadingdetailsclassObj.ingest_date_start = date_start;
GetMeterReadingdetailsclassObj.ingest_date_end = date_end;
GetMeterReadingdetailsclassObj.meter_ids = new string[] { FilteredPD_RequestList[i].SerialNumber.ToString() };
GetMeterReadingdetailsclassObj.reading_type = new string[] { "blood_glucose", "blood_pressure", "weight" };
string json = JsonConvert.SerializeObject(GetMeterReadingdetailsclassObj);
string response = await CCMRequestRestAPI.GetResponsePostRequest("https://api.iglucose.com/readings/", json);
ReadingResponseListParserClass ReadingListFullBO = new ReadingResponseListParserClass();
ReadingListFullBO = JsonConvert.DeserializeObject <ReadingResponseListParserClass>(response);
if (ReadingListFullBO != null)
{
if (ReadingListFullBO.readings.Count > 0)
{
foreach (Reading ReadingObj in ReadingListFullBO.readings)
{
try
{
int result = _db.Database.SqlQuery <int>("InsertRpm_PatientDeviceReading @Battery,@Blood_glucose_mgdl,@Reading_type,@Reading_id,@Time_zone_offset,@Blood_glucose_mmol" +
",@Device_model,@Date_recorded,@Date_received,@Before_meal,@Device_id_RPMVendor,@RPMServiceId,@PatientId,@DevicetId,@IsActive,@ReasonForDeactivate,@CreatedBy,@ModifiedBy",
new SqlParameter("@Battery", ReadingObj.battery), new SqlParameter("@Blood_glucose_mgdl", ReadingObj.blood_glucose_mgdl),
new SqlParameter("@Reading_type", ReadingObj.reading_type), new SqlParameter("@Reading_id", ReadingObj.reading_id),
new SqlParameter("@Time_zone_offset", ReadingObj.time_zone_offset), new SqlParameter("@Blood_glucose_mmol", ReadingObj.blood_glucose_mmol),
new SqlParameter("@Device_model", ReadingObj.device_model), new SqlParameter("@Date_recorded", ReadingObj.date_recorded),
new SqlParameter("@Date_received", ReadingObj.date_received), new SqlParameter("@Before_meal", ReadingObj.before_meal),
new SqlParameter("@Device_id_RPMVendor", ReadingObj.device_id), new SqlParameter("@RPMServiceId", FilteredPD_RequestList[i].RPMServiceId),
new SqlParameter("@PatientId", FilteredPD_RequestList[i].PatientId), new SqlParameter("@DevicetId", FilteredPD_RequestList[i].DevicetId),
new SqlParameter("@IsActive", 1), new SqlParameter("@ReasonForDeactivate", string.Empty),
new SqlParameter("@CreatedBy", Session["UserID"].ToString()), new SqlParameter("@ModifiedBy", Session["UserID"].ToString())
).FirstOrDefault();
IsToUpdateSyncDone = true;
}
catch (Exception ex)
{
IsToUpdateSyncDone = false;
break;
}
}
}
}
if (IsToUpdateSyncDone == true)
{
// Add List of success bit here
ReadingSyncPrimeryKeyID.Add(FilteredPD_RequestList[i].Id);
ReadingSyncPrimeryKeyID.Add(FilteredPD_RequestList[i + 1].Id);
}
// ToDo Start **************
// When Data is inserted Sucessfully Please Update Table Name = "DeviceMappingHistories" IsSyncFromLive = true
// ToDo End **************
}
// ToDO ********************************************
for (int x = 0; x < ReadingSyncPrimeryKeyID.Count; x++)
{
// Update Code here for All Id IN List nam,ely ReadingSyncPrimeryKeyID.Add(FilteredPD_RequestList[i+1].Id);
// in table DeviceMappingHistories
int UpdateResult = 0;
UpdateResult = _db.Database.SqlQuery <int>("UpdateDeviceMappingHistoriesSync @Id,@IsSyncFormlive",
new SqlParameter("@Id", ReadingSyncPrimeryKeyID[x]),
new SqlParameter("@IsSyncFormlive", 1)
).FirstOrDefault();
}
/// Reading Class Start *****************************************************************************
//GetMeterReadingdetailsclass GetMeterReadingdetailsclassObj = new GetMeterReadingdetailsclass();
//GetMeterReadingdetailsclassObj.api_key = "F1AC8019-3BA0-4DFC-A677-27F155B0A012-1584719321";
//GetMeterReadingdetailsclassObj.date_start = "2020-03-01T00:00:00";
//GetMeterReadingdetailsclassObj.date_end = "2020-04-01T00:00:00";
//GetMeterReadingdetailsclassObj.ingest_date_start = "2020-03-01T00:00:00";
//GetMeterReadingdetailsclassObj.ingest_date_end = "2020-04-01T00:00:00";
//// GetMeterReadingdetailsclassObj.meter_ids = new string[] { "5276711", "5276729", "9999996", "9999997" };
//GetMeterReadingdetailsclassObj.meter_ids = new string[] { "9999997" };
//GetMeterReadingdetailsclassObj.reading_type = new string[] { "blood_glucose", "blood_pressure", "weight" };
//string json = JsonConvert.SerializeObject(GetMeterReadingdetailsclassObj);
//string response = await CCMRequestRestAPI.GetResponsePostRequest("https://api.iglucose.com/readings/", json);
//ReadingResponseListParserClass ReadingListFullBO = new ReadingResponseListParserClass();
//ReadingListFullBO = JsonConvert.DeserializeObject<ReadingResponseListParserClass>(response);
/// Reading Class Object End *****************************************************************************
/// json With Array List Object Start *****************************************************************************
//GetMeterReadingByIDsclass MeterReadingByIDsclassObj = new GetMeterReadingByIDsclass();
//MeterReadingByIDsclassObj.api_key = "F1AC8019-3BA0-4DFC-A677-27F155B0A012-1584719321";
//MeterReadingByIDsclassObj.meter_ids = new string[] { "5276711", "5276729", "9999996" };
//string jsonWithArrayList = JsonConvert.SerializeObject(MeterReadingByIDsclassObj);
//string response = await CCMRequestRestAPI.GetResponsePostRequest("http://api.iglucose.com/v1/meters/get", jsonWithArrayList);
//MetersListClass MetersListClassObj = new MetersListClass();
//MetersListClassObj = JsonConvert.DeserializeObject<MetersListClass>(response);
/// json With Array List Object End *****************************************************************************
// Post Request with Simple Json Object Start ******************************************************************
//GetMeterclass meterobj = new GetMeterclass();
//meterobj.api_key = "F1AC8019-3BA0-4DFC-A677-27F155B0A012-1584719321";
//string json = JsonConvert.SerializeObject(meterobj);
// string response = await CCMRequestRestAPI.GetResponsePostRequest("http://api.iglucose.com/v1/meters/get", json);
// *********
// For future use ******
//**********
//string response = await CCMRequestRestAPI.GetResponse("", "https://reqres.in/api/users?page=2");
//string response = await CCMRequestRestAPI.GetResponse("https://reqres.in/", "/api/users?page=2");
// ListBO = JsonConvert.DeserializeObject<List<ListBO>>(Response);
// ListBO = ListBO.OrderByDescending(x => x.CreatedOn).ToList();
return(View());
}
