/// <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);
}
}
