public ActionResult GetAllDataValue(int SiteId, string utcDateDDMMYYYY)
{
Hydro.HydroService theHydro = new HydroService();
DateTime utcDateBgn = DateTime.ParseExact(utcDateDDMMYYYY + " 00:00:00", "ddMMyyyy H:mm:ss", new CultureInfo("en-US"));
DateTime utcDateEnd = DateTime.ParseExact(utcDateDDMMYYYY + " 23:59:59", "ddMMyyyy H:mm:ss", new CultureInfo("en-US"));
Hydro.Site[] _sites = theHydro.GetSiteList(null, true);
int siteTypeId = 0;
if (_sites != null)
{
foreach (var site in _sites)
{
if (site.SiteId == SiteId)
{
siteTypeId = site.Type.Id;
}
}
}
Hydro.Variable[] theVariables = theHydro.GetSiteTypeVariables(siteTypeId, true);
Dictionary <string, List <Hydro.DataValue> > dictionary_in = new Dictionary <string, List <Hydro.DataValue> >();
foreach (var variable in theVariables)
{
Hydro.DataValue[] theDataValues = theHydro.GetDataValues(SiteId, true,
utcDateBgn, true,
utcDateEnd, true,
variable.Id, true,
null, true,
null, true,
null, true);
if (theDataValues == null)
{
continue;
}
List <Hydro.DataValue> theDataValuesList = new List <Hydro.DataValue>();
foreach (var value in theDataValues)
{
theDataValuesList.Add(value);
}
dictionary_in.Add(variable.Name, theDataValuesList);
}
ViewBag.Variables = theVariables;
ViewBag.dictionary_in = dictionary_in;
return(View());
}
public ActionResult GetDataValues(int SiteId, string date_start, string date_end)
{
try
{
Hydro.HydroService theHydro = new HydroService();
DateTime utcDateBgn = DateTime.ParseExact(date_start + " 00:00:00", "dd.MM.yyyy H:mm:ss", new CultureInfo("en-US")).AddHours(-11);
DateTime utcDateEnd = DateTime.ParseExact(date_end + " 23:59:59", "dd.MM.yyyy H:mm:ss", new CultureInfo("en-US")).AddHours(-11);
Hydro.Site[] _sites = theHydro.GetSiteList(null, true);
int siteTypeId = 0;
if (_sites != null)
{
foreach (var site in _sites)
{
if (site.SiteId == SiteId)
{
siteTypeId = site.Type.Id;
}
}
}
Hydro.Variable[] theVariables = theHydro.GetSiteTypeVariables(siteTypeId, true);
List <string> theUtcDateStrings = new List <string>();
DateTime dt = utcDateBgn;
while (dt < utcDateEnd)
{
dt = dt.AddHours(1);
theUtcDateStrings.Add(String.Format("{0:yyyyMMddHHmmss}", dt));
}
theUtcDateStrings.Sort();
theUtcDateStrings.Reverse();
ViewBag.UtcDateStrings = theUtcDateStrings;
List <string> theVariableList = new List <string>();
foreach (var item in theVariables)
{
theVariableList.Add
(item.Name);
}
ViewBag.VariableList = theVariableList;
Dictionary <string, List <Hydro.DataValue> > dictionary_in = new Dictionary <string, List <Hydro.DataValue> >();
foreach (var variable in theVariables)
{
Hydro.DataValue[] theDataValues = theHydro.GetDataValues(SiteId, true,
utcDateBgn, true,
utcDateEnd, true,
variable.Id, true,
null, true,
null, true,
null, true);
if (theDataValues == null)
{
continue;
}
List <Hydro.DataValue> theDataValuesList = new List <Hydro.DataValue>();
foreach (var value in theDataValues)
{
theDataValuesList.Add(value);
}
dictionary_in.Add(variable.Name, theDataValuesList);
}
ViewBag.Variables = theVariables;
ViewBag.dictionary_in = dictionary_in;
}
catch (Exception ex)
{
ViewBag.Error = ex.Message;
}
return(View("GetAllDataValue"));
}
public ActionResult GetReportAgk08(string date_report)
{
const int TYPE_AGK_SITE = 6;
const int srocUTC = 8;
const int variableId = 2;
const int variableId22 = 22;
DateTime utcBeginDate = DateTime.ParseExact(date_report + " 00:00:00", "dd.MM.yyyy H:mm:ss", new CultureInfo("en-US"));
DateTime utcEndDate = DateTime.ParseExact(date_report + " 23:59:59", "dd.MM.yyyy H:mm:ss", new CultureInfo("en-US"));
Hydro.HydroService theHydro = new HydroService();
Hydro.Site[] _sites = theHydro.GetSiteList(TYPE_AGK_SITE, true);
ViewBag.Sites = _sites;
Dictionary <int, List <Hydro.DataValue> > SiteDataValues = new Dictionary <int, List <Hydro.DataValue> >();
Dictionary <int, List <Hydro.DataValue> > SiteDataValues22 = new Dictionary <int, List <Hydro.DataValue> >();
if (_sites != null)
{
foreach (var theSite in _sites)
{
Hydro.DataValue[] theDataValues = theHydro.GetDataValuesForReport(theSite.SiteId, true,
utcBeginDate, true,
utcEndDate, true,
variableId, true,
22, true,
null, true,
null, true,
null, true);
List <Hydro.DataValue> theList = new List <DataValue>();
SiteDataValues.Add(theSite.SiteId, theList);
if (theDataValues == null)
{
continue;
}
foreach (var datavalue in theDataValues)
{
theList.Add(datavalue);
}
SiteDataValues[theSite.SiteId] = theList;
}
ViewBag.SiteDataValues = SiteDataValues;
foreach (var theSite in _sites)
{
Hydro.DataValue[] theDataValues = theHydro.GetDataValuesForReport(theSite.SiteId, true,
utcBeginDate, true,
utcEndDate, true,
variableId22, true,
srocUTC, true,
null, true,
null, true,
null, true);
List <Hydro.DataValue> theList = new List <DataValue>();
SiteDataValues22.Add(theSite.SiteId, theList);
if (theDataValues == null)
{
continue;
}
foreach (var datavalue in theDataValues)
{
theList.Add(datavalue);
}
SiteDataValues22[theSite.SiteId] = theList;
}
}
ViewBag.SiteDataValues = SiteDataValues;
ViewBag.SiteDataValues22 = SiteDataValues22;
return(View());
}