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