public static void ExitRoom() { if (Program.CurrentRoom != null && Program.CurrentUser != null && Class.ClsManageUserLogin.current_log != null) { InhCheckupDataContext dbc = new InhCheckupDataContext(); //log_user_login currentloguserlogin = (from t1 in dbc.log_user_logins // where t1.mrd_id == Program.CurrentRoom.mrd_id // && t1.mut_id == Program.CurrentUser.mut_id // && t1.lug_end_date == null // select t1).FirstOrDefault(); log_user_login currentloguserlogin = dbc.log_user_logins.Where(x => x.lug_id == Class.ClsManageUserLogin.current_log.lug_id).FirstOrDefault(); if (currentloguserlogin != null) { currentloguserlogin.lug_end_date = Program.GetServerDateTime(); } mst_user_type CurrentUser = (from t1 in dbc.mst_user_types where t1.mut_id == Program.CurrentUser.mut_id select t1).FirstOrDefault(); CurrentUser.mut_login_status = get_mutLoginStatus; dbc.SubmitChanges(); Program.CurrentUser = CurrentUser; mst_room_dtl currentroom = (from t1 in dbc.mst_room_dtls where t1.mrd_id == Program.CurrentRoom.mrd_id select t1).FirstOrDefault(); if (currentroom != null) { currentroom.mrd_rm_status = 'E'; dbc.SubmitChanges(); } } get_mutLoginStatus = '0'; Class.ClsManageUserLogin.current_log = null; Program.CurrentRegis = null; Program.CurrentRoom = null; GC.Collect(); //คำสั่ง Clear Memory ที่เคยเรียก data base มาใช้งาน AlertOutDepartment.StopTime(); //ปิดการทำงานการเตือน Out Department }
static void Main() { System.Threading.Thread.CurrentThread.CurrentCulture = System.Globalization.CultureInfo.CreateSpecificCulture("en-US"); if (new PrePareData.PrepareDataCls().Prepared()) { Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); AlertOutDepartment.prepairTimer(); Application.Run(new frmMain()); } else { MessageBox.Show("Connection Database Fail.", "EMR Checkup Pathway"); } }