static void getWarning(string _type, ref List <warningItem> _lst) { switch (_type) { case "overdue_checkin": { DataTable dt = BusinessLogicBridge.DataStore.getRoomReserveLateCheckIn(); // foreach (DataRow dr in dt.Rows) { warningItem _item = new warningItem(); // //_item.list_date = DateTime.Parse(dr["reserve_check_in_date"].ToString()); _item.list_date = DateTime.Parse(dr["reserve_check_in_date"].ToString()).AddDays(1); // if (_item.list_date.Date == DateTime.Today.Date) { _item.new_item = " New! "; } _item.list_roomname = dr["room_label"].ToString(); _item.list_name = DXWindowsApplication2.MainForm.getLanguage("_warning_" + _type); _item.list_detail = string.Format(DXWindowsApplication2.MainForm.getLanguage("_warning_detail_" + _type), dr["reserve_check_in_date"].To <DateTime>().ToString(MainForm.SX_DateFormat(2))); _item.list_help = DXWindowsApplication2.MainForm.getLanguage("_warning_help_" + _type); // _lst.Add(_item); } // break; } case "overdue_checkout": { DataTable dt = BusinessLogicBridge.DataStore.getLeavesLateCheckOut(); // foreach (DataRow dr in dt.Rows) { warningItem _item = new warningItem(); // //_item.list_date = DateTime.Parse(dr["leave_date"].ToString()); _item.list_date = DateTime.Parse(dr["leave_date"].ToString()).AddDays(1); if (_item.list_date.Date == DateTime.Today.Date) { _item.new_item = " New! "; } _item.list_roomname = dr["room_label"].ToString(); _item.list_name = DXWindowsApplication2.MainForm.getLanguage("_warning_" + _type); _item.list_detail = string.Format(DXWindowsApplication2.MainForm.getLanguage("_warning_detail_" + _type), dr["leave_date"].To <DateTime>().ToString(MainForm.SX_DateFormat(2))); _item.list_help = DXWindowsApplication2.MainForm.getLanguage("_warning_help_" + _type); // _lst.Add(_item); } // break; } case "endofbook": { DataTable dt = BusinessLogicBridge.DataStore.getRoomReserveLateReserveDate(); // foreach (DataRow dr in dt.Rows) { warningItem _item = new warningItem(); // //_item.list_date = DateTime.Parse(dr["reserve_end_date"].ToString()); _item.list_date = DateTime.Parse(dr["reserve_end_date"].ToString()).AddDays(1); // if (_item.list_date.Date == DateTime.Today.Date) { _item.new_item = " New! "; } _item.list_roomname = dr["room_label"].ToString(); _item.list_name = DXWindowsApplication2.MainForm.getLanguage("_warning_" + _type); _item.list_detail = string.Format(DXWindowsApplication2.MainForm.getLanguage("_warning_detail_" + _type), dr["reserve_end_date"].To <DateTime>().ToString(MainForm.SX_DateFormat(2))); _item.list_help = DXWindowsApplication2.MainForm.getLanguage("_warning_help_" + _type); // _lst.Add(_item); } // break; } case "billingdate": { int due_date = int.Parse(DXWindowsApplication2.MainForm.generalSettingTable.Rows[0]["due_date"].ToString()); // if (DateTime.Now.Day == due_date) { warningItem _item = new warningItem(); // _item.list_date = DateTime.Now; if (_item.list_date.Date == DateTime.Today.Date) { _item.new_item = " New! "; } _item.list_roomname = "-"; _item.list_name = DXWindowsApplication2.MainForm.getLanguage("_warning_" + _type); _item.list_detail = string.Format(DXWindowsApplication2.MainForm.getLanguage("_warning_detail_" + _type), due_date); _item.list_help = DXWindowsApplication2.MainForm.getLanguage("_warning_help_" + _type); // _lst.Add(_item); } // break; } //case "overdue_payment": // { // int payDate = int.Parse(DXWindowsApplication2.MainForm.generalSettingTable.Rows[0]["payment_date"].ToString()); // // // //if (DateTime.Now.Day == payDate || // // (DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month) < payDate && DateTime.Now.Day == DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month) // // )) // if (DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month) < payDate ) // { // warningItem _item = new warningItem(); // // // _item.list_date = DateTime.Now; // if (_item.list_date.Date == DateTime.Today.Date) // { // _item.new_item = " New! "; // } // _item.list_roomname = "-"; // _item.list_name = DXWindowsApplication2.MainForm.getLanguage("_warning_" + _type); // _item.list_detail = string.Format(DXWindowsApplication2.MainForm.getLanguage("_warning_detail_" + _type), payDate); // _item.list_help = DXWindowsApplication2.MainForm.getLanguage("_warning_help_" + _type); // // // _lst.Add(_item); // } // // // break; // } case "vacantroom": { double current_config = BusinessLogicBridge.DataStore.getWarningCurrentSetting(); DataTable dt = BusinessLogicBridge.DataStore.checkEMeterCurrentLeak(current_config); foreach (DataRow dr in dt.Rows) { warningItem _item = new warningItem(); // _item.list_date = DateTime.Now; if (_item.list_date.Date == DateTime.Today.Date) { _item.new_item = " New! "; } _item.list_roomname = dr["room_label"].ToString(); _item.list_name = DXWindowsApplication2.MainForm.getLanguage("_warning_" + _type); _item.list_detail = string.Format(DXWindowsApplication2.MainForm.getLanguage("_warning_detail_" + _type), _item.list_date); _item.list_help = DXWindowsApplication2.MainForm.getLanguage("_warning_help_" + _type); // _lst.Add(_item); } break; } case "database": { // get size of database backup DataTable DBConfigInfo = BusinessLogicBridge.DataStore.getBackupConfig(); double WarnningDatabaseValueSize = BusinessLogicBridge.DataStore.getWarningDatabaseSetting(); long directorySize = GetDirectorySize(DBConfigInfo.Rows[0]["auto_dbpath"].ToString()); double DBValueMegabyte = ConvertGigabytesToMegabytes(WarnningDatabaseValueSize); // Megabyte long realDBValueMegabyteToByte = ConvertMegabytesTobytes(DBValueMegabyte); // check size actual if (directorySize >= realDBValueMegabyteToByte) { warningItem _item = new warningItem(); // _item.list_date = DateTime.Now; if (_item.list_date.Date == DateTime.Today.Date) { _item.new_item = " New! "; } _item.list_roomname = "-"; _item.list_name = DXWindowsApplication2.MainForm.getLanguage("_warning_" + _type); _item.list_detail = string.Format(DXWindowsApplication2.MainForm.getLanguage("_warning_detail_" + _type), _item.list_date); _item.list_help = DXWindowsApplication2.MainForm.getLanguage("_warning_help_" + _type); // _lst.Add(_item); } break; } default: { break; } } }
static void getWarning(string _type, ref List<warningItem> _lst) { switch (_type) { case "overdue_checkin": { DataTable dt = BusinessLogicBridge.DataStore.getRoomReserveLateCheckIn(); // foreach (DataRow dr in dt.Rows) { warningItem _item = new warningItem(); // //_item.list_date = DateTime.Parse(dr["reserve_check_in_date"].ToString()); _item.list_date = DateTime.Parse(dr["reserve_check_in_date"].ToString()).AddDays(1); // if (_item.list_date.Date == DateTime.Today.Date) { _item.new_item = " New! "; } _item.list_roomname = dr["room_label"].ToString(); _item.list_name = DXWindowsApplication2.MainForm.getLanguage("_warning_" + _type); _item.list_detail = string.Format(DXWindowsApplication2.MainForm.getLanguage("_warning_detail_" + _type), dr["reserve_check_in_date"].To<DateTime>().ToString(MainForm.SX_DateFormat(2))); _item.list_help = DXWindowsApplication2.MainForm.getLanguage("_warning_help_" + _type); // _lst.Add(_item); } // break; } case "overdue_checkout": { DataTable dt = BusinessLogicBridge.DataStore.getLeavesLateCheckOut(); // foreach (DataRow dr in dt.Rows) { warningItem _item = new warningItem(); // //_item.list_date = DateTime.Parse(dr["leave_date"].ToString()); _item.list_date = DateTime.Parse(dr["leave_date"].ToString()).AddDays(1); if (_item.list_date.Date == DateTime.Today.Date) { _item.new_item = " New! "; } _item.list_roomname = dr["room_label"].ToString(); _item.list_name = DXWindowsApplication2.MainForm.getLanguage("_warning_" + _type); _item.list_detail = string.Format(DXWindowsApplication2.MainForm.getLanguage("_warning_detail_" + _type), dr["leave_date"].To<DateTime>().ToString(MainForm.SX_DateFormat(2))); _item.list_help = DXWindowsApplication2.MainForm.getLanguage("_warning_help_" + _type); // _lst.Add(_item); } // break; } case "endofbook": { DataTable dt = BusinessLogicBridge.DataStore.getRoomReserveLateReserveDate(); // foreach (DataRow dr in dt.Rows) { warningItem _item = new warningItem(); // //_item.list_date = DateTime.Parse(dr["reserve_end_date"].ToString()); _item.list_date = DateTime.Parse(dr["reserve_end_date"].ToString()).AddDays(1); // if (_item.list_date.Date == DateTime.Today.Date) { _item.new_item = " New! "; } _item.list_roomname = dr["room_label"].ToString(); _item.list_name = DXWindowsApplication2.MainForm.getLanguage("_warning_" + _type); _item.list_detail = string.Format(DXWindowsApplication2.MainForm.getLanguage("_warning_detail_" + _type), dr["reserve_end_date"].To<DateTime>().ToString(MainForm.SX_DateFormat(2))); _item.list_help = DXWindowsApplication2.MainForm.getLanguage("_warning_help_" + _type); // _lst.Add(_item); } // break; } case "billingdate": { int due_date = int.Parse(DXWindowsApplication2.MainForm.generalSettingTable.Rows[0]["due_date"].ToString()); // if (DateTime.Now.Day == due_date) { warningItem _item = new warningItem(); // _item.list_date = DateTime.Now; if (_item.list_date.Date == DateTime.Today.Date) { _item.new_item = " New! "; } _item.list_roomname = "-"; _item.list_name = DXWindowsApplication2.MainForm.getLanguage("_warning_" + _type); _item.list_detail = string.Format(DXWindowsApplication2.MainForm.getLanguage("_warning_detail_" + _type), due_date); _item.list_help = DXWindowsApplication2.MainForm.getLanguage("_warning_help_" + _type); // _lst.Add(_item); } // break; } //case "overdue_payment": // { // int payDate = int.Parse(DXWindowsApplication2.MainForm.generalSettingTable.Rows[0]["payment_date"].ToString()); // // // //if (DateTime.Now.Day == payDate || // // (DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month) < payDate && DateTime.Now.Day == DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month) // // )) // if (DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month) < payDate ) // { // warningItem _item = new warningItem(); // // // _item.list_date = DateTime.Now; // if (_item.list_date.Date == DateTime.Today.Date) // { // _item.new_item = " New! "; // } // _item.list_roomname = "-"; // _item.list_name = DXWindowsApplication2.MainForm.getLanguage("_warning_" + _type); // _item.list_detail = string.Format(DXWindowsApplication2.MainForm.getLanguage("_warning_detail_" + _type), payDate); // _item.list_help = DXWindowsApplication2.MainForm.getLanguage("_warning_help_" + _type); // // // _lst.Add(_item); // } // // // break; // } case "vacantroom": { double current_config = BusinessLogicBridge.DataStore.getWarningCurrentSetting(); DataTable dt = BusinessLogicBridge.DataStore.checkEMeterCurrentLeak(current_config); foreach (DataRow dr in dt.Rows) { warningItem _item = new warningItem(); // _item.list_date = DateTime.Now; if (_item.list_date.Date == DateTime.Today.Date) { _item.new_item = " New! "; } _item.list_roomname = dr["room_label"].ToString(); _item.list_name = DXWindowsApplication2.MainForm.getLanguage("_warning_" + _type); _item.list_detail = string.Format(DXWindowsApplication2.MainForm.getLanguage("_warning_detail_" + _type), _item.list_date); _item.list_help = DXWindowsApplication2.MainForm.getLanguage("_warning_help_" + _type); // _lst.Add(_item); } break; } case "database": { // get size of database backup DataTable DBConfigInfo = BusinessLogicBridge.DataStore.getBackupConfig(); double WarnningDatabaseValueSize = BusinessLogicBridge.DataStore.getWarningDatabaseSetting(); long directorySize = GetDirectorySize(DBConfigInfo.Rows[0]["auto_dbpath"].ToString()); double DBValueMegabyte = ConvertGigabytesToMegabytes(WarnningDatabaseValueSize); // Megabyte long realDBValueMegabyteToByte = ConvertMegabytesTobytes(DBValueMegabyte); // check size actual if (directorySize >= realDBValueMegabyteToByte) { warningItem _item = new warningItem(); // _item.list_date = DateTime.Now; if (_item.list_date.Date == DateTime.Today.Date) { _item.new_item = " New! "; } _item.list_roomname = "-"; _item.list_name = DXWindowsApplication2.MainForm.getLanguage("_warning_" + _type); _item.list_detail = string.Format(DXWindowsApplication2.MainForm.getLanguage("_warning_detail_" + _type), _item.list_date); _item.list_help = DXWindowsApplication2.MainForm.getLanguage("_warning_help_" + _type); // _lst.Add(_item); } break; } default: { break; } } }