public bool addDetail(LogDetail detail) { if (detail.save()) { _details.Add(detail); return(true); } return(false); }
public bool logout() { if (_id < 1) { return(false); } string strSQL = "SELECT COUNT(1) FROM TblUserLog WHERE userLogID=" + _id; if (_conn.executeData(strSQL, Common.getCaller())) { DbDataReader dr = _conn.Reader; if (dr.HasRows) { dr.Read(); int rowCount = dr.GetInt32(0); dr.Close(); dr.Dispose(); if (rowCount < 1) { return(false); } strSQL = "SELECT sysdate FROM dual"; if (_conn.executeData(strSQL, Common.getCaller())) { dr = _conn.Reader; if (dr.HasRows) { dr.Read(); _end = dr.GetDateTime(0); dr.Close(); dr.Dispose(); strSQL = "UPDATE TblUserLog SET userLogEnd=" + _conn.formatDateTime(_end) + " WHERE userLogID=" + _id; if (_conn.executeSQL(strSQL, Common.getCaller())) { LogDetail detail = new LogDetail(this); detail.MenuID = 0; detail.SQLText = "Application log out."; if (detail.save()) { _details.Add(detail); return(true); } else { return(false); } } else { return(false); } } dr.Close(); dr.Dispose(); return(false); } } dr.Close(); dr.Dispose(); } return(false); }
public bool login(string username, string machineID) { if (Connection.formatValue(username) == "") { return(false); } if (Connection.formatValue(machineID) == "") { return(false); } string strSQL = "SELECT sysdate FROM dual"; if (_conn.executeData(strSQL, Common.getCaller())) { DbDataReader dr = _conn.Reader; if (dr.HasRows) { dr.Read(); _start = dr.GetDateTime(0); dr.Close(); dr.Dispose(); strSQL = "SELECT sqcUserLogID.nextVal FROM dual"; if (_conn.executeData(strSQL, Common.getCaller())) { dr = _conn.Reader; if (dr.HasRows) { dr.Read(); _id = dr.GetInt32(0); dr.Close(); dr.Dispose(); strSQL = "INSERT INTO TblUserLog VALUES(" + _id + ", '" + Connection.formatValue(username) + "', '" + Connection.formatValue(machineID) + "', to_date('" + _start.ToString("yyyy/MM/ss HH:mm:ss") + "', 'yyyy/mm/dd hh24:mi:ss'), NULL)"; if (_conn.executeSQL(strSQL, Common.getCaller())) { _details.Clear(); LogDetail detail = new LogDetail(this); detail.MenuID = 0; detail.SQLText = "Application log in"; if (detail.save()) { _details.Add(detail); return(true); } else { return(false); } } else { return(false); } } dr.Close(); dr.Dispose(); } } dr.Close(); dr.Dispose(); } return(false); }