public int Delete(Obj_LoaiDonVi obj_LoaiDonVi)
{
SQLiteCommand cm = new SQLiteCommand(DbAccess.DatabaseConnection);
cm.CommandType = CommandType.Text;
cm.CommandText = "DELETE FROM " + LocalTable.TableName + " WHERE id = " + obj_LoaiDonVi.ID;
DbAccess.OpenConnection();
int i = cm.ExecuteNonQuery();
DbAccess.CloseConnection();
return(i);
}
public int Update(Obj_LoaiDonVi obj_LoaiDonVi)
{
SQLiteCommand cm = new SQLiteCommand(DbAccess.DatabaseConnection);
cm.CommandType = CommandType.Text;
cm.CommandText = "UPDATE " + LocalTable.TableName + " SET " +
"tenLoai = @tenLoai, " +
"trangThai = @trangThai" +
" WHERE id = @id";
cm.Parameters.Add(new SQLiteParameter("@id", obj_LoaiDonVi.ID));
cm.Parameters.Add(new SQLiteParameter("@tenLoai", obj_LoaiDonVi.TenLoai));
cm.Parameters.Add(new SQLiteParameter("@trangThai", obj_LoaiDonVi.TrangThai));
DbAccess.OpenConnection();
int i = cm.ExecuteNonQuery();
DbAccess.CloseConnection();
return(i);
}
public int Insert(Obj_LoaiDonVi obj_LoaiDonVi)
{
SQLiteCommand cm = new SQLiteCommand(DbAccess.DatabaseConnection);
cm.CommandType = CommandType.Text;
cm.CommandText = "INSERT INTO " + LocalTable.TableName + " VALUES (" +
"@id, " +
"@tenLoai, " +
"@trangThai)";
cm.Parameters.Add(new SQLiteParameter("@id", obj_LoaiDonVi.ID));
cm.Parameters.Add(new SQLiteParameter("@tenLoai", obj_LoaiDonVi.TenLoai));
cm.Parameters.Add(new SQLiteParameter("@trangThai", obj_LoaiDonVi.TrangThai));
DbAccess.OpenConnection();
int i = cm.ExecuteNonQuery();
DbAccess.CloseConnection();
return(i);
}
public int Delete(Obj_LoaiDonVi obj_LoaiDonVi)
{
return(LoaiDonVi.Delete(obj_LoaiDonVi));
}
public int UpdateInfo(Obj_LoaiDonVi obj_LoaiDonVi)
{
return(LoaiDonVi.Update(obj_LoaiDonVi));
}
public int Insert(Obj_LoaiDonVi obj_LoaiDonVi)
{
return(LoaiDonVi.Insert(obj_LoaiDonVi));
}
