private static jpuser ReaderDatajpuser(MySqlDataReader reader) { jpuser objjpuser = new jpuser(); objjpuser.USERID = Utility.IsValidInt(reader["USERID"]); objjpuser.EMAIL = Utility.IsValidString(reader["EMAIL"]); objjpuser.PASSWORD = Utility.IsValidString(reader["PASSWORD"]); objjpuser.USERNAME = Utility.IsValidString(reader["USERNAME"]); objjpuser.ACTIVE = Utility.IsValidString(reader["ACTIVE"]); return(objjpuser); }
public static List <jpuser> Getjpuser(string whereclause, MySqlConnection conn = null) { jpuser objjpuser = null; List <jpuser> lstjpuser = new List <jpuser>(); try { bool isConnArgNull = (conn != null) ? false : true; MySqlConnection connection = (conn != null) ? conn : PrimaryConnection(); tryOpenConnection(connection); string sql = "select * from jpuser"; if (!string.IsNullOrEmpty(whereclause)) { sql += " where " + whereclause; } using (MySqlCommand command = new MySqlCommand()) { command.Connection = connection; command.CommandText = sql; using (MySqlDataReader reader = command.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { objjpuser = ReaderDatajpuser(reader); lstjpuser.Add(objjpuser); } } else { } } } if (isConnArgNull == true) { connection.Dispose(); } } catch (Exception ex) { Logger._log.Error(ex.Message + "\n" + ex.StackTrace); } return(lstjpuser); }
public static string Savejpuser(jpuser objjpuser, MySqlConnection conn = null, MySqlTransaction trans = null) { string returnMessage = ""; string sUSERID = ""; sUSERID = objjpuser.USERID.ToString(); var templstjpuser = Getjpuser("USERID = '" + sUSERID + "'", conn); try { bool isConnArgNull = (conn != null) ? false : true; MySqlConnection connection = (conn != null) ? conn : PrimaryConnection(); tryOpenConnection(connection); using (MySqlCommand command = new MySqlCommand()) { string sql; bool isEdit = true; if (templstjpuser.Count <= 0) { isEdit = false; sql = @"INSERT INTO jpuser( EMAIL, PASSWORD, USERNAME, ACTIVE ) VALUES( @EMAIL, @PASSWORD, @USERNAME, @ACTIVE )"; } else { sql = @"Update jpuser set USERID=@USERID, EMAIL=@EMAIL, PASSWORD=@PASSWORD, USERNAME=@USERNAME, ACTIVE=@ACTIVE Where USERID=@USERID"; } if (trans != null) { command.Transaction = trans; } command.Connection = connection; command.CommandType = CommandType.Text; command.CommandText = sql; if (isEdit) { command.Parameters.AddWithValue("@USERID", objjpuser.USERID); } command.Parameters.AddWithValue("@EMAIL", objjpuser.EMAIL); command.Parameters.AddWithValue("@PASSWORD", objjpuser.PASSWORD); command.Parameters.AddWithValue("@USERNAME", objjpuser.USERNAME); command.Parameters.AddWithValue("@ACTIVE", objjpuser.ACTIVE); int affectedRows = command.ExecuteNonQuery(); var lastInsertID = command.LastInsertedId; if (affectedRows > 0) { if (!isEdit) { returnMessage = lastInsertID.ToString(); } else { returnMessage = "OK"; } } else { returnMessage = Shared.Constants.MSG_ERR_DBSAVE.Text; } } if (isConnArgNull == true) { connection.Dispose(); } } catch (Exception ex) { Logger._log.Error(ex.Message + "\n" + ex.StackTrace); } return(returnMessage); }