public bool themCTP_TraSach(DTO_CHITIETTRASACH dtoctts)
{
try
{
_conn.Open();
string sql = string.Format("INSERT INTO CHITIETTRASACH (ID_TRASACH, ID_SACH, CREATED_AT) VALUES ( {0}, {1}, '{2}' )",
dtoctts.ID_TRASACH, dtoctts.ID_SACH, dtoctts.CREATED_AT.ToString("yyyy-MM-dd hh:mm:ss"));
MySqlCommand cmd = new MySqlCommand(sql, _conn);
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
_conn.Close();
}
return(false);
}
public bool themCTP_TraSach(int idsach)
{
DTO_CHITIETTRASACH dtoctts = new DTO_CHITIETTRASACH()
{
ID_SACH = idsach, CREATED_AT = DateTime.Now, UPDATED_AT = DateTime.Now
};
return(dalphieuts.themCTP_TraSach(dtoctts));
}
