/// <summary>
/// Добавление элемента в справочник
/// </summary>
/// <param name="bi">Добавляемый элемент</param>
/// <param name="btype">Тип справочника</param>
public void AddBookItem(BookItem bi, BookTypes bk)
{
try
{
string sql = string.Format(@"INSERT INTO {0} (Name) VALUES (@Name)", bk.ToString());
using (IDbConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString))
{
con.Open();
var result = con.Execute(sql, bi);
}
}
catch (Exception ex)
{
Log.WriteLog(ex.Message);
}
}
/// <summary>
/// Удаление элемента справочника по id
/// </summary>
/// <param name="id">Id справочника</param>
/// <param name="bk">Тип справочника</param>
public void DeleteBookItem(int id, BookTypes bk)
{
try
{
using (IDbConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString))
{
con.Open();
con.Execute(string.Format("DELETE FROM {0} WHERE Id = @Id", bk.ToString()), new BookItem {
Id = id
});
}
}
catch (Exception ex)
{
Log.WriteLog(ex.Message);
}
}
/// <summary>
/// Выгрузка всех элементов справочника
/// </summary>
/// <param name="bk">Тип справочника</param>
/// <returns></returns>
public IEnumerable <BookItem> GetBookItems(BookTypes bk)
{
try
{
string sql = string.Format("SELECT * FROM {0} ORDER BY Name", bk.ToString());
using (IDbConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString))
{
con.Open();
var result = con.Query <BookItem>(sql);
return(result);
}
}
catch (Exception ex)
{
Log.WriteLog(ex.Message);
}
return(null);
}