public StorageAccessLevel GetSQlData(string stringConnection, int _Id) { //create connection SqlConnection conn = new SqlConnection(stringConnection); StorageAccessLevel accessLevel = new StorageAccessLevel(); string sqlGetCmd = @"select Access_Level from AccessLevel where IdAccessLevel = @_IdAccessLevel"; conn.Open(); Logger logger = LogManager.GetCurrentClassLogger(); logger.Info("Inside"); SqlCommand cmd = new SqlCommand(sqlGetCmd, conn); cmd.Parameters.AddWithValue("@_IdAccessLevel", _Id); SqlDataReader rdb = cmd.ExecuteReader(); rdb.Read(); //begin read value accessLevel.IdAccessLevel = _Id; accessLevel.Access_Level = (string)GetUnoSQlValue(rdb,"Access_Level"); if (conn != null) { conn.Close(); conn.Dispose(); } else { logger.Warn("SQlConnection not close"); } if (rdb != null) { rdb.Close(); conn.Dispose(); logger.Info("Method close"); return accessLevel; } else { logger.Warn("Not return element"); return null; } }
//params object[] values //добавление public void SetSQlData(string stringConnection, StorageAccessLevel accessLevel) { SqlConnection conn = new SqlConnection(stringConnection); conn.Open(); Logger logger = LogManager.GetCurrentClassLogger(); logger.Info("Inside"); string strInsert = @"insert into AccessLevel(id,first) values (@_Id,@_Access_Level)"; SqlCommand cmd = new SqlCommand(strInsert, conn); cmd.Parameters.AddWithValue("@_Access_Level", accessLevel.Access_Level); cmd.ExecuteNonQuery(); if (conn != null) { conn.Close(); conn.Dispose(); } else { logger.Warn("SQlConnection not close"); } }