public int Update(Obj_DanhHieu obj)
{
SQLiteCommand cm = new SQLiteCommand(DbAccess.DatabaseConnection);
cm.CommandType = CommandType.Text;
cm.CommandText = "UPDATE " + LocalTable.TableName + " SET " +
"nam = @nam, " +
"danhHieu = @danhHieu, " +
"trangThai = @trangThai " +
"WHERE id = @id";
cm.Parameters.Add(new SQLiteParameter("@nam", obj.Nam));
cm.Parameters.Add(new SQLiteParameter("@danhHieu", obj.DanhHieu));
cm.Parameters.Add(new SQLiteParameter("@trangThai", obj.TrangThai));
cm.Parameters.Add(new SQLiteParameter("@id", obj.ID));
DbAccess.OpenConnection();
int i = cm.ExecuteNonQuery();
DbAccess.CloseConnection();
if (i == 1)
{
foreach (DataRow item in LocalTable.Rows)
{
if ((long)item["id"] == obj.ID)
{
item["nam"] = obj.Nam;
item["danhHieu"] = obj.DanhHieu;
item["trangThai"] = obj.TrangThai;
break;
}
}
}
return(i);
}
