Exemple #1
0
        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);
            }
        }
Exemple #2
0
        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);
            }
        }