private void bwAsync_Worker(object sender, DoWorkEventArgs e)
{
ProcessingType type = (ProcessingType)e.Argument;
e.Result = type;
switch (type)
{
case ProcessingType.SaveData:
{
if (mDM_Entity_Type.DM_Entity_TypeID > 0)
{
DM_Entity_TypePresenter.UpdateDM_Entity_Type(mDM_Entity_Type);
}
else
{
if (DM_Entity_TypePresenter.InsertDM_Entity_Type(mDM_Entity_Type) > 0)
{
//Tăng số ID lên
mDM_Entity_Type.DM_Entity_TypeID = mDM_Entity_Type.DM_Entity_TypeDBID + 500 + mDM_Entity_Type.DM_Intent_TypeID * 1000;
DM_Entity_TypePresenter.UpdateDM_Entity_Type(mDM_Entity_Type);
}
}
}
break;
default:
break;
}
}
private void bwAsync_DoWork(object sender, DoWorkEventArgs e)
{
Stopwatch mStopWatch = new Stopwatch();
mStopWatch.Start();
SanitaLogEx.d(TAG, "Start database cache...");
PostMessage("Start database cache ...");
IsCacheCompleted = false;
try
{
//Update timer
SystemInfo.NOW = SoftUpdatePresenter.GetCurrentTime(null, null);
//Kiểm tra và nâng cấp cấu trúc database
Splasher.Status = "Check and update database...";
SoftUpdatePresenter.DoUpdateDatabaseSQL();
using (IDbConnection connection = SoftUpdatePresenter.GetConnection())
{
//Open connection
connection.Open();
//Begin transtation
using (IDbTransaction trans = connection.BeginTransaction())
{
Splasher.Status = "Đang xử lý : Danh sách danh mục...".Translate();
DM_Intent_Type.InitDefaultList(DM_Intent_TypePresenter.GetDM_Intent_Types(connection, trans));
MyVar.mListDM_Intent_Type = DM_Intent_Type.GetDefaultList(0).OrderBy(p => p.DM_Intent_TypeID).ToList();
DM_Entity_Type.InitDefaultList(DM_Entity_TypePresenter.GetDM_Entity_Types(connection, trans));
MyVar.mListDM_Entity_Type = DM_Entity_Type.GetDefaultList(0).OrderBy(p => p.DM_Entity_TypeID).ToList();
MyVar.mListUser = UserPresenter.GetUsers(connection, trans);
MyVar.mListHome = HomePresenter.GetHomes(connection, trans);
MyVar.mListRoom = RoomPresenter.GetRooms(connection, trans);
MyVar.mListDevice = DevicePresenter.GetDevices(connection, trans);
//-----------------------------------------------------------------------------
//Commit transtation
trans.Commit();
//Close connection
connection.Close();
}
}
SanitaLogEx.d(TAG, "End database cache...");
}
catch (Exception ex)
{
SanitaLogEx.e(TAG, "bwAsync_DoWork error !", ex);
}
IsCacheCompleted = true;
}
private void btnXoa_Click(object sender, EventArgs e)
{
DM_Entity_Type data = mListViewData.SelectedObject as DM_Entity_Type;
if (data != null && data.DM_Entity_TypeDBID > 0)
{
if (SanitaMessageBox.Show("Bạn có chắc chắn muốn xóa không ?", "Thông Báo", System.Windows.Forms.MessageBoxButtons.YesNo, System.Windows.Forms.MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes)
{
if (DM_Entity_TypePresenter.DeleteDM_Entity_Type(data) > 0)
{
DoRefresh();
}
}
}
}
private void bwAsync_Worker(object sender, DoWorkEventArgs e)
{
ProcessingType type = (ProcessingType)e.Argument;
e.Result = type;
switch (type)
{
case ProcessingType.LoadData:
{
DM_Entity_Type.InitDefaultList(DM_Entity_TypePresenter.GetDM_Entity_Types(null, null));
mListData_Flat = DM_Entity_Type.GetDefaultList(1).OrderBy(p => p.DM_Entity_TypeID).ToList();
MyVar.mListDM_Entity_Type = DM_Entity_Type.GetDefaultList(0).OrderBy(p => p.DM_Entity_TypeID).ToList();
//Update dữ liệu
mListData = new List <DM_Entity_Type>();
foreach (DM_Intent_Type nhom_khoa in DM_Intent_Type.GetDefaultList(0))
{
if (mListData_Flat.Any(p => p.DM_Intent_TypeID == nhom_khoa.DM_Intent_TypeID))
{
DM_Entity_Type group_DM_Entity_Type = new DM_Entity_Type();
group_DM_Entity_Type.DM_Intent_TypeID = nhom_khoa.DM_Intent_TypeID;
group_DM_Entity_Type.DM_Entity_TypeDBID = -1;
group_DM_Entity_Type.DM_Entity_TypeName = nhom_khoa.DM_Intent_TypeName;
group_DM_Entity_Type.mListSubData = mListData_Flat.Where(p => p.DM_Intent_TypeID == nhom_khoa.DM_Intent_TypeID).ToList();
mListData.Add(group_DM_Entity_Type);
}
}
//Update danh sách
{
mListThongTinDanhSachDM_Entity_Type = new List <ThongTinDanhSachDM_Entity_Type>();
mListThongTinDanhSachDM_Entity_Type_Flat = new List <ThongTinDanhSachDM_Entity_Type>();
ThongTinDanhSachDM_Entity_Type.ThongTinDanhSachDM_Entity_TypeID_Index = 1;
//Add tất cả khoa
ThongTinDanhSachDM_Entity_Type root = new ThongTinDanhSachDM_Entity_Type();
root.ThongTinDanhSachDM_Entity_TypeType = (int)ThongTinDanhSachDM_Entity_Type.TYPE.ROOT;
root.mListData = mListData;
root.ThongTinDanhSachDM_Entity_TypeName = "Tất Cả Đối Tượng (" + mListData_Flat.Where(p => p.DM_Entity_TypeID > 0).Count() + ")";
mListThongTinDanhSachDM_Entity_Type.Add(root);
mListThongTinDanhSachDM_Entity_Type_Flat.Add(root);
}
foreach (DM_DM_Entity_Type_Group nhom_dich_vu in DM_DM_Entity_Type_Group.GetDefaultList(0))
{
ThongTinDanhSachDM_Entity_Type mData = new ThongTinDanhSachDM_Entity_Type();
mData.ThongTinDanhSachDM_Entity_TypeType = (int)ThongTinDanhSachDM_Entity_Type.TYPE.GROUP;
mData.DM_DM_Entity_Type_GroupID = nhom_dich_vu.DM_DM_Entity_Type_GroupID;
mData.mListSubData = new List <ThongTinDanhSachDM_Entity_Type>();
mData.mListData = mListData;
mData.ThongTinDanhSachDM_Entity_TypeName = DM_DM_Entity_Type_Group.GetDefault(mData.DM_DM_Entity_Type_GroupID).DM_DM_Entity_Type_GroupName;
//Add loại khoa
{
IList <DM_DM_Entity_Type_SubGroup> list_sub = DM_DM_Entity_Type_SubGroup.GetDefaultList_Group(0, mData.DM_DM_Entity_Type_GroupID);
foreach (DM_DM_Entity_Type_SubGroup sub_data in list_sub)
{
ThongTinDanhSachDM_Entity_Type mSubData = new ThongTinDanhSachDM_Entity_Type();
mSubData.ThongTinDanhSachDM_Entity_TypeType = (int)ThongTinDanhSachDM_Entity_Type.TYPE.SUB_GROUP;
mSubData.DM_DM_Entity_Type_GroupID = mData.DM_DM_Entity_Type_GroupID;
mSubData.DM_DM_Entity_Type_SubGroupID = sub_data.DM_DM_Entity_Type_SubGroupID;
mSubData.mListData = new List <DM_Entity_Type>();
mSubData.ThongTinDanhSachDM_Entity_TypeName = DM_DM_Entity_Type_SubGroup.GetDefault(mSubData.DM_DM_Entity_Type_SubGroupID).DM_DM_Entity_Type_SubGroupName;
//Loai
if (sub_data.DM_DM_Entity_Type_GroupID == DM_DM_Entity_Type_Group.INTENT)
{
int loai_khoa = sub_data.DM_DM_Entity_Type_SubGroupID - DM_DM_Entity_Type_SubGroup.INTENT_INIT;
mSubData.mListData = mListData_Flat.Where(p => p.DM_Intent_TypeID == loai_khoa).ToList();
}
//Check
if (mSubData.mListData.Count > 0)
{
mSubData.ThongTinDanhSachDM_Entity_TypeName += " (" + mSubData.mListData.Count + ")";
mData.mListSubData.Add(mSubData);
mListThongTinDanhSachDM_Entity_Type_Flat.Add(mSubData);
}
}
}
//Check
if (mData.mListData.Count > 0)
{
mListThongTinDanhSachDM_Entity_Type.Add(mData);
mListThongTinDanhSachDM_Entity_Type_Flat.Add(mData);
}
}
}
break;
default:
break;
}
}
