private void ctmnXoa_Click(object sender, EventArgs e)
{
string i = trvDonVi.SelectedNode.Text;
{
if (trvDonVi.SelectedNode.Level == 0)
{
if (MessageBox.Show("Xóa: " + i + " ?" + ((trvDonVi.SelectedNode.Level == 0) ? "\nCác cá nhân thuộc đơn vị này sẽ chuyển vào nhóm chưa phân loại [...]" : ""),
"THÔNG BÁO", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) == DialogResult.OK)
{
Obj_DonVi o = MyMainForm.CreateObjDonVi((long)trvDonVi.SelectedNode.Tag);
int c = MyMainForm.DonVi.Delete(o);
RefreshTreeNode();
}
}
else
{
if (MessageBox.Show("Xóa: " + i + " ?" + ((trvDonVi.SelectedNode.Level == 0) ? "\nHồ sơ thi đua của thành viên này cũng sẽ bị xóa!" : ""),
"THÔNG BÁO", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning) == DialogResult.OK)
{
Obj_CaNhan o = MyMainForm.CreateObjCaNhan((long)trvDonVi.SelectedNode.Tag);
int c = MyMainForm.CaNhan.Delete(o);
if (c == 1)
{
trvDonVi.SelectedNode.Remove();
}
//RefreshTreeNode();
}
}
}
}
public int Delete(Obj_DonVi obj_DonVi)
{
SQLiteCommand cm = new SQLiteCommand(DbAccess.DatabaseConnection);
cm.CommandType = CommandType.Text;
cm.CommandText = "DELETE FROM " + LocalTable.TableName + " WHERE 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)
{
LocalTable.Rows.Remove(item);
LocalTable.AcceptChanges();
break;
}
}
}
return(i);
}
public int Delete(Obj_DonVi obj_DonVi)
{
if (obj_DonVi.ID == 0)
{
return(-1);
}
return(DonVi.Delete(obj_DonVi));
}
public Obj_DonVi CreateObjDonVi(DataRow row)
{
Obj_DonVi o = new Obj_DonVi()
{
ID = (long)row["id"],
Loai = (row["loai"] == DBNull.Value) ? "" : row["loai"].ToString(),
TenDonVi = (row["tenDonVi"] == DBNull.Value) ? "" : row["tenDonVi"].ToString(),
DiaDiem = (row["diaDiem"] == DBNull.Value) ? "" : row["diaDiem"].ToString(),
Email = (row["email"] == DBNull.Value) ? "" : row["email"].ToString(),
Phone = (row["phone"] == DBNull.Value) ? "" : row["phone"].ToString(),
TrangThai = (row["trangThai"] == DBNull.Value) ? false : true
};
return(o);
}
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 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);
}
private void trvDonVi_AfterSelect(object sender, TreeViewEventArgs e)
{
if (e.Node == null)
{
return;
}
dynamic o;
if (e.Node.Level == 0)
{
o = MyMainForm.CreateObjDonVi((long)e.Node.Tag);
if (MyMainForm.FormDonVi != null && !MyMainForm.FormDonVi.IsDisposed && (long)e.Node.Tag != 0)
{
MyMainForm.FormDonVi.ObjDonVi = o;
MyMainForm.FormDonVi.IsEditMode = true;
}
}
else
{
o = MyMainForm.CreateObjCaNhan((long)e.Node.Tag);
if (MyMainForm.FormCaNhan != null && !MyMainForm.FormCaNhan.IsDisposed)
{
MyMainForm.FormCaNhan.ObjCaNhan = o;
MyMainForm.FormCaNhan.IsEditMode = true;
}
Obj_DonVi p = MyMainForm.CreateObjDonVi((long)e.Node.Parent.Tag);
if (MyMainForm.FormDonVi != null && !MyMainForm.FormDonVi.IsDisposed && (long)e.Node.Parent.Tag != 0)
{
MyMainForm.FormDonVi.ObjDonVi = p;
MyMainForm.FormDonVi.IsEditMode = true;
}
}
StringBuilder s = new StringBuilder();
s.Append((e.Node.Level == 0) ? "[ID: G-" : "[ID: P-");
s.Append(string.Format("{0:000}", o.ID) + "] ");
s.Append("[Phone: " + o.Phone + "] " + "[Email:" + o.Email + "]");
lbl_CaNhanTapThe.Text = s.ToString();
}
public int UpdateInfo(Obj_DonVi obj_DonVi)
{
return(DonVi.Update(obj_DonVi));
}
public int Insert(Obj_DonVi obj_DonVi)
{
return(DonVi.Insert(obj_DonVi));
}
