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