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)); }