public int AddLogUser(LogUser Record) { connect(); string sql = String.Format("INSERT INTO `log_user` (`Time`,`UserID`,`Action`) VALUE ('{0}','{1}','{2}');", Record.Time.ToString("yyyy-MM-dd HH:mm:ss"), Record.UserID, Record.Action); MySqlCommand cmd = new MySqlCommand(sql, conn); int result = cmd.ExecuteNonQuery(); return result; }
public int AddLogUser(LogUser Record) { connect(); string sql = String.Format("INSERT INTO `log_user` (`Time`,`UserID`,`Action`) VALUE ('{0}','{1}','{2}');", Record.Time.ToString("yyyy-MM-dd HH:mm:ss"), Record.UserID, Record.Action); MySqlCommand cmd = new MySqlCommand(sql, conn); int result = cmd.ExecuteNonQuery(); return(result); }
public LogUser FindLogUser(int ID) { connect(); string sql = String.Format("SELECT * FROM `log_user` WHERE `ID`={0};", ID); MySqlCommand cmd = new MySqlCommand(sql, conn); MySqlDataReader rdr = cmd.ExecuteReader(); rdr.Read(); LogUser Record = new LogUser() { ID = (int)rdr["ID"], Time = (DateTime)rdr["Time"], UserID = (int)rdr["UserID"], Action = (string)rdr["Action"] }; rdr.Close(); return(Record); }
public int AddLogUser(LogUser Record) { DatabaseConnector dc = new DatabaseConnector(); return(dc.AddLogUser(Record)); }
public LogUser FindLogUser(int ID) { connect(); string sql = String.Format("SELECT * FROM `log_user` WHERE `ID`={0};", ID); MySqlCommand cmd = new MySqlCommand(sql, conn); MySqlDataReader rdr = cmd.ExecuteReader(); rdr.Read(); LogUser Record = new LogUser() { ID = (int)rdr["ID"], Time = (DateTime)rdr["Time"], UserID = (int)rdr["UserID"], Action = (string)rdr["Action"] }; rdr.Close(); return Record; }
public int AddLogUser(LogUser Record) { DatabaseConnector dc = new DatabaseConnector(); return dc.AddLogUser(Record); }