private MOND NewMOND(MONG mg, ge_log_reading read, string instrument_name, string round_ref, string mond_type, string mond_rem, string mond_ref, string value_name, string mond_name, string units, string format, float?GL, string ge_source) { string value = null; string format2 = "{0:" + format + "}"; if (read.NotDry == ge_log_constants.ISNOTDRY) { float?reading = read.getValue(value_name); if (reading != null) { value = String.Format(format2, reading); if (mond_type == "WLEV") { value = String.Format(format2, GL.Value - reading); } } } if (read.NotDry == ge_log_constants.ISDRY) { value = "Dry"; } if (!String.IsNullOrEmpty(read.Remark)) { mond_rem += " " + read.Remark; } if (String.IsNullOrEmpty(value)) { return(null); } MOND md = new MOND { gINTProjectID = mg.gINTProjectID, PointID = mg.PointID, ItemKey = mg.ItemKey, MONG_DIS = mg.MONG_DIS, MOND_TYPE = mond_type, MOND_REF = mond_ref, DateTime = read.ReadingDateTime, MOND_UNIT = units, MOND_RDNG = value, MOND_INST = instrument_name, MOND_NAME = mond_name, MOND_REM = mond_rem, RND_REF = round_ref, ge_source = ge_source, ge_otherId = read.Id.ToString() }; return(md); }
private async Task <ge_log_file> GetFile(Guid dataId, string table = "data_pressure", Boolean IncludeReadings = true) { if (dataId == null) { return(null); } var _logger = await _context.ge_data .Include(d => d.project) .AsNoTracking() .SingleOrDefaultAsync(m => m.Id == dataId); dbConnectDetails cd = await getConnectDetails(_logger.projectId, logTables.DB_DATA_TYPE); if (cd == null) { return(null); } string dbConnectStr = cd.AsConnectionString(); return(await Task.Run(() => { using (SqlConnection cnn = new SqlConnection(dbConnectStr)) { cnn.Open(); dsTable <ge_log_reading> ds_readings = new logTables().reading; dsTable <ge_log_file> ds_file = new logTables().file; ds_file.setConnection(cnn); ds_readings.setConnection(cnn); //Multichannel transducer have upto 8 tables which will all have the same dataId if (string.IsNullOrEmpty(table)) { ds_file.sqlWhere("dataId='" + dataId.ToString() + "' and (channel is null or channel='')"); } else { ds_file.sqlWhere("dataId='" + dataId.ToString() + "' and channel='" + table + "'"); } ds_file.getDataSet(); DataTable dt_file = ds_file.getDataTable(); if (dt_file == null) { return null; } if (dt_file.Rows.Count == 0) { return null; } ge_log_file file = new ge_log_file(); DataRow row = dt_file.Rows[0]; get_log_file_values(row, file); if (IncludeReadings) { ds_readings.sqlWhere("FileId='" + file.Id.ToString() + "'"); ds_readings.getDataSet(); DataTable dt_readings = ds_readings.getDataTable(); file.readings = new List <ge_log_reading>(); foreach (DataRow rrow in dt_readings.Rows) { ge_log_reading r = new ge_log_reading(); get_log_reading_values(rrow, r); file.readings.Add(r); } file.OrderReadings(); } file.unpack_exist_file(); return file; } })); }
private void get_log_reading_values(DataRow row, ge_log_reading reading) { reading.Id = (Guid)row ["Id"]; reading.fileId = (Guid)row["fileId"]; reading.ReadingDateTime = (DateTime)row["ReadingDateTime"]; if (row["Duration"] != DBNull.Value) { reading.Duration = Convert.ToInt64(row["Duration"].ToString()); } if (row["Value1"] != DBNull.Value) { reading.Value1 = Convert.ToSingle(row["Value1"].ToString()); } if (row["Value2"] != DBNull.Value) { reading.Value2 = Convert.ToSingle(row["Value2"].ToString()); } if (row["Value3"] != DBNull.Value) { reading.Value3 = Convert.ToSingle(row["Value3"].ToString()); } if (row["Value4"] != DBNull.Value) { reading.Value4 = Convert.ToSingle(row["Value4"].ToString()); } if (row["Value5"] != DBNull.Value) { reading.Value5 = Convert.ToSingle(row["Value5"].ToString()); } if (row["Value6"] != DBNull.Value) { reading.Value6 = Convert.ToSingle(row["Value6"].ToString()); } if (row["Value7"] != DBNull.Value) { reading.Value7 = Convert.ToSingle(row["Value7"].ToString()); } if (row["Value8"] != DBNull.Value) { reading.Value8 = Convert.ToSingle(row["Value8"].ToString()); } if (row["Value9"] != DBNull.Value) { reading.Value9 = Convert.ToSingle(row["Value9"].ToString()); } if (row["Value10"] != DBNull.Value) { reading.Value10 = Convert.ToSingle(row["Value10"].ToString()); } if (row["Value11"] != DBNull.Value) { reading.Value11 = Convert.ToSingle(row["Value11"].ToString()); } if (row["Value12"] != DBNull.Value) { reading.Value12 = Convert.ToSingle(row["Value12"].ToString()); } if (row["Value13"] != DBNull.Value) { reading.Value13 = Convert.ToSingle(row["Value13"].ToString()); } if (row["Value14"] != DBNull.Value) { reading.Value14 = Convert.ToSingle(row["Value14"].ToString()); } if (row["Value15"] != DBNull.Value) { reading.Value15 = Convert.ToSingle(row["Value15"].ToString()); } if (row["Value16"] != DBNull.Value) { reading.Value16 = Convert.ToSingle(row["Value16"].ToString()); } if (row["Value17"] != DBNull.Value) { reading.Value17 = Convert.ToSingle(row["Value17"].ToString()); } if (row["Value18"] != DBNull.Value) { reading.Value18 = Convert.ToSingle(row["Value18"].ToString()); } if (row["Remark"] != DBNull.Value) { reading.Remark = (String)row["Remark"]; } reading.Valid = (int)row["Valid"]; reading.Include = (int)row["Include"]; reading.pflag = (int)row["pflag"]; reading.NotDry = (int)row["NotDry"]; }
private void set_log_reading_values(ge_log_reading reading, DataRow row) { row["Id"] = reading.Id; row["fileId"] = reading.fileId; row["ReadingDateTime"] = reading.ReadingDateTime; if (reading.Duration == null) { row["Duration"] = DBNull.Value; } else { row["Duration"] = reading.Duration; } if (reading.Value1 == null) { row["Value1"] = DBNull.Value; } else { row["Value1"] = reading.Value1; } if (reading.Value2 == null) { row["Value2"] = DBNull.Value; } else { row["Value2"] = reading.Value2; } if (reading.Value3 == null) { row["Value3"] = DBNull.Value; } else { row["Value3"] = reading.Value3; } if (reading.Value4 == null) { row["Value4"] = DBNull.Value; } else { row["Value4"] = reading.Value4; } if (reading.Value5 == null) { row["Value5"] = DBNull.Value; } else { row["Value5"] = reading.Value5; } if (reading.Value6 == null) { row["Value6"] = DBNull.Value; } else { row["Value6"] = reading.Value6; } if (reading.Value7 == null) { row["Value7"] = DBNull.Value; } else { row["Value7"] = reading.Value7; } if (reading.Value8 == null) { row["Value8"] = DBNull.Value; } else { row["Value8"] = reading.Value8; } if (reading.Value9 == null) { row["Value9"] = DBNull.Value; } else { row["Value9"] = reading.Value9; } if (reading.Value10 == null) { row["Value10"] = DBNull.Value; } else { row["Value10"] = reading.Value10; } if (reading.Value11 == null) { row["Value11"] = DBNull.Value; } else { row["Value11"] = reading.Value11; } if (reading.Value12 == null) { row["Value12"] = DBNull.Value; } else { row["Value12"] = reading.Value12; } if (reading.Value13 == null) { row["Value13"] = DBNull.Value; } else { row["Value13"] = reading.Value13; } if (reading.Value14 == null) { row["Value14"] = DBNull.Value; } else { row["Value14"] = reading.Value14; } if (reading.Value15 == null) { row["Value15"] = DBNull.Value; } else { row["Value15"] = reading.Value15; } if (reading.Value16 == null) { row["Value16"] = DBNull.Value; } else { row["Value16"] = reading.Value16; } if (reading.Value17 == null) { row["Value17"] = DBNull.Value; } else { row["Value17"] = reading.Value17; } if (reading.Value18 == null) { row["Value18"] = DBNull.Value; } else { row["Value18"] = reading.Value18; } row["Remark"] = reading.Remark; row["Valid"] = reading.Valid; row["Include"] = reading.Include; row["pflag"] = reading.pflag; row["NotDry"] = reading.NotDry; }
private int addReadingsAny(List <ge_log_reading> list, string[] lines, int line_start, int line_end, int intReadTime, int intDuration, int intValue1, int intValue2, int intValue3, int intValue4, int intValue5, int intValue6, int intValue7, int intValue8, int intValue9, int intValue10, int intValue11, int intValue12, int intValue13, int intValue14, int intValue15, int intValue16, int intValue17, int intValue18, int intRemark, int intValueCheckForDry, string dateformat = "") { if (intReadTime == NOT_FOUND || line_start == NOT_FOUND) { return(-1); } string[] dateformats = SplitDateFormats(dateformat); for (int i = line_start; i < line_end; i++) { string line = lines[i]; if (line.Length > 0) { string[] values = line.Split(","); if (values[0].Contains("\"")) { values = QuoteSplit(line); } if (values[intReadTime] == "" || ContainsError(values[intReadTime]) || IsDateTime(values[intReadTime], dateformats) == false) { continue; } ge_log_reading r = new ge_log_reading(); r.ReadingDateTime = getDateTime(values[intReadTime], dateformats); if (intDuration != NOT_FOUND) { r.Duration = getDuration(values[intDuration], null); } if (intValue1 != NOT_FOUND) { r.Value1 = getFloat(values[intValue1], null); } if (intValue2 != NOT_FOUND) { r.Value2 = getFloat(values[intValue2], null); } if (intValue3 != NOT_FOUND) { r.Value3 = getFloat(values[intValue3], null); } if (intValue4 != NOT_FOUND) { r.Value4 = getFloat(values[intValue4], null); } if (intValue5 != NOT_FOUND) { r.Value5 = getFloat(values[intValue5], null); } if (intValue6 != NOT_FOUND) { r.Value6 = getFloat(values[intValue6], null); } if (intValue7 != NOT_FOUND) { r.Value7 = getFloat(values[intValue7], null); } if (intValue8 != NOT_FOUND) { r.Value8 = getFloat(values[intValue8], null); } if (intValue9 != NOT_FOUND) { r.Value9 = getFloat(values[intValue9], null); } if (intValue10 != NOT_FOUND) { r.Value10 = getFloat(values[intValue10], null); } if (intValue11 != NOT_FOUND) { r.Value11 = getFloat(values[intValue11], null); } if (intValue12 != NOT_FOUND) { r.Value12 = getFloat(values[intValue12], null); } if (intValue13 != NOT_FOUND) { r.Value13 = getFloat(values[intValue13], null); } if (intValue14 != NOT_FOUND) { r.Value14 = getFloat(values[intValue14], null); } if (intValue15 != NOT_FOUND) { r.Value15 = getFloat(values[intValue15], null); } if (intValue16 != NOT_FOUND) { r.Value16 = getFloat(values[intValue16], null); } if (intValue17 != NOT_FOUND) { r.Value17 = getFloat(values[intValue17], null); } if (intValue18 != NOT_FOUND) { r.Value18 = getFloat(values[intValue18], null); } if (intRemark != NOT_FOUND) { r.Remark = values[intRemark]; } if (intValueCheckForDry != NOT_FOUND) { if (values[intValueCheckForDry] == "Dry" || values[intValueCheckForDry] == "DRY") { r.NotDry = -1; } } list.Add(r); } } return(list.Count()); }