public void Insert(AllLogDTO dto) { SharedPreference.Instance.DBM.SqlConn.Open(); string query = $"INSERT INTO tbl_all_log (admin, what, log, reason, update_date) VALUES ('{dto.ALLLOG_ADMIN}', '{dto.ALLLOG_WHAT}', '{dto.ALLLOG_LOG}', '{dto.ALLLOG_REASON}', '{dto.ALLLOG_UPDATE_DATE}');"; SharedPreference.Instance.DBM.SqlComm.CommandText = query; SharedPreference.Instance.DBM.SqlComm.ExecuteNonQuery(); SharedPreference.Instance.DBM.SqlConn.Close(); }
/// <summary> /// 로그인 /// </summary> public bool Login(string id, string pwd) { var sqlData = new AdminQuery().SelectWithId(id, pwd); if (sqlData.HasRows) { sqlData.Read(); AdminDTO dto = new AdminDTO { ADMIN_NUM = Int32.Parse(sqlData["num"].ToString()), ADMIN_ID = sqlData["id"].ToString(), ADMIN_PASSWORD = sqlData["password"].ToString(), ADMIN_IDNUMBER = sqlData["idnumber"].ToString(), ADMIN_NAME = sqlData["name"].ToString(), ADMIN_RANK = sqlData["rank"].ToString(), ADMIN_AUTH = sqlData["auth"].ToString(), ADMIN_GRADE = sqlData["grade"].ToString() }; SharedPreference.Instance.LoginAdmin = new AdminModel(dto); SharedPreference.Instance.IsLoginCompleted = true; SharedPreference.Instance.IsManagement = true; sqlData.Close(); SharedPreference.Instance.DBM.SqlConn.Close(); try { AllLogDTO logDto = new AllLogDTO { ALLLOG_ADMIN = id, ALLLOG_WHAT = "관리자 로그인", ALLLOG_LOG = "관리자 로그인", ALLLOG_REASON = "관리자 로그인", ALLLOG_UPDATE_DATE = DateTime.Now.ToString() }; new AllLogQuery().Insert(logDto); } catch (Exception e) { SharedPreference.Instance.DBM.SqlConn.Close(); MessageBox.Show("관리자 로그인 실패\n에러 내용 : " + e.Message); } return(true); } else { SharedPreference.Instance.IsLoginCompleted = false; sqlData.Close(); SharedPreference.Instance.DBM.SqlConn.Close(); return(false); } } // end method
} // end method /// <summary> /// 로그아웃 /// </summary> public void Logout() { try { AllLogDTO logDto = new AllLogDTO { ALLLOG_ADMIN = SharedPreference.Instance.LoginAdmin.ADMIN_ID, ALLLOG_WHAT = "관리자 로그아웃", ALLLOG_LOG = "관리자 로그아웃", ALLLOG_REASON = "관리자 로그아웃", ALLLOG_UPDATE_DATE = DateTime.Now.ToString() }; new AllLogQuery().Insert(logDto); SharedPreference.Instance.IsLoginCompleted = false; SharedPreference.Instance.LoginAdmin = null; } catch (Exception e) { SharedPreference.Instance.DBM.SqlConn.Close(); MessageBox.Show("관리자 로그아웃 실패\n에러 내용 : " + e.Message); } } // end method
public AllLogModel(AllLogDTO dto) { this.Dto = dto; }