public DataTable GetDtb(string WhereCondition = "")
{
LocalTable.Rows.Clear();
SQLiteCommand command = new SQLiteCommand();
command.CommandType = CommandType.Text;
if (WhereCondition.Length == 0)
{
command.CommandText = "SELECT * FROM " + LocalTable.TableName;
}
else
{
command.CommandText = "SELECT * FROM " + LocalTable.TableName + " WHERE " + WhereCondition;
}
command.Connection = DbAccess.DatabaseConnection;
DbAccess.OpenConnection();
SQLiteDataReader r = command.ExecuteReader();
while (r.Read())
{
DataRow newRow = LocalTable.NewRow();
for (int i = 0; i < 9; i++)
{
newRow[i] = r[i];
}
LocalTable.Rows.Add(newRow);
}
DbAccess.CloseConnection();
return(LocalTable);
}
public DataTable GetDtb(string WhereCondition = "")
{
LocalTable.Rows.Clear();
SQLiteCommand cm = new SQLiteCommand(DbAccess.DatabaseConnection);
cm.CommandType = CommandType.Text;
cm.CommandText = "SELECT * FROM " + LocalTable.TableName + (WhereCondition.Length > 0? (" WHERE " + WhereCondition): "");
DbAccess.OpenConnection();
SQLiteDataReader r = cm.ExecuteReader();
while (r.Read())
{
DataRow dr = LocalTable.NewRow();
dr["id"] = r["id"];
dr["nam"] = r["nam"];
dr["danhHieu"] = r["danhhieu"];
dr["trangThai"] = r["trangThai"];
LocalTable.Rows.Add(dr);
}
DbAccess.CloseConnection();
return(LocalTable);
}
public void CreateDataByYear(long baseYear = 0)
{
long y = DateTime.Now.Year;
SQLiteCommand cm = new SQLiteCommand(DbAccess.DatabaseConnection);
cm.CommandType = CommandType.Text;
cm.CommandText = "SELECT COUNT(nam) FROM " + LocalTable.TableName + " WHERE nam =" + y;
DbAccess.OpenConnection();
long count = (long)cm.ExecuteScalar();
DbAccess.CloseConnection();
if (count > 0)
{
return;
}
var d = from DataRow x in LocalTable.Rows
where (long)x["nam"] == baseYear orderby(long) x["id"]
select x;
foreach (var item in d)
{
Obj_DanhHieu o = CreateObj(item);
o.Nam = y;
o.ID = GetNextID();
Insert(o);
}
}
public DataTable GetDtbChucDanh()
{
LocalTable.Rows.Clear();
SQLiteCommand command = new SQLiteCommand(DbAccess.DatabaseConnection);
command.CommandType = CommandType.Text;
command.CommandText = "SELECT * FROM " + LocalTable.TableName;
DbAccess.OpenConnection();
SQLiteDataReader r = command.ExecuteReader();
while (r.Read())
{
DataRow dataRow = LocalTable.NewRow();
for (int i = 0; i < LocalTable.Columns.Count; i++)
{
dataRow[i] = r[i];
}
LocalTable.Rows.Add(dataRow);
}
DbAccess.CloseConnection();
return(LocalTable);
}
public int Delete(Obj_CaNhan obj_CaNhan)
{
SQLiteCommand cm = new SQLiteCommand(DbAccess.DatabaseConnection);
cm.CommandType = CommandType.Text;
cm.CommandText = "DELETE FROM " + LocalTable.TableName + " WHERE id = " + obj_CaNhan.ID;
DbAccess.OpenConnection();
int i = cm.ExecuteNonQuery();
DbAccess.CloseConnection();
if (i == 1)
{
foreach (DataRow item in LocalTable.Rows)
{
if ((long)item[0] == obj_CaNhan.ID)
{
LocalTable.Rows.Remove(item);
LocalTable.AcceptChanges();
break;
}
}
}
return(i);
}
public int Insert(Obj_DanhHieu obj)
{
SQLiteCommand cm = new SQLiteCommand(DbAccess.DatabaseConnection);
cm.CommandType = CommandType.Text;
cm.CommandText = "INSERT INTO " + LocalTable.TableName + " VALUES (" +
"id = @id, " +
"nam = @nam, " +
"danhHieu = @danhHieu, " +
"trangThai = @trangThai)";
cm.Parameters.Add(new SQLiteParameter("@id", typeof(long)));
cm.Parameters.Add(new SQLiteParameter("@nam", typeof(long)));
cm.Parameters.Add(new SQLiteParameter("@danhHieu", typeof(string)));
cm.Parameters.Add(new SQLiteParameter("@trangThai", typeof(bool)));
int i = -1;
DbAccess.OpenConnection();
i = cm.ExecuteNonQuery();
DbAccess.CloseConnection();
if (i == 1)
{
DataRow item = LocalTable.NewRow();
item["id"] = obj.ID;
item["nam"] = obj.Nam;
item["danhHieu"] = obj.DanhHieu;
item["trangThai"] = obj.TrangThai;
LocalTable.Rows.Add(item);
LocalTable.AcceptChanges();
}
return(i);
}
public int Delete(Obj_TieuChi obj)
{
SQLiteCommand cm = new SQLiteCommand(DbAccess.DatabaseConnection);
cm.CommandType = CommandType.Text;
cm.CommandText = "DELETE FROM " + LocalTable.TableName + " WHERE id = @id";
cm.Parameters.Add(new SQLiteParameter("@id", obj.ID));
int i = -1;
DbAccess.OpenConnection();
i = cm.ExecuteNonQuery();
DbAccess.CloseConnection();
if (i == 1)
{
foreach (DataRow r in LocalTable.Rows)
{
if ((long)r["id"] == obj.ID)
{
LocalTable.Rows.Remove(r);
break;
}
}
}
return(i);
}
public DataTable GetDtb(string WhereCondition = "")
{
LocalTable.Rows.Clear();
SQLiteCommand cm = new SQLiteCommand(DbAccess.DatabaseConnection);
cm.CommandType = CommandType.Text;
cm.CommandText = "SELECT * FROM " + LocalTable.TableName + ((WhereCondition.Length > 0) ? WhereCondition : "");
try
{
DbAccess.OpenConnection();
SQLiteDataReader r = cm.ExecuteReader();
while (r.Read())
{
DataRow dr = LocalTable.NewRow();
for (int i = 0; i < LocalTable.Columns.Count; i++)
{
dr[i] = r[i];
}
LocalTable.Rows.Add(dr);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
DbAccess.CloseConnection();
}
return(LocalTable);
}
public DataTable GetDtb(string whereCondition = "")
{
SQLiteCommand command = new SQLiteCommand(DbAccess.DatabaseConnection);
command.CommandType = CommandType.Text;
command.CommandText = "SELECT * FROM " + LocalTable.TableName + (whereCondition.Length > 0 ? (" WHERE " + whereCondition) : "");
LocalTable.Rows.Clear();
DbAccess.OpenConnection();
SQLiteDataReader r = command.ExecuteReader();
while (r.Read())
{
DataRow nr = LocalTable.NewRow();
for (int i = 0; i < LocalTable.Columns.Count; i++)
{
nr[i] = r[i];
}
LocalTable.Rows.Add(nr);
}
DbAccess.CloseConnection();
return(LocalTable);
}
public int Update(Obj_CaNhan obj_CaNhan)
{
SQLiteCommand command = new SQLiteCommand(DbAccess.DatabaseConnection)
{
CommandType = CommandType.Text,
CommandText =
"UPDATE " + LocalTable.TableName +
" SET " +
"idDonVi = @idDonVi, " +
"hoTen = @hoTen, " +
"gioiTinh = @gioiTinh, " +
"ngaySinh = @ngaySinh, " +
"chucDanh = @chucDanh, " +
"chucVu = @chucVu, " +
"email = @email, " +
"phone = @phone " +
"WHERE id = @id "
};
command.Parameters.Add(new SQLiteParameter("@idDonVi", obj_CaNhan.ID_DonVi));
command.Parameters.Add(new SQLiteParameter("@hoTen", obj_CaNhan.HoTen));
command.Parameters.Add(new SQLiteParameter("@gioiTinh", obj_CaNhan.GioiTinh));
command.Parameters.Add(new SQLiteParameter("@ngaySinh", obj_CaNhan.NgaySinh));
command.Parameters.Add(new SQLiteParameter("@chucDanh", obj_CaNhan.ChucDanh));
command.Parameters.Add(new SQLiteParameter("@chucVu", obj_CaNhan.ChucVu));
command.Parameters.Add(new SQLiteParameter("@email", obj_CaNhan.Email));
command.Parameters.Add(new SQLiteParameter("@phone", obj_CaNhan.Phone));
command.Parameters.Add(new SQLiteParameter("@id", obj_CaNhan.ID));
DbAccess.OpenConnection();
int i = command.ExecuteNonQuery();
DbAccess.CloseConnection();
//update to localtable
if (i == 1)
{
foreach (DataRow item in LocalTable.Rows)
{
if ((long)item[0] == obj_CaNhan.ID)
{
item[1] = obj_CaNhan.ID_DonVi;
item[2] = obj_CaNhan.HoTen;
item[3] = obj_CaNhan.GioiTinh;
item[4] = obj_CaNhan.NgaySinh;
item[5] = obj_CaNhan.ChucDanh;
item[6] = obj_CaNhan.ChucVu;
item[7] = obj_CaNhan.Email;
item[8] = obj_CaNhan.Phone;
LocalTable.AcceptChanges();
break;
}
}
}
return(i);
}
public int Insert(Obj_CaNhan obj_CaNhan)
{
SQLiteCommand cm = new SQLiteCommand(DbAccess.DatabaseConnection);
cm.CommandType = CommandType.Text;
cm.CommandText = "INSERT INTO " + LocalTable.TableName + " VALUES (" +
"@id, " +
"@idDonVi, " +
"@hoTen, " +
"@gioiTinh, " +
"@ngaySinh, " +
"@chucDanh, " +
"@chucVu, " +
"@email, " +
"@phone)";
cm.Parameters.Add(new SQLiteParameter("@id", obj_CaNhan.ID));
cm.Parameters.Add(new SQLiteParameter("@idDonVi", obj_CaNhan.ID_DonVi));
cm.Parameters.Add(new SQLiteParameter("@hoTen", obj_CaNhan.HoTen));
cm.Parameters.Add(new SQLiteParameter("@gioiTinh", obj_CaNhan.GioiTinh));
cm.Parameters.Add(new SQLiteParameter("@ngaySinh", obj_CaNhan.NgaySinh));
cm.Parameters.Add(new SQLiteParameter("@chucDanh", obj_CaNhan.ChucDanh));
cm.Parameters.Add(new SQLiteParameter("@chucVu", obj_CaNhan.ChucVu));
cm.Parameters.Add(new SQLiteParameter("@email", obj_CaNhan.Email));
cm.Parameters.Add(new SQLiteParameter("@phone", obj_CaNhan.Phone));
int i = -1;
if (DbAccess.OpenConnection())
{
i = cm.ExecuteNonQuery();
DbAccess.CloseConnection();
}
if (i == 1)
{
DataRow item = LocalTable.NewRow();
item[0] = obj_CaNhan.ID;
item[1] = obj_CaNhan.ID_DonVi;
item[2] = obj_CaNhan.HoTen;
item[3] = obj_CaNhan.GioiTinh;
item[4] = obj_CaNhan.NgaySinh;
item[5] = obj_CaNhan.ChucDanh;
item[6] = obj_CaNhan.ChucVu;
item[7] = obj_CaNhan.Email;
item[8] = obj_CaNhan.Phone;
LocalTable.Rows.Add(item);
LocalTable.AcceptChanges();
}
return(i);
}
public int Delete(Obj_GioiTinh obj_GioiTinh)
{
SQLiteCommand cm = new SQLiteCommand(DbAccess.DatabaseConnection);
cm.CommandType = CommandType.Text;
cm.CommandText = "DELETE FROM " + LocalTable.TableName + " WHERE id = " + obj_GioiTinh.ID;
DbAccess.OpenConnection();
int i = cm.ExecuteNonQuery();
DbAccess.CloseConnection();
return(i);
}
public int Delete(string whereCondition)
{
SQLiteCommand cm = new SQLiteCommand(DbAccess.DatabaseConnection);
cm.CommandType = CommandType.Text;
cm.CommandText = "DELETE FROM " + LocalTable.TableName + " WHERE " + whereCondition;
DbAccess.OpenConnection();
int i = cm.ExecuteNonQuery();
DbAccess.CloseConnection();
return(i);
}
public long GetNextID()
{
SQLiteCommand cm = new SQLiteCommand(DbAccess.DatabaseConnection);
cm.CommandType = CommandType.Text;
cm.CommandText = "SELECT IFNULL(MAX(id), -1) FROM " + LocalTable.TableName;
DbAccess.OpenConnection();
long i = (long)cm.ExecuteScalar();
DbAccess.CloseConnection();
return(i + 1);
}
public int Update(Obj_DonVi obj_DonVi)
{
SQLiteCommand cm = new SQLiteCommand(DbAccess.DatabaseConnection);
cm.CommandType = CommandType.Text;
cm.CommandText = "UPDATE " + LocalTable.TableName +
" SET " +
"loai = @loai, " +
"tenDonVi = @tenDonVi, " +
"diaDiem = @diaDiem, " +
"email = @email, " +
"phone = @phone, " +
"trangThai = @trangThai" +
" WHERE id = @id";
cm.Parameters.Add(new SQLiteParameter("@loai", obj_DonVi.Loai));
cm.Parameters.Add(new SQLiteParameter("@tenDonVi", obj_DonVi.TenDonVi));
cm.Parameters.Add(new SQLiteParameter("@diaDiem", obj_DonVi.DiaDiem));
cm.Parameters.Add(new SQLiteParameter("@email", obj_DonVi.Email));
cm.Parameters.Add(new SQLiteParameter("@phone", obj_DonVi.Phone));
cm.Parameters.Add(new SQLiteParameter("@trangThai", obj_DonVi.TrangThai));
cm.Parameters.Add(new SQLiteParameter("@id", obj_DonVi.ID));
DbAccess.OpenConnection();
int i = cm.ExecuteNonQuery();
DbAccess.CloseConnection();
if (i == 1)
{
foreach (DataRow item in LocalTable.Rows)
{
if ((long)item[0] == obj_DonVi.ID)
{
item[1] = obj_DonVi.Loai;
item[2] = obj_DonVi.TenDonVi;
item[3] = obj_DonVi.DiaDiem;
item[4] = obj_DonVi.Email;
item[5] = obj_DonVi.Phone;
item[6] = obj_DonVi.TrangThai;
LocalTable.AcceptChanges();
break;
}
}
}
return(i);
}
public int Update(Obj_HoSoThiDua obj)
{
SQLiteCommand cm = new SQLiteCommand(DbAccess.DatabaseConnection);
cm.CommandType = CommandType.Text;
cm.CommandText = "UPDATE " + LocalTable.TableName +
" SET " +
"idCaNhan = @idCaNhan , " +
"idDonVi = @idDonVi , " +
"nam = @nam , " +
"danhHieuDangKy = @danhHieuDangKy , " +
"danhHieuDatDuoc = @danhHieuDatDuoc " +
"WHERE id = @id";
cm.Parameters.Add(new SQLiteParameter("@idCaNhan", obj.IDCaNhan));
cm.Parameters.Add(new SQLiteParameter("@idDonVi", obj.IDDonVi));
cm.Parameters.Add(new SQLiteParameter("@nam", obj.Nam));
cm.Parameters.Add(new SQLiteParameter("@danhHieuDangKy", obj.DanhHieuDangKy));
cm.Parameters.Add(new SQLiteParameter("@danhHieuDatDuoc", obj.DanhHieuDatDuoc));
cm.Parameters.Add(new SQLiteParameter("@id", obj.ID));
int i = -1;
DbAccess.OpenConnection();
i = cm.ExecuteNonQuery();
DbAccess.CloseConnection();
//update to localtable
if (i == 1)
{
foreach (DataRow r in LocalTable.Rows)
{
if ((long)r[0] == obj.ID)
{
r["idCaNhan"] = obj.IDCaNhan;
r["idDonVi"] = obj.IDDonVi;
r["nam"] = obj.Nam;
r["danhHieuDangKy"] = obj.DanhHieuDangKy;
r["danhHieuDatDuoc"] = obj.DanhHieuDatDuoc;
LocalTable.AcceptChanges();
break;
}
}
}
return(i);
}
public bool CheckExisted(long idCaNhan, long nam)
{
SQLiteCommand cm = new SQLiteCommand(DbAccess.DatabaseConnection);
cm.CommandType = CommandType.Text;
cm.CommandText = "SELECT COUNT(id) FROM " + LocalTable.TableName + " WHERE idCaNhan = @idCaNhan AND nam = @nam";
cm.Parameters.Add(new SQLiteParameter("@idCaNhan", idCaNhan));
cm.Parameters.Add(new SQLiteParameter("@nam", nam));
int i = -1;
DbAccess.OpenConnection();
i = (int)cm.ExecuteScalar();
DbAccess.CloseConnection();
return(i >= 1);
}
public int Insert(Obj_DonVi obj_DonVi)
{
SQLiteCommand cm = new SQLiteCommand(DbAccess.DatabaseConnection);
cm.CommandType = CommandType.Text;
cm.CommandText = "INSERT INTO " + LocalTable.TableName +
" VALUES (" +
"@id, " +
"@loai, " +
"@tenDonVi, " +
"@diaDiem, " +
"@email, " +
"@phone, " +
"@trangThai)";
cm.Parameters.Add(new SQLiteParameter("@id", obj_DonVi.ID));
cm.Parameters.Add(new SQLiteParameter("@loai", obj_DonVi.Loai));
cm.Parameters.Add(new SQLiteParameter("@tenDonVi", obj_DonVi.TenDonVi));
cm.Parameters.Add(new SQLiteParameter("@diaDiem", obj_DonVi.DiaDiem));
cm.Parameters.Add(new SQLiteParameter("@email", obj_DonVi.Email));
cm.Parameters.Add(new SQLiteParameter("@phone", obj_DonVi.Phone));
cm.Parameters.Add(new SQLiteParameter("@trangThai", obj_DonVi.TrangThai));
DbAccess.OpenConnection();
int i = cm.ExecuteNonQuery();
DbAccess.CloseConnection();
if (i == 1)
{
DataRow item = LocalTable.NewRow();
item[0] = obj_DonVi.ID;
item[1] = obj_DonVi.Loai;
item[2] = obj_DonVi.TenDonVi;
item[3] = obj_DonVi.DiaDiem;
item[4] = obj_DonVi.Email;
item[5] = obj_DonVi.Phone;
item[6] = obj_DonVi.TrangThai;
LocalTable.Rows.Add(item);
LocalTable.AcceptChanges();
}
return(i);
}
public int Update(Obj_TieuChi obj)
{
SQLiteCommand command = new SQLiteCommand(DbAccess.DatabaseConnection);
command.CommandType = CommandType.Text;
command.CommandText = "UPDATE " + LocalTable.TableName + " SET " +
"ten = @ten, " +
"moTa = @moTa, " +
"ghiChu = @ghiChu " +
"WHERE id = @id";
command.Parameters.Add(new SQLiteParameter("@ten", obj.Ten));
command.Parameters.Add(new SQLiteParameter("@moTa", obj.MoTa));
command.Parameters.Add(new SQLiteParameter("@ghiChu", obj.GhiChu));
command.Parameters.Add(new SQLiteParameter("@id", obj.ID));
int i = -1;
try
{
DbAccess.OpenConnection();
i = command.ExecuteNonQuery();
}
finally
{
DbAccess.CloseConnection();
if (i == 1)
{
foreach (DataRow item in LocalTable.Rows)
{
if ((long)item["id"] == obj.ID)
{
item["ten"] = obj.Ten;
item["moTa"] = obj.MoTa;
item["ghiChu"] = obj.GhiChu;
break;
}
}
}
}
return(i);
}
public int Update(Obj_GioiTinh obj_GioiTinh)
{
SQLiteCommand cm = new SQLiteCommand(DbAccess.DatabaseConnection);
cm.CommandType = CommandType.Text;
cm.CommandText = "UPDATE " + LocalTable.TableName + " SET " +
"gioitinh = @gioiTinh, " +
"trangThai = @trangThai " +
" WHERE id = @id";
cm.Parameters.Add(new SQLiteParameter("@gioiTinh", obj_GioiTinh.GioiTinh));
cm.Parameters.Add(new SQLiteParameter("@trangThai", obj_GioiTinh.TrangThai));
cm.Parameters.Add(new SQLiteParameter("@id", obj_GioiTinh.ID));
DbAccess.OpenConnection();
int i = cm.ExecuteNonQuery();
DbAccess.CloseConnection();
return(i);
}
public int Insert(Obj_GioiTinh obj_GioiTinh)
{
SQLiteCommand cm = new SQLiteCommand(DbAccess.DatabaseConnection);
cm.CommandType = CommandType.Text;
cm.CommandText = "INSERT INTO " + LocalTable.TableName + " VALUES (" +
"@id, " +
"@gioiTinh, " +
"@trangThai)";
cm.Parameters.Add(new SQLiteParameter("@id", obj_GioiTinh.ID));
cm.Parameters.Add(new SQLiteParameter("@gioiTinh", obj_GioiTinh.GioiTinh));
cm.Parameters.Add(new SQLiteParameter("@trangThai", obj_GioiTinh.TrangThai));
DbAccess.OpenConnection();
int i = cm.ExecuteNonQuery();
DbAccess.CloseConnection();
return(i);
}
public int Insert(Obj_TieuChi obj)
{
SQLiteCommand cm = new SQLiteCommand(DbAccess.DatabaseConnection);
cm.CommandType = CommandType.Text;
cm.CommandText = "INSERT INTO " + LocalTable.TableName + " VALUES (" +
"@id, " +
"@nam, " +
"@ten, " +
"@moTa, " +
"@ghiChu)";
cm.Parameters.Add(new SQLiteParameter("@id", obj.ID));
cm.Parameters.Add(new SQLiteParameter("@nam", obj.Nam));
cm.Parameters.Add(new SQLiteParameter("@ten", obj.Ten));
cm.Parameters.Add(new SQLiteParameter("@moTa", obj.MoTa));
cm.Parameters.Add(new SQLiteParameter("@ghiChu", obj.GhiChu));
int i = -1;
try
{
DbAccess.OpenConnection();
i = cm.ExecuteNonQuery();
}
finally
{
DbAccess.CloseConnection();
if (i == 1)
{
DataRow r = LocalTable.NewRow();
r["id"] = obj.ID;
r["ten"] = obj.Ten;
r["moTa"] = obj.MoTa;
r["ghiChu"] = obj.GhiChu;
LocalTable.Rows.Add(r);
}
}
return(i);
}
public int Insert(Obj_HoSoThiDua obj)
{
SQLiteCommand cm = new SQLiteCommand(DbAccess.DatabaseConnection);
cm.CommandType = CommandType.Text;
cm.CommandText = "INSERT INTO " + LocalTable.TableName + " VALUES (" +
"@id, " +
"@idCaNhan, " +
"@idDonVi, " +
"@nam, " +
"@danhHieuDangKy, " +
"@danhHieuDatDuoc)";
cm.Parameters.Add(new SQLiteParameter("@id", obj.ID));
cm.Parameters.Add(new SQLiteParameter("@idCaNhan", obj.IDCaNhan));
cm.Parameters.Add(new SQLiteParameter("@idDonVi", obj.IDDonVi));
cm.Parameters.Add(new SQLiteParameter("@nam", obj.Nam));
cm.Parameters.Add(new SQLiteParameter("@danhHieuDangKy", obj.DanhHieuDangKy));
cm.Parameters.Add(new SQLiteParameter("@danhHieuDatDuoc", obj.DanhHieuDatDuoc));
int i = -1;
DbAccess.OpenConnection();
i = cm.ExecuteNonQuery();
DbAccess.CloseConnection();
if (i == 1)
{
DataRow nr = LocalTable.NewRow();
nr["id"] = obj.ID;
nr["idCaNhan"] = obj.IDCaNhan;
nr["idDonVi"] = obj.IDDonVi;
nr["nam"] = obj.Nam;
nr["danhHieuDangKy"] = obj.DanhHieuDangKy;
nr["danhHieuDatDuoc"] = obj.DanhHieuDatDuoc;
LocalTable.Rows.Add(nr);
}
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 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);
}