public HttpResponseMessage PondO2ByDate([FromBody] O2ReadingDTO uDto)
{
string key;
var ur = new AppUserRepository();
var companyId = 0;
var UserId = ur.ValidateUser(uDto.Key, out key, ref companyId);
//string dayperiod;
//if (DateTime.Parse(uDto.ReadingDate).Hour < 12)
//{
// dayperiod = DateTime.Parse(uDto.ReadingDate).AddDays(-1).ToShortDateString();
//}
//else
//{
// dayperiod = DateTime.Parse(uDto.ReadingDate).ToShortDateString();
//}
//uDto.DayPeriod = dayperiod;
AppUserRoleRepository aur = new AppUserRoleRepository();
if (UserId > 0 && aur.IsInRole(UserId, "Airtime"))
{
var O2r = new O2ReadingRepository();
var u = new O2Reading();
//var predicate = O2r.GetPredicate(uDto, u, companyId);
var data = O2r.GetPondO2ReadingsByDate(int.Parse(uDto.PondId), DateTime.Parse(uDto.ReadingDate));
var col = new Collection <Dictionary <string, string> >();
foreach (var item in data)
{
var dic = new Dictionary <string, string>();
dic.Add("PondId", item.PondId.ToString());
dic.Add("ReadingId", item.ReadingId.ToString());
dic.Add("ReadingDate", item.ReadingDate.ToString());
dic.Add("O2Level", item.O2Level.ToString());
dic.Add("StaticCount", item.StaticCount.ToString());
dic.Add("PortableCount", item.PortableCount.ToString());
dic.Add("Note", item.Note);
dic.Add("PondStatus", item.Pond.HealthStatus.ToString());
col.Add(dic);
}
var retVal = new GenericDTO
{
Key = key,
ReturnData = col
};
return(Request.CreateResponse(HttpStatusCode.OK, retVal));
}
var message = "validation failed";
return(Request.CreateResponse(HttpStatusCode.NotFound, message));
}
public HttpResponseMessage FarmO2Last3Days([FromBody] FarmDTO uDto)
{
string key;
var ur = new AppUserRepository();
var companyId = 0;
var UserId = ur.ValidateUser(uDto.Key, out key, ref companyId);
AppUserRoleRepository aur = new AppUserRoleRepository();
if (UserId > 0 && aur.IsInRole(UserId, "Airtime"))
{
var pr = new PondRepository();
var ponddata = pr.GetActivePondsForO2(int.Parse(uDto.FarmId));
DateTime startdate = DateTime.Parse(uDto.CurrentTime);
var pondcol = new Dictionary<string, Dictionary<string, Collection<Dictionary<string, string>>>>();
foreach (Pond ponditem in ponddata)
{
var datecol = new Dictionary<string, Collection<Dictionary<string, string>>>();
int i = 0;
while (i > -3)
{
var O2r = new O2ReadingRepository();
var data = O2r.GetPondO2ReadingsByDate(ponditem.PondId, startdate.AddDays(i));
var col = new Collection<Dictionary<string, string>>();
foreach (var item in data)
{
var dic = new Dictionary<string, string>();
dic.Add("PondId", item.PondId.ToString());
dic.Add("ReadingId", item.ReadingId.ToString());
dic.Add("ReadingDate", item.ReadingDate.ToString());
dic.Add("O2Level", item.O2Level.ToString());
dic.Add("StaticCount", item.StaticCount.ToString());
dic.Add("PortableCount", item.PortableCount.ToString());
dic.Add("Note", item.Note);
col.Add(dic);
}
datecol.Add(startdate.AddDays(i).ToShortDateString(), col);
i--;
}
pondcol.Add(ponditem.PondId.ToString(), datecol);
}
var retVal = new FarmO2DTO
{
Key = key,
ReturnData = pondcol
};
return Request.CreateResponse(HttpStatusCode.OK, retVal);
}
var message = "validation failed";
return Request.CreateResponse(HttpStatusCode.NotFound, message);
}
public HttpResponseMessage PondO2ByDate([FromBody] O2ReadingDTO uDto)
{
string key;
var ur = new AppUserRepository();
var companyId = 0;
var UserId = ur.ValidateUser(uDto.Key, out key, ref companyId);
//string dayperiod;
//if (DateTime.Parse(uDto.ReadingDate).Hour < 12)
//{
// dayperiod = DateTime.Parse(uDto.ReadingDate).AddDays(-1).ToShortDateString();
//}
//else
//{
// dayperiod = DateTime.Parse(uDto.ReadingDate).ToShortDateString();
//}
//uDto.DayPeriod = dayperiod;
AppUserRoleRepository aur = new AppUserRoleRepository();
if (UserId > 0 && aur.IsInRole(UserId, "Airtime"))
{
var O2r = new O2ReadingRepository();
var u = new O2Reading();
//var predicate = O2r.GetPredicate(uDto, u, companyId);
var data = O2r.GetPondO2ReadingsByDate(int.Parse(uDto.PondId), DateTime.Parse(uDto.ReadingDate));
var col = new Collection<Dictionary<string, string>>();
foreach (var item in data)
{
var dic = new Dictionary<string, string>();
dic.Add("PondId", item.PondId.ToString());
dic.Add("ReadingId", item.ReadingId.ToString());
dic.Add("ReadingDate", item.ReadingDate.ToString());
dic.Add("O2Level", item.O2Level.ToString());
dic.Add("StaticCount", item.StaticCount.ToString());
dic.Add("PortableCount", item.PortableCount.ToString());
dic.Add("Note", item.Note);
dic.Add("PondStatus", item.Pond.HealthStatus.ToString());
col.Add(dic);
}
var retVal = new GenericDTO
{
Key = key,
ReturnData = col
};
return Request.CreateResponse(HttpStatusCode.OK, retVal);
}
var message = "validation failed";
return Request.CreateResponse(HttpStatusCode.NotFound, message);
}
