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