//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); }