/// <summary> /// Egy rekord törlése. A rekordot az Id megadásával jelöljük ki /// </summary> /// <param name="mes"></param> /// <returns></returns> public bool DeleteItem(Measurment mes) { try { using (var m_dbConnection = new SqlConnection(sqlConnectionString)) { m_dbConnection.Open(); var sql = String.Format("DELET FROM [dbo].[Measurments]([Data],[Name]" + " WHERE Id={0}", mes.Values, mes.Name); SqlCommand command = new SqlCommand(sql, m_dbConnection); command.ExecuteNonQuery(); } return(true); } catch { return(false); } }
/// <summary> /// Egy rekordot adunk a Measurment táblához. Az Id mező autoincrement, nem kell itt megadni /// </summary> /// <param name="mes"></param> /// <returns></returns> public bool AddItem(Measurment mes) { try { using (var m_dbConnection = new SqlConnection(sqlConnectionString)) { m_dbConnection.Open(); var sql = String.Format("INSERT INTO [dbo].[Measurments]([Values],[Name]) " + "VALUES('{0}'," + "'{1}')", mes.Values, mes.Name); SqlCommand command = new SqlCommand(sql, m_dbConnection); command.ExecuteNonQuery(); //m_dbConnection.Close(); return(true); } } catch (Exception ex) { return(false); } }
/// <summary> /// Egy rekord frissítése. Azonosító az Id /// </summary> /// <param name="mes"></param> /// <returns></returns> public bool UpdateItem(Measurment mes) { try { using (var m_dbConnection = new SqlConnection(sqlConnectionString)) { m_dbConnection.Open(); var sql = String.Format("UPDATE [dbo].[Measurment]" + "[Values]= '{0}' " + "[Name]= '{1}' " + "WHERE Id ={2}", mes.Values, mes.Name, mes.Id); SqlCommand command = new SqlCommand(sql, m_dbConnection); command.ExecuteNonQuery(); } return(true); } catch { return(false); } }