public HttpResponseMessage PondFeedLast7Days([FromBody] PondDTO 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, "Chowtime"))
{
var pr = new PondRepository();
var ponddata = pr.GetById(int.Parse(uDto.PondId));
DateTime startdate = DateTime.Now;
int i = 0;
var col = new Collection <Dictionary <string, string> >();
while (i > -7)
{
var fr = new FeedingRepository();
var data = fr.GetPondFeedingsByDate(ponddata.PondId, startdate.AddDays(i));
if (data != null)
{
var dic = new Dictionary <string, string>();
dic.Add("PondId", data.PondId.ToString());
dic.Add("FeedingId", data.FeedingId.ToString());
dic.Add("FeedDate", data.FeedDate.ToString());
dic.Add("PoundsFed", data.PoundsFed.ToString());
col.Add(dic);
}
i--;
}
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 FarmFeedLast7Days([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, "Chowtime"))
{
var pr = new PondRepository();
var ponddata = pr.GetActivePonds(int.Parse(uDto.FarmId));
DateTime startdate = DateTime.Parse(uDto.CurrentTime);
var pondcol = new Dictionary<string, Collection<Dictionary<string, string>>>();
foreach (Pond ponditem in ponddata)
{
int i = 0;
var col = new Collection<Dictionary<string, string>>();
while (i > -7)
{
var fr = new FeedingRepository();
var data = fr.GetPondFeedingsByDate(ponditem.PondId, startdate.AddDays(i));
if (data != null)
{
var dic = new Dictionary<string, string>();
dic.Add("PondId", data.PondId.ToString());
dic.Add("FeedingId", data.FeedingId.ToString());
dic.Add("FeedDate", data.FeedDate.ToString());
dic.Add("PoundsFed", data.PoundsFed.ToString());
col.Add(dic);
}
else
{
var dic = new Dictionary<string, string>();
dic.Add("PondId", ponditem.PondId.ToString());
dic.Add("FeedingId", "");
dic.Add("FeedDate", startdate.AddDays(i).Date.ToShortDateString());
dic.Add("PoundsFed", "0");
col.Add(dic);
}
i--;
}
pondcol.Add(ponditem.PondId.ToString(), col);
}
var retVal = new FarmFeedDTO
{
Key = key,
ReturnData = pondcol
};
return Request.CreateResponse(HttpStatusCode.OK, retVal);
}
var message = "validation failed";
return Request.CreateResponse(HttpStatusCode.NotFound, message);
}
public HttpResponseMessage PondFeedLast7Feeds([FromBody] PondDTO 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, "Chowtime"))
{
var pr = new PondRepository();
var ponddata = pr.GetById(int.Parse(uDto.PondId));
DateTime startdate = DateTime.Now;
int i = 0;
int j = 0;
int pondDataCount = 0;
var col = new Collection<Dictionary<string, string>>();
while (pondDataCount < 7 && j < 10)
{
var fr = new FeedingRepository();
var data = fr.GetPondFeedingsByDate(ponddata.PondId, startdate.AddDays(i));
if (data != null)
{
var dic = new Dictionary<string, string>();
dic.Add("PondId", data.PondId.ToString());
dic.Add("FeedingId", data.FeedingId.ToString());
dic.Add("FeedDate", data.FeedDate.ToString());
dic.Add("PoundsFed", data.PoundsFed.ToString());
col.Add(dic);
pondDataCount++;
// reset j - haven't hit null territory yet
j = 0;
}
else { j++; }
i--;
}
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 PondFeedLast7Feeds([FromBody] PondDTO 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, "Chowtime"))
{
var pr = new PondRepository();
var ponddata = pr.GetById(int.Parse(uDto.PondId));
DateTime startdate = DateTime.Now;
int i = 0;
int j = 0;
int pondDataCount = 0;
var col = new Collection <Dictionary <string, string> >();
while (pondDataCount < 7 && j < 10)
{
var fr = new FeedingRepository();
var data = fr.GetPondFeedingsByDate(ponddata.PondId, startdate.AddDays(i));
if (data != null)
{
var db = new AppEntities();
string datepart = data.FeedDate.ToShortDateString();
DateTime begindate = DateTime.Parse(datepart);
DateTime enddate = begindate.AddDays(1);
var data2 = db.Mortalities.Where(x => x.PondId == data.PondId && x.MortalityDate >= begindate && x.MortalityDate < enddate).FirstOrDefault();
var dic = new Dictionary <string, string>();
dic.Add("PondId", data.PondId.ToString());
dic.Add("FeedingId", data.FeedingId.ToString());
dic.Add("FeedDate", data.FeedDate.ToString());
dic.Add("PoundsFed", data.PoundsFed.ToString());
dic.Add("MortalityId", data2 != null ? data2.MortalityId.ToString() : "");
dic.Add("MortalityDate", data2 != null ? data2.MortalityDate.ToString() : "--");
dic.Add("MortalityPounds", data2 != null ? data2.MortalityPounds.ToString() : "0");
col.Add(dic);
pondDataCount++;
// reset j - haven't hit null territory yet
j = 0;
}
else
{
j++;
}
i--;
}
var retVal = new GenericDTO
{
Key = key,
ReturnData = col
};
return(Request.CreateResponse(HttpStatusCode.OK, retVal));
}
var message = "validation failed";
return(Request.CreateResponse(HttpStatusCode.NotFound, message));
}