public new Dictionary <string, configParams> readData(string sql) { string connectionString; SqlConnection cnn; connectionString = @"Data Source = LT-JOSEPHHANDSC\MVDATA; Initial Catalog = logger; User ID=sa; Password=pa55w0rd!"; cnn = new SqlConnection(connectionString); try { cnn.Open(); SqlCommand command; SqlDataReader dataReader; command = new SqlCommand(sql, cnn); dataReader = command.ExecuteReader(); Dictionary <string, configParams> dicData = new Dictionary <string, configParams>(); while (dataReader.Read()) { configParams cp = new configParams(); cp.camera = dataReader.GetString(2); dicData.Add(dataReader.GetString(1) + dataReader.GetInt32(0).ToString(), cp); } dataReader.Close(); command.Dispose(); cnn.Close(); return(dicData); } catch (Exception dbEx) { Console.WriteLine(dbEx.ToString()); return(null); } }
public bool writeData(List <typeRec> typeRecs, string key, string logID) { string connectionString; SqlConnection cnn; connectionString = ConfigurationManager.ConnectionStrings["LoggerDB"].ConnectionString; cnn = new SqlConnection(connectionString); try { cnn.Open(); SqlCommand command; SqlDataAdapter dataAdapter = new SqlDataAdapter(); int loadNum = 0; int configCount = typeRecs.Count / 3; int count = 0; while (loadNum < configCount) { typeRec r = typeRecs[count]; configParams parms = new configParams(); parms.camera = r.typeContent.Substring(0, 1); parms.cardReaderError = r.typeContent.Substring(1, 3); parms.reserved1 = r.typeContent.Substring(4, 3); parms.reserved2 = r.typeContent.Substring(7, 3); parms.trackWriteError = r.typeContent.Substring(10, 3); parms.supply = r.typeContent.Substring(13, 3); parms.reserved3 = r.typeContent.Substring(16, 9); count++; r = typeRecs[count]; parms.luno = r.typeContent; count++; r = typeRecs[count]; int timersNum = r.typeContent.Length / 5; parms.timers = new timerRec[timersNum]; for (int x = 0, y = 0; y < timersNum; x = x + 5, y++) { parms.timers[y].timerNum = r.typeContent.Substring(x, 2); parms.timers[y].timerTics = r.typeContent.Substring(x + 2, 3); } count++; loadNum++; // childs of configParamsInfo string sql = ""; for (int y = 0; y < timersNum; y++) { sql = @"INSERT INTO configParamsTimers([logkey],[rectype],[timerNum],[timerTics],[logID]) "; sql = sql + @" VALUES('" + r.typeIndex + "','C',"; sql = sql + "'" + parms.timers[y].timerNum + "',"; sql = sql + "'" + parms.timers[y].timerTics + "'," + logID + ")"; command = new SqlCommand(sql, cnn); dataAdapter.InsertCommand = new SqlCommand(sql, cnn); dataAdapter.InsertCommand.ExecuteNonQuery(); command.Dispose(); } // save the timers parent record sql = @"INSERT INTO configParamsInfo([logkey],[rectype],[camera],[cardReaderError],[reserved1]," + "[reserved2],[trackWriteError],[supply],[reserved3],[luno],[timersCount],[load],[prjkey],[logID])" + " VALUES('" + r.typeIndex + "','" + // key 'C' + "','" + // record type parms.camera + "','" + parms.cardReaderError + "','" + parms.reserved1 + "','" + parms.reserved2 + "','" + parms.trackWriteError + "','" + parms.supply + "','" + parms.reserved3 + "','" + parms.luno + "','" + timersNum.ToString() + "','" + loadNum.ToString() + "','" + key + "'," + logID + ")"; command = new SqlCommand(sql, cnn); dataAdapter.InsertCommand = new SqlCommand(sql, cnn); dataAdapter.InsertCommand.ExecuteNonQuery(); command.Dispose(); // cnn.Close(); } cnn.Close(); return(true); } catch (Exception dbEx) { Console.WriteLine(dbEx.ToString()); return(false); } }