public int Delete(Obj_HoSoThiDua obj_HSTD)
{
SQLiteCommand cm = new SQLiteCommand(DbAccess.DatabaseConnection);
cm.CommandType = CommandType.Text;
cm.CommandText = "DELETE FROM " + LocalTable.TableName + " WHERE id = " + obj_HSTD.ID;
DbAccess.OpenConnection();
int i = cm.ExecuteNonQuery();
DbAccess.CloseConnection();
if (i == 1)
{
foreach (DataRow item in LocalTable.Rows)
{
if ((long)item[0] == obj_HSTD.ID)
{
LocalTable.Rows.Remove(item);
LocalTable.AcceptChanges();
break;
}
}
}
return(i);
}
public Obj_HoSoThiDua CreateObjHoSoThiDua(long id)
{
foreach (DataRow item in LocalTable.Rows)
{
if ((long)item[0] == id)
{
Obj_HoSoThiDua o = CreateObjHoSoThiDua(item);
return(o);
}
}
return(null);
}
public Obj_HoSoThiDua CreateObjHoSoThiDua(DataRow dataRow)
{
Obj_HoSoThiDua o = new Obj_HoSoThiDua()
{
ID = (long)dataRow["id"],
IDCaNhan = (long)dataRow["idCaNhan"],
IDDonVi = (long)dataRow["idDonVi"],
Nam = (long)dataRow["nam"],
DanhHieuDangKy = (byte)dataRow["danhHieuDangKy"],
DanhHieuDatDuoc = (byte)dataRow["danhHieuDatDuoc"],
};
return(o);
}
private void LocalTable_RowDeleted(object sender, DataRowChangeEventArgs e)
{
if (HoSoThiDua == null)
{
return;
}
foreach (DataRow item in HoSoThiDua.LocalTable.Rows)
{
long i = (long)e.Row["id"];
if ((long)item["idCaNhan"] == i)
{
Obj_HoSoThiDua obj_HSTD = HoSoThiDua.CreateObjHoSoThiDua(item);
HoSoThiDua.Delete(obj_HSTD);
}
}
}
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 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);
}
//Set CaNhan records to defaul value when delete a record
private void LocalTable_RowDeleted(object sender, DataRowChangeEventArgs e)
{
if (CaNhan == null)
{
return;
}
DataTable DtbCaNhan = CaNhan.LocalTable;
DataTable DtbHoSoThiDua = HoSoThiDua.LocalTable;
//handle on relation with CaNhan datatable
if (DtbCaNhan != null)
{
foreach (DataRow item in DtbCaNhan.Rows)
{
if ((long)item["idDonVi"] == (long)e.Row["id"])
{
var o = CaNhan.CreateObj(item);
o.ID_DonVi = 0;
CaNhan.Update(o);
}
}
}
//handle on relation with HSTD datatable
if (DtbHoSoThiDua != null)
{
foreach (DataRow item in DtbHoSoThiDua.Rows)
{
if ((long)item["idDonVi"] == (long)e.Row["id"])
{
Obj_HoSoThiDua obj_HSTD = HoSoThiDua.CreateObjHoSoThiDua(item);
obj_HSTD.IDDonVi = 0;
}
}
}
}
public int Delete(Obj_HoSoThiDua obj)
{
return(HoSoThiDua.Delete(obj));
}
public int Update(Obj_HoSoThiDua obj)
{
return(HoSoThiDua.Update(obj));
}
public int Insert(Obj_HoSoThiDua obj)
{
return(HoSoThiDua.Insert(obj));
}
