//public IEnumerable<DeviceB> DeviceLabel(string deviceID, string fromDate, string toDate)
//{
// List<DeviceB> DeviceAs = new List<DeviceB>();
// using (SqlConnection conObj = new SqlConnection(conStr))
// {
// DateTime vfrDate = Convert.ToDateTime(fromDate, CultureInfo.InvariantCulture);
// DateTime vtoDate = Convert.ToDateTime(toDate, CultureInfo.InvariantCulture);
// string vRange = "From " + String.Format("{0:dd/MM/yyyy}", vfrDate) + " To " + String.Format("{0:dd/MM/yyyy}", vtoDate);
// DateTime vDate;
// int vfigure = 0;
// int vfreqvalue = 0;
// string qry;
// string xfrdate;
// string xtodate;
// int myValue = DeviceValuel(deviceID);
// vfrDate = Convert.ToDateTime(String.Format("{0:MM/dd/yyyy HH:mm tt}", vfrDate), CultureInfo.InvariantCulture);
// vtoDate = Convert.ToDateTime(String.Format("{0:MM/dd/yyyy HH:mm tt}", vtoDate), CultureInfo.InvariantCulture);
// xfrdate = String.Format("{0:MM/dd/yyyy HH:mm tt}", vfrDate);
// xtodate = String.Format("{0:MM/dd/yyyy HH:mm tt}", vtoDate);
// qry = "select a.deviceStamp,c.status, a.deviceInternalTemp,a.devicefreq from tblDeviceData a "
// + "left join tblMonitoringSub C on a.deviceId=c.ID where a.deviceid='" + deviceID + "' and "
// + "deviceStamp>='" + xfrdate + "' and deviceStamp<='" + xtodate + "' order by devicestamp";
// SqlCommand cmdObj = new SqlCommand(qry, conObj);
// conObj.Open();
// SqlDataReader readerObj = cmdObj.ExecuteReader();
// while (readerObj.Read())
// {
// vDate = Convert.ToDateTime(readerObj["deviceStamp"].ToString());
// vfigure = Convert.ToInt32(readerObj["deviceinternaltemp"].ToString());
// vfreqvalue = Convert.ToInt32(readerObj["devicefreq"].ToString());
// DeviceB DeviceA = new DeviceB();
// DeviceA.label = string.Format("{0:dd/MM/yy hh}", vDate);
// DeviceA.figure = vfigure;
// DeviceA.freqvalue = vfreqvalue;
// DeviceA.daterange = vRange;
// DeviceA.latestvalue = myValue;
// DeviceAs.Add(DeviceA);
// counter = counter + 1;
// }
// }
// return DeviceAs;
//}
public IEnumerable <DeviceB> DeviceLabelNew(string deviceID, string fromDate, string toDate)
{
List <DeviceB> DeviceAs = new List <DeviceB>();
using (SqlConnection conObj = new SqlConnection(conStr))
{
DateTime vfrDate = Convert.ToDateTime(fromDate, CultureInfo.InvariantCulture);
DateTime vtoDate = Convert.ToDateTime(toDate, CultureInfo.InvariantCulture);
string vRange = "From " + String.Format("{0:dd/MM/yyyy}", vfrDate) + " To " + String.Format("{0:dd/MM/yyyy}", vtoDate);
DateTime vDate;
int vfigure = 0;
int vfreqvalue = 0;
int yvalue = 0;
int zvalue = 0;
string qry;
string xfrdate;
string xtodate;
int myValue = 0;
double myValuex = 0;
myValuex = DeviceValuel(deviceID);
myValue = Convert.ToInt32(myValuex);
vfrDate = Convert.ToDateTime(String.Format("{0:MM/dd/yyyy HH:mm tt}", vfrDate), CultureInfo.InvariantCulture);
vtoDate = Convert.ToDateTime(String.Format("{0:MM/dd/yyyy HH:mm tt}", vtoDate), CultureInfo.InvariantCulture);
xfrdate = String.Format("{0:MM/dd/yyyy HH:mm tt}", vfrDate);
xtodate = String.Format("{0:MM/dd/yyyy HH:mm tt}", vtoDate);
qry = "select a.deviceStamp,c.status, a.deviceInternalTemp,a.devicefreq from tblDeviceData a "
+ "left join tblMonitoringSub C on a.deviceId=c.ID order by devicestamp";
SqlCommand cmdObj = new SqlCommand("spDevicelabel", conObj);
cmdObj.CommandType = CommandType.StoredProcedure;
cmdObj.Parameters.Add(new SqlParameter("@deviceId", deviceID));
cmdObj.Parameters.Add(new SqlParameter("@fromDate", fromDate));
cmdObj.Parameters.Add(new SqlParameter("@toDate", toDate));
conObj.Open();
SqlDataReader readerObj = cmdObj.ExecuteReader();
while (readerObj.Read())
{
double vfreqvaluex = 0;
double vfigurex = 0;
double yvaluex = 0;
double zvaluex = 0;
vDate = Convert.ToDateTime(readerObj["deviceStamp"].ToString());
vfigurex = Convert.ToDouble(readerObj["deviceinternaltemp"].ToString());
vfigure = Convert.ToInt32(vfigurex);
vfreqvaluex = Convert.ToDouble(readerObj["devicefreq"].ToString());
vfreqvalue = Convert.ToInt32(vfreqvaluex);
yvaluex = Convert.ToDouble(readerObj["yval"].ToString());
yvalue = Convert.ToInt32(yvaluex);
zvaluex = Convert.ToDouble(readerObj["zval"].ToString());
zvalue = Convert.ToInt32(zvaluex);
DeviceB DeviceA = new DeviceB();
DeviceA.label = string.Format("{0:dd/MM/yy hh}", vDate);
DeviceA.figure = vfigure;
DeviceA.freqvalue = vfreqvalue;
DeviceA.yvalue = yvalue;
DeviceA.zvalue = zvalue;
DeviceA.daterange = vRange;
DeviceA.latestvalue = myValue;
DeviceAs.Add(DeviceA);
counter = counter + 1;
}
}
return(DeviceAs);
}
